Problem in Exporting SPSS Custom Tables output to XLSX
Locked
Problem in Exporting SPSS Custom Tables output to XLSX
 
|
Hi All, I am using SPSS 22 and I have generated around 100 tables with 600 Columns in top breaks using Custom Tables. When I am exporting it to XLSX it is creating problem.
Do we have any OMS command or Script or Python program to export easily in XLSX. Please help. 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 |
Re: Problem in Exporting SPSS Custom Tables output to XLSX
Administrator
|
"When I am exporting it to XLSX it is creating problem."
Some details? Seriously. You have been around here for awhile but don't have a clue about how to elicit assistance? Maybe just try a vanilla OMS and see what happens. WTF....... Arora, Manoj (IMDLR) wrote > Hi All, > > I am using SPSS 22 and I have generated around 100 tables with 600 Columns > in top breaks using Custom Tables. When I am exporting it to XLSX it is > creating problem. > > Do we have any OMS command or Script or Python program to export easily in > XLSX. > > Please help. > > Regards > Manoj > > > > Kantar Disclaimer<http://www.kantar.com/disclaimer.html> > > ===================== > To manage your subscription to SPSSX-L, send a message to > LISTSERV@.UGA > (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 ----- 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?" -- 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
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?" |
|
|
In reply to this post by Arora, Manoj (IMDLR)
You can do this with OMS, but the details depend on whether you want one xlsx file or one per table, assuming that you bracket all the CTABLES commands with one OMS/OMSEND. Something like this would put all the results in one Excel sheet. OMS /SELECT TABLES /IF COMMANDS=['CTables'] SUBTYPES=['Custom Table'] /DESTINATION FORMAT=XLSX OUTFILE='c:\exports\unified.xlsx' VIEWER=YES. CTABLES ... CTABLES... OMSEND. This would produce one file per table. OMS /SELECT TABLES /IF COMMANDS=['CTables'] SUBTYPES=['Custom Table'] /DESTINATION FORMAT=XLSX OUTPUTSET=SUBTYPES FOLDER='c:\exports' VIEWER=YES. CTABLES ... CTABLES... OMSEND. This, of course, does not permit you to post process the tables in the Viewer before the export. On Sun, Sep 30, 2018 at 6:15 AM Arora, Manoj (IMDLR) <[hidden email]> wrote:
|
Re: Problem in Exporting SPSS Custom Tables output to XLSX
|
|
I find OUTPUT MODIFY together with OUTPUT EXPORT much more comfortable than OMS. Mario Giesel Munich, Germany
Am Sonntag, 30. September 2018, 21:23:35 MESZ hat Jon Peck <[hidden email]> Folgendes geschrieben:
You can do this with OMS, but the details depend on whether you want one xlsx file or one per table, assuming that you bracket all the CTABLES commands with one OMS/OMSEND. Something like this would put all the results in one Excel sheet. OMS /SELECT TABLES /IF COMMANDS=['CTables'] SUBTYPES=['Custom Table'] /DESTINATION FORMAT=XLSX OUTFILE='c:\exports\unified.xlsx' VIEWER=YES. CTABLES ... CTABLES... OMSEND. This would produce one file per table. OMS /SELECT TABLES /IF COMMANDS=['CTables'] SUBTYPES=['Custom Table'] /DESTINATION FORMAT=XLSX OUTPUTSET=SUBTYPES FOLDER='c:\exports' VIEWER=YES. CTABLES ... CTABLES... OMSEND. This, of course, does not permit you to post process the tables in the Viewer before the export. On Sun, Sep 30, 2018 at 6:15 AM Arora, Manoj (IMDLR) <[hidden email]> wrote:
|
Re: Problem in Exporting SPSS Custom Tables output to XLSX
|
|
Hi Mario, Thanks for revert but I have never used both the commands together. How will these commands work together, Please suggest. Regards Manoj From: SPSSX(r) Discussion <[hidden email]>
On Behalf Of Mario Giesel I find OUTPUT MODIFY together with OUTPUT EXPORT much more comfortable than OMS. Mario Giesel Munich, Germany Am Sonntag, 30. September 2018, 21:23:35 MESZ hat Jon Peck <[hidden email]> Folgendes geschrieben:
You can do this with OMS, but the details depend on whether you want one xlsx file or one per table, assuming that you bracket all the CTABLES commands with
one OMS/OMSEND. Something like this would put all the results in one Excel sheet. OMS /SELECT TABLES /IF COMMANDS=['CTables'] SUBTYPES=['Custom Table'] /DESTINATION FORMAT=XLSX OUTFILE='c:\exports\unified.xlsx' VIEWER=YES. CTABLES ... CTABLES... OMSEND. This would produce one file per table. OMS /SELECT TABLES /IF COMMANDS=['CTables'] SUBTYPES=['Custom Table'] /DESTINATION FORMAT=XLSX OUTPUTSET=SUBTYPES FOLDER='c:\exports' VIEWER=YES. CTABLES ... CTABLES... OMSEND. This, of course, does not permit you to post process the tables in the Viewer before the export. On Sun, Sep 30, 2018 at 6:15 AM Arora, Manoj (IMDLR) <[hidden email]> wrote:
--
Jon K Peck ===================== 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 |
Re: Problem in Exporting SPSS Custom Tables output to XLSX
|
|
Hi, Arora,
with OUTPUT MODIFY you remove superfluous viewer stuff and maybe do some formatting of your tables like numbering tables, highlighting specific columns, sorting by specific columns etc. With OUTPUT EXPORT you can write viewer results to Excel and even specify the sheet name or the position within a sheet where to insert the tables. An example might be (after having created custom tables in the viewer) OUTPUT MODIFY /SELECT ALL EXCEPT (TABLES) /DELETEOBJECT DELETE = YES /SELECT TABLES /TABLE TLOOK = "ACADEMIC" /SELECT TABLES /INDEXING INDEXTYPE = NUMBER INDEXSTART =1 /TABLE TABLETITLE = 'Tab. )INDEX - )LABEL' /SELECT TABLES /TABLECELLS SELECT=["Total"] SELECTDIMENSION=ROWS APPLYTO=ROW BACKGROUND-COLOR=RGB(240,200,240). OUTPUT EXPORT /CONTENTS EXPORT = VISIBLE /XLSX DOCUMENTFILE = '...\results.xlsx' OPERATION = CREATESHEET SHEET = 'Age 14-69' LOCATION = STARTCELL('B1'). Use the syntax reference guide in the help menu for details. Good luck, Mario Munich, Germany
Am Mittwoch, 3. Oktober 2018, 11:36:47 MESZ hat Arora, Manoj (IMDLR) <[hidden email]> Folgendes geschrieben:
Hi Mario,
Thanks for revert but I have never used both the commands together. How will these commands work together, Please suggest.
Regards Manoj
From: SPSSX(r) Discussion <[hidden email]>
On Behalf Of Mario Giesel
I find OUTPUT MODIFY together with OUTPUT EXPORT much more comfortable than OMS.
Mario Giesel Munich, Germany
Am Sonntag, 30. September 2018, 21:23:35 MESZ hat Jon Peck <[hidden email]> Folgendes geschrieben:
You can do this with OMS, but the details depend on whether you want one xlsx file or one per table, assuming that you bracket all the CTABLES commands with one OMS/OMSEND.
Something like this would put all the results in one Excel sheet. OMS /SELECT TABLES /IF COMMANDS=['CTables'] SUBTYPES=['Custom Table'] /DESTINATION FORMAT=XLSX OUTFILE='c:\exports\unified.xlsx' VIEWER=YES. CTABLES ... CTABLES... OMSEND.
This would produce one file per table. OMS /SELECT TABLES /IF COMMANDS=['CTables'] SUBTYPES=['Custom Table'] /DESTINATION FORMAT=XLSX OUTPUTSET=SUBTYPES FOLDER='c:\exports' VIEWER=YES. CTABLES ... CTABLES... OMSEND.
This, of course, does not permit you to post process the tables in the Viewer before the export.
On Sun, Sep 30, 2018 at 6:15 AM Arora, Manoj (IMDLR) <[hidden email]> wrote:
-- Jon K Peck ===================== 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
|
Re: Problem in Exporting SPSS Custom Tables output to XLSX
|
|
In reply to this post by Arora, Manoj (IMDLR)
Please use the following syntax at the beginning of the custom tables
OMS /SELECT tables /if commands=['tables' 'ctables'] SUBTYPES =['table' 'custom table'] /DESTINATION format=TABTEXT OUTFILE ='C:\Users\POmond01\Documents\PETER O BACKUP\2018\PROJECTS\AUGUST HOMEWORK\NJOROGE UNIVERSITY OF NAIROBI\Stakeholders Study_v1.xls'. at the end of the tables you can type omsend. -- 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 |
| Free forum by Nabble | Edit this page |