The SAS Output Delivery System and reporting techniques

ods tagsets.excelxp

Reply
N/A
Posts: 0

ods tagsets.excelxp

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.
SAS Super FREQ
Posts: 8,743

Re: ods tagsets.excelxp

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
N/A
Posts: 0

Re: ods tagsets.excelxp

Thanks.. It is working well.
Ask a Question
Discussion stats
  • 2 replies
  • 255 views
  • 0 likes
  • 2 in conversation