I don't know why you are getting the extra
line(s), but you could explicitly set the location for each table in the
export via OUTPUT EXPORT. That would require that you export the
tables individually. You could do that, perhaps, by exporting each
table immediately after creation and then deleting it, but you could also
use the SPSSINC MODIFY OUTPUT extension command with its excelexport
custom function to select these items by recency or oms subtype.
OMS does not provide any footnote control.
You can, of course, delete footnotes
in the pivot table editor, but there seems to be no way to do that automatically.
Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: 720-342-5621
From:
mgriffiths <[hidden email]>
To:
[hidden email]
Date:
08/20/2014 08:15 AM
Subject:
[SPSSX-L] removing
footnotes from tables for export to Excel
Sent by:
"SPSSX(r)
Discussion" <[hidden email]>
I'm using SPSS 21 and attempting to export a series
of tables to separate
Excel worksheets using the OUTPUT EXPORT command. Each Excel sheet contains
three tables, one below the other, and I need each table to start on the
same row in each sheet.
I almost have it working; the only thing that is messing me up is when
there
is a footnote to one of the tables. I have used NOTESCAPTIONS=NO, so the
text of the footnote doesn't appear in Excel, but it still inserts a blank
row where the footnote would have been. This throws out the alignment.
Any ideas? Is there a way of making the footnotes invisible in OMS?
Here's the syntax I am using:
OMS /SELECT ALL EXCEPT [TABLES] /DESTINATION VIEWER = NO.
OUTPUT NEW.
my command that produces the tables
OUTPUT EXPORT /CONTENTS EXPORT=VISIBLE
/xls DOCUMENTFILE='my document.xls'
OPERATION=CREATESHEET SHEET='my sheet' NOTESCAPTIONS=NO.
OUTPUT CLOSE *.
--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/removing-footnotes-from-tables-for-export-to-Excel-tp5727030.html
Sent from the SPSSX Discussion mailing list archive at 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
Locked
