ods tagsets.excelxp

[deleted_user]

Hi..

I am using ods tagsets.excelxp in Enterprise guide 4.2 to generate excel report . i have to display page numbers for each page in the excel report.

Please let me know how to do that.

Thanks in advance.

[Cynthia_sas]

Hi:
Page Numbers, etc are controlled via Excel popup windows or dialog boxes. Since your printing interface is between Excel and the printer, TAGSETS.EXCELXP has some suboptions that will allow you to insert the correct field codes for page numbering into the XML generated by TAGSETS.EXCELXP.

To see the complete list of suboptions that you can use, submit the DOC= suboption as shown below (only the invocation statement is shown):
[pre]
ods tagsets.excelxp file="c:\temp\file.xls" options(doc='Help');
[/pre]

I believe the relevant suboptions are Print_Header and Print_Footer. Some previous forum postings on the subject are:
http://support.sas.com/forums/thread.jspa?messageID=51124잴
http://support.sas.com/forums/thread.jspa?messageID=51021읍

cynthia

[deleted_user]

Thanks.. It is working well.