Exporting to Excel - tab names

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Exporting to Excel - tab names

spssx100
Hi

Until very recently, I ran SPSS 16 syntax, and exported data to an Excel sheet. Opening the file in Excel, I would have "Sheet1", "Sheet2","Sheet3" as the three tabs with the data in Sheet1.

I now have SPSS 21, and when I run the same syntax, the 'same' file when opened in Excel shows the filename as the tab name.

Hope that makes sense.

I would like to output a sheet with "Sheet1", "Sheet2","Sheet3" as I had when using SPSS 16.

Can anyone help?

Thanks.
Reply | Threaded
Open this post in threaded view
|

Re: Exporting to Excel - tab names

David Marso
Administrator
Maybe you should post your syntax?
I don't do internetelepathy on Mondays!

--
spssx100 wrote
Hi

Until very recently, I ran SPSS 16 syntax, and exported data to an Excel sheet. Opening the file in Excel, I would have "Sheet1", "Sheet2","Sheet3" as the three tabs with the data in Sheet1.

I now have SPSS 21, and when I run the same syntax, the 'same' file when opened in Excel shows the filename as the tab name.

Hope that makes sense.

I would like to output a sheet with "Sheet1", "Sheet2","Sheet3" as I had when using SPSS 16.

Can anyone help?

Thanks.
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
Reply | Threaded
Open this post in threaded view
|

Re: Exporting to Excel - tab names

spssx100
Is this sufficient?

SAVE TRANSLATE OUTFILE='.............'
  /TYPE=XLS
  /VERSION=12
  /MAP
  /REPLACE
  /FIELDNAMES
  /CELLS=VALUES.