Displaying tables in EXCEL using TOM

[nathan]

Hi

Im having a problem with exporting my tables from a SPSS file through a TOM script,it displays on different tabs, eg (T1,T2.. etc),is it possible to display all these tables on one sheet? Also on the side of the left hand side of the table a bookmark title is attached , that i would like to remove.

[klaus]

Hi Nathan,
I don't think you can influence the way TOM is exporting tables into worksheets. Not even the naming of the worksheets can be influenced so far. Re your second question: I do not really understand what you mean by

bookmark title

. The titles displayed in the output are based on the so called "annotations" you have defined for your set of tables. If you do nothing about them the default setting is used. At the end of the day you have full control over these titles through the collection "TableDoc.Default.Annotations". To get rid of all of them you can simply call the method "clear()" on this collection, which will remove all titles and footers. Please refer to the according part in the DDL.

Klaus

[kylefsimpson]

Have you tried the csv export rather than excel?

using: mrTextExport