Exporting Custom Tables output to Different Sheets in a Single Workbook

[Arora, Manoj (IMDLR)]

Hi All,

 

I am using SPSS 22.

 

I have around 100 tables with Significance testing table and number of breaks in columns are 500. I want to export those tables in a single workbook but in different sheets so there will be around 100 sheets in that workbook.

 

What command I should use to export the same?

 

I have tried

 

SPSSINC MODIFY OUTPUT TABLES

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

/CUSTOM FUNCTION="customoutputfunctions.excelexport(file='C:\temp\newtables.xlsx', sheet='table#',action='CreateWorksheet')".

 

But it is not working.

 

I am not sure about OUPUT EXPORT how will it work.

 

I am not sure about OMS command and how will it help me

 

 

Need your support on this.

 

 

Regards

Manoj

 

 

 

 

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

[Ki Park]

Arora,
The answer is in your previous post called "Problem in Exporting SPSS Custom
Tables output to XLSX". Jon and Mario other gave some steps to do this.
Ki



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