Exporting tables to individual excel tab

LenP

unread,

Jul 25, 2011, 5:20:05 PM7/25/11

to

Hi, I'm using v19 and would like to highlight a bunch of tables then
export them to an excel file to individual tabs with tab labels. Does
any have a piece of syntax or script?

Jon Peck

unread,

Jul 25, 2011, 6:26:09 PM7/25/11

to

There is a Basic script that will do this named ExportTablesToExcelFiles. You can get it from the SPSS Community website (www.ibm.com/developerworks/spssdevcentral) in the Utilities collection.

It gives you the option of exporting all tables, all visible tables, or all selected tables. The output can be in a single sheet, in separate files, or each table can be in a separate sheet in the same file. The script has a dialog box interface for specifying all these options.

It requires that you have Excel installed, and it creates Excel files corresponding to the installed Excel version.

HTH,
Jon Peck

LenP

unread,

Jul 26, 2011, 10:09:13 AM7/26/11

to

Hi Jon,

Can you please point me the specific file?

LenP

unread,

Jul 26, 2011, 10:57:53 AM7/26/11

to

On Jul 25, 6:26 pm, Jon Peck <jkp...@gmail.com> wrote:

Hi Jon,

I did find the script - thanks. If was wanted to customize the tab
name, where is the script is it pulling from?

Jon Peck

unread,

Jul 26, 2011, 1:08:04 PM7/26/11

to

The sheet name is a cleaned up version of the label for the object in the Viewer.

LenP

unread,

Jul 27, 2011, 12:40:08 PM7/27/11

to

On Jul 26, 1:08 pm, Jon Peck <jkp...@gmail.com> wrote:
> The sheet name is a cleaned up version of the label for the object in the Viewer.

Hi Jon, Sorry, I don't know what you mean. Can you paste in the place
and the change I need to make in order to have the script pull from
the table titles and make it the tab label?

Jon Peck

unread,

Jul 28, 2011, 9:11:32 AM7/28/11

to

You can change the script behavior to pick up the title instead of the description, although these are often the same.

At line 92, this text occurs
itemlabel = cleanlabel(objOutputItem.Label)

You could change that to read
itemlabel = cleanlabel(objPivotTable.TitleText)

HTH,
Jon Peck

Jon Peck

unread,

Jul 28, 2011, 4:37:24 PM7/28/11

to

Apparently my first try at responding disappeared into the ether.

The description attribute for a table is usually identical to the table title text, but you can change the function to use the title text instead.

At line 92 of the script, you will see
itemlabel = cleanlabel(objOutputItem.Label)

To use the title text instead, change it to read

subhadi...@gmail.com

unread,

Jul 5, 2019, 5:21:15 AM7/5/19

to

Could you Please send me the script?

Bruce Weaver

unread,

Jul 5, 2019, 8:34:41 AM7/5/19

to

SPSS is several new versions down the road since Jon posted that reply, and there are possibly newer, better ways of doing what you want to do. I suggest that you start a new topic/thread in the SPSSX-L discussion forum, which is far more active than this old usenet group. A convenient way to subscribe to SPSSX-L is via the Nabble archive here:

http://spssx-discussion.1045642.n5.nabble.com/

Click on the <more options> link at the top of the page.

In your new thread, please describe exactly what it is you are trying to do, and if possible provide some sample data. HTH.