Export tables in several Excel sheets

[emma78]

Hi,
can you help me regarding the following problem:

I would like to export an output with several SPSS Tables to Excel. Each
table should be on a separate excel sheet, is this possible?

Thanks in advance!



--
Sent from: http://spssx-discussion.1045642.n5.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

[Rick Oliver]

Look at the OMS command, specifically the OUTPUTSET keyword on the DESTINATION subcommand. You can use the SELECT and IF subcommands to control which output tables get exported.

https://www.ibm.com/support/knowledgecenter/SSLVMB_24.0.0/spss/base/syn_oms.html

On Fri, Jul 13, 2018 at 10:40 AM emma78 <[hidden email]> wrote:

Hi,
can you help me regarding the following problem:

I would like to export an output with several SPSS Tables to Excel. Each
table should be on a separate excel sheet, is this possible?

Thanks in advance!



--
Sent from: http://spssx-discussion.1045642.n5.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

[Jon Peck]

Using OMS will put each selected table into a separate Excel file.

You can alternatively use OUTPUT EXPORT, where you can specify the sheetname.  If there is only one table in the Viewer at export time, or if you choose the "Selected" option, this will do what you want, but you can't specify exactly which tables get exported using syntax.  It can only be ALL or VISIBLE in syntax.

There is, however, a way to do this using the SPSSINC MODIFY OUTPUT extension command.  This command includes a custom Python module that has a function named excelexport that will do this.  It can, for example, export all tables of type customtable in the Viewer as separate sheets of a single Excel file.

Here is an example,

*Export all the custom tables in the Viewer to separate sheets named table1, table2, ...

SPSSINC MODIFY OUTPUT TABLES 

/IF SUBTYPE="'Custom Table'" PROCESS=ALL

/CUSTOM FUNCTION="customoutputfunctions.excelexport(file='c:/temp/extest.xls',

  sheet='table#',action='CreateWorksheet')".

Here are the full details for the possible excelexport parameters.

parameters:

    file - filespec for output (required)

    sheet - sheetname.  Default is "Sheet"

    action - "CreateWorkbook" | "Create Worksheet" | "ModifyWorksheet"

    location - "OverwriteAtCellRef" | "AddColumns" | "AddRows"

    startingCell - starting cell if location is overwrite.  Default is "A1"

    image - image format - "jpg" | "png" | "tiff" | "eps" | "emf" | "bmp"

    

    See OUTPUT EXPORT help for information on these options.

    

    Use # in the file or sheet string to insert a sequential number on each

    save operation to avoid overwriting.

    

    The first value listed is the default if there is one.

    

    If an item would overwrite another item in the same command, an error is raised

If MODIFY OUTPUT is not already installed, you can install it from Extensions > Extension Hub or in older versions use the Utilities menu.

On Fri, Jul 13, 2018 at 10:38 AM Rick Oliver <[hidden email]> wrote:

Look at the OMS command, specifically the OUTPUTSET keyword on the DESTINATION subcommand. You can use the SELECT and IF subcommands to control which output tables get exported.

https://www.ibm.com/support/knowledgecenter/SSLVMB_24.0.0/spss/base/syn_oms.html

On Fri, Jul 13, 2018 at 10:40 AM emma78 <[hidden email]> wrote:

Hi,
can you help me regarding the following problem:

I would like to export an output with several SPSS Tables to Excel. Each
table should be on a separate excel sheet, is this possible?

Thanks in advance!



--
Sent from: http://spssx-discussion.1045642.n5.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

--
===================== 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