You cannot do this with OMS directly. If you save the OMS output as XML, you could create an XSLT script that would transform it into an appropriate structure -- assuming that there is an HTML or XML form for multi-tab Excel files.
XSLT is a very powerful XML transformation language, and you almost surely have an XSLT processor already installed: MSXSLT. Many others are freely downloadable.
However, there is a SaxBasic script called ExportTablesToExcelFiles that you can download from SPSS Developer Central (www.spss.com/devcentral) that can take all, all visible, or selected pivot tables from the Viewer and export them as either separate xls files or one xls file with each table in a separate tab. The Viewer outline titles are used as the tab names.
HTH,
Jon Peck
-----Original Message-----
From: SPSSX(r) Discussion on behalf of Little, Jonathon
Sent: Tue 8/7/2007 10:45 PM
To:
[hidden email]
Subject: [SPSSX-L] OMS Command question
Hello all,
does anyone know of a way to use the OMS command to create an HTML file
with tabs such that you can open this in excel with different tables in
separate worksheets?
A long shot but I thought I would throw this out to the gods.
Any assistance appreciated.
Jonathon Little
Locked
