SPSSX Discussion

Excel Output Export Waring Message

Classic

List

Threaded

6 messages Options

GauravSrivastava

Excel Output Export Waring Message

Hi All,

I am trying to export my analysis into an excel file and getting this warning message.

224 Output Export CREATESHEET was specified, but file "path+file.xlsx" does not exist.

Although It is exporting the output in excel but it's different than when I am copying manually and pasting in sheet.

Below is my syntax for export.

OUTPUT EXPORT
/CONTENTS EXPORT=ALL LAYERS=PRINTSETTING MODELVIEWS=PRINTSETTING
/XLSX DOCUMENTFILE='C:\Users\gsrivastava\Downloads\Data\2015\Analysis\Healthcare Analyses_US Index.xlsx'
OPERATION=MODIFYSHEET SHEET='Industry raw'
LOCATION=LASTCOLUMN NOTESCAPTIONS=YES.

Thanks
Gaurav

Mario Giesel

Re: Excel Output Export Waring Message

* Maybe a missing backslash?
GL,
  Mario.



  GauravSrivastava <[hidden email]> schrieb am 11:42 Mittwoch, 24.Juni 2015:
  


Hi All,

I am trying to export my analysis into an excel file and getting this
warning message.

*224 Output Export CREATESHEET was specified, but file "path+file.xlsx" does
not exist. *

Although It is exporting the output in excel but it's different than when I
am copying manually and pasting in sheet. 

Below is my syntax for export.

OUTPUT EXPORT
  /CONTENTS  EXPORT=ALL  LAYERS=PRINTSETTING  MODELVIEWS=PRINTSETTING
  /XLSX 
DOCUMENTFILE='C:\Users\gsrivastava\Downloads\Data\2015\Analysis\Healthcare
Analyses_US Index.xlsx'
     OPERATION=MODIFYSHEET  SHEET='Industry raw'
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Thanks
Gaurav



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Excel-Output-Export-Waring-Message-tp5729913.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

Mario Giesel
Munich, Germany

GauravSrivastava

Re: Excel Output Export Waring Message

Thanks Mario, But i don't think so. If this is the case (missing backslash), it wouldn't be pasting anything in file. as of now below syntax is good to export output file but with a warning message and without any format (all format is cleared from output file). basically I also need the format getting exported along with output.

Thanks!
Gaurav

MLIves

Re: Excel Output Export Waring Message

My guess is it would be the space between 'Healthcare' and 'Analyses'. Try removing that so they are on the same line.

DOCUMENTFILE='C:\Users\gsrivastava\Downloads\Data\2015\Analysis\Healthcare
Analyses_US Index.xlsx'

Melissa Ives
DMHAS Research Division
410 Capitol Ave., MS#14RSD
Hartford, CT 06106
860-418-6729 (phone)
860-418-6692 (fax)
860-778-5445 (cell)
________________________________________
From: SPSSX(r) Discussion <[hidden email]> on behalf of GauravSrivastava <[hidden email]>
Sent: Thursday, June 25, 2015 3:18 AM
To: [hidden email]
Subject: Re: [SPSSX-L] Excel Output Export Waring Message

Thanks Mario, But i don't think so. If this is the case (missing backslash),
it wouldn't be pasting anything in file. as of now below syntax is good to
export output file but with a warning message and without any format (all
format is cleared from output file). basically I also need the format
getting exported along with output.

Thanks!
Gaurav

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Excel-Output-Export-Waring-Message-tp5729913p5729934.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

________________________________

This correspondence contains proprietary information some or all of which may be legally privileged; it is for the intended recipient only. If you are not the intended recipient you must not use, disclose, distribute, copy, print, or rely on this correspondence and completely dispose of the correspondence immediately. Please notify the sender if you have received this email in error. NOTE: Messages to or from the State of Connecticut domain may be subject to the Freedom of Information statutes and regulations.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

GauravSrivastava

Re: Excel Output Export Waring Message

I don't think.. This is the case... When I am using operation=creatfile instead of modifysheet. It's working perfect.

So think... There is something wrong with modifysheet command.

Thanks
Gaurav

From: [hidden email]
Sent: ‎26-‎06-‎2015 19:19
To: [hidden email]; [hidden email]
Subject: RE: [SPSSX-L] Excel Output Export Waring Message

My guess is it would be the space between 'Healthcare' and 'Analyses'. Try removing that so they are on the same line.

DOCUMENTFILE='C:\Users\gsrivastava\Downloads\Data\2015\Analysis\Healthcare
Analyses_US Index.xlsx'

Melissa Ives
DMHAS Research Division
410 Capitol Ave., MS#14RSD
Hartford, CT 06106
860-418-6729 (phone)
860-418-6692 (fax)
860-778-5445 (cell)
________________________________________
From: SPSSX(r) Discussion <[hidden email]> on behalf of GauravSrivastava <[hidden email]>
Sent: Thursday, June 25, 2015 3:18 AM
To: [hidden email]
Subject: Re: [SPSSX-L] Excel Output Export Waring Message

Thanks Mario, But i don't think so. If this is the case (missing backslash),
it wouldn't be pasting anything in file. as of now below syntax is good to
export output file but with a warning message and without any format (all
format is cleared from output file). basically I also need the format
getting exported along with output.

Thanks!
Gaurav

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Excel-Output-Export-Waring-Message-tp5729913p5729934.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

________________________________

This correspondence contains proprietary information some or all of which may be legally privileged; it is for the intended recipient only. If you are not the intended recipient you must not use, disclose, distribute, copy, print, or rely on this correspondence and completely dispose of the correspondence immediately. Please notify the sender if you have received this email in error. NOTE: Messages to or from the State of Connecticut domain may be subject to the Freedom of Information statutes and regulations.

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

Rick Oliver-3

Re: Excel Output Export Waring Message

I don't know if this has any bearing on the problem, but ModifySheet is somewhat ill-behaved if the case of the sheet names don't match, and it creates a corrupted workbook if the sheet name in the workbook is something like "Sheet1" but you specify "sheet1" on ModifySheet.

Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]

From: Gaurav Srivastava <[hidden email]>
To: [hidden email]
Date: 06/27/2015 03:05 AM
Subject: Re: Excel Output Export Waring Message
Sent by: "SPSSX(r) Discussion" <[hidden email]>

I don't think.. This is the case... When I am using operation=creatfile instead of modifysheet. It's working perfect.

So think... There is something wrong with modifysheet command.

Thanks
Gaurav

From: Ives, Melissa L
Sent: ‎26-‎06-‎2015 19:19
To: [hidden email]; GauravSrivastava
Subject: RE: [SPSSX-L] Excel Output Export Waring Message

My guess is it would be the space between 'Healthcare' and 'Analyses'. Try removing that so they are on the same line.

DOCUMENTFILE='C:\Users\gsrivastava\Downloads\Data\2015\Analysis\Healthcare
Analyses_US Index.xlsx'

Melissa Ives
DMHAS Research Division
410 Capitol Ave., MS#14RSD
Hartford, CT 06106
860-418-6729 (phone)
860-418-6692 (fax)
860-778-5445 (cell)
________________________________________
From: SPSSX(r) Discussion <[hidden email]> on behalf of GauravSrivastava <[hidden email]>
Sent: Thursday, June 25, 2015 3:18 AM
To: [hidden email]
Subject: Re: [SPSSX-L] Excel Output Export Waring Message

Thanks Mario, But i don't think so. If this is the case (missing backslash),
it wouldn't be pasting anything in file. as of now below syntax is good to
export output file but with a warning message and without any format (all
format is cleared from output file). basically I also need the format
getting exported along with output.

Thanks!
Gaurav

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Excel-Output-Export-Waring-Message-tp5729913p5729934.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

________________________________

This correspondence contains proprietary information some or all of which may be legally privileged; it is for the intended recipient only. If you are not the intended recipient you must not use, disclose, distribute, copy, print, or rely on this correspondence and completely dispose of the correspondence immediately. Please notify the sender if you have received this email in error. NOTE: Messages to or from the State of Connecticut domain may be subject to the Freedom of Information statutes and regulations.

===================== To manage your subscription to SPSSX-L, send a message to LISTSERV@...(not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD