The SAS Output Delivery System and reporting techniques

ExcelXP Tagsets & File Save As in a Frame entry

Reply
N/A
Posts: 1

ExcelXP Tagsets & File Save As in a Frame entry

After an XML file is saved using the ExcelXP tagset, can you automate saving the output file as .XLS? Has anyone done this - maybe like calling a "File Save As" screen?
Super Contributor
Posts: 358

Re: ExcelXP Tagsets & File Save As in a Frame entry

I use the ExcelXP tagset to create a large number of spreadsheets and they are all created with a .XLS extension.

There is no reason that you can't name the file anything you want - I name my files using macro variables:

ods tagsets.ExcelXP path="&path" body="&body" style=minimal;

where the "&body" resolves to "sheetname.xls"
Ask a Question
Discussion stats
  • 1 reply
  • 112 views
  • 0 likes
  • 2 in conversation