Re: Exporting Layered Custom Tables to Excel (different worksheets)
Posted by
Jon K Peck on
Aug 24, 2011; 7:20pm
URL: http://spssx-discussion.165.s1.nabble.com/Exporting-Layered-Custom-Tables-to-Excel-different-worksheets-tp4731268p4731612.html
No built-in mechanism exists for this -
at least none comes to mind, but it would be a straightforward scripting
task to do this work. The table(s) would need to be specified somehow
(by select status, by type, ...). OUTPUT EXPORT provides for exporting
just the top layer, so the script would bring each layer to the top, in
turn, and then export it. I don't have time right now to create this.
Perhaps someone else does.
Alternatively, write an Excel VBA script
to take the individual tables on one sheet and move them to separate ones.
The ExportTablesToExcelFiles script, which is written in VBA, uses
Excel automation to merge entire tables in separate Excel files into separate
tabs in a single file and might be helpful as a starting point.
Regards,
Jon Peck (no "h")
Senior Software Engineer, IBM
[hidden email]
new phone: 720-342-5621
From:
Tricia Selby <[hidden email]>
To:
[hidden email]
Date:
08/24/2011 11:59 AM
Subject:
[SPSSX-L] Exporting
Layered Custom Tables to Excel (different
worksheets)
Sent by:
"SPSSX(r)
Discussion" <[hidden email]>
I am wondering if there is a script or syntax that
can help me export a
layered Custom Table into separate Excel worksheets. The only thing
I
have found was the ExportTablesToExcelFiles script, but that exports all
my layers into ONE worksheet (each table under the other). However,
I
would like each layer to be on a separate worksheet!
Any assistance would be GREATLY appreciated!!!
Thank you!
=====================
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