F
fritz
I have seen this question asked before on many newsgroups and websites
but no one was able to answer this.
The group I am working in is nearly finished a new reporting process
that outputs all our groups reporting into excel files on a LAN
drive. We are using SAS for report generation and would like to take
advantage of the extra features in the ExcelXP tagset. For non SAS
folks, it allows us to create spreadsheets in Excel XML format.
The problem is the size of the output files compared to a binary xls
file. They are just way too big. Some reach about 100 Mbytes in
size. The only solution I have seen on the web is to the "Save As.."
an XLS file inside Excel. This is an automated reporting process that
will generate any where between 50 and 600 spreadsheets per day. The
"Save as" feature is not going to cut it. We don't have the budget
for that many temps to open and close files. Leaving it as XML will
probably give our LAN admin a heart attack.
Does any one know of a command line utility that can convert XML
spreadsheets to a binary XLS file?
If not has any one using SAS been able to get around this size issue
with the ODS method? Proc export will do it but we loose a lot of
features with the output of the spreadsheet.
but no one was able to answer this.
The group I am working in is nearly finished a new reporting process
that outputs all our groups reporting into excel files on a LAN
drive. We are using SAS for report generation and would like to take
advantage of the extra features in the ExcelXP tagset. For non SAS
folks, it allows us to create spreadsheets in Excel XML format.
The problem is the size of the output files compared to a binary xls
file. They are just way too big. Some reach about 100 Mbytes in
size. The only solution I have seen on the web is to the "Save As.."
an XLS file inside Excel. This is an automated reporting process that
will generate any where between 50 and 600 spreadsheets per day. The
"Save as" feature is not going to cut it. We don't have the budget
for that many temps to open and close files. Leaving it as XML will
probably give our LAN admin a heart attack.
Does any one know of a command line utility that can convert XML
spreadsheets to a binary XLS file?
If not has any one using SAS been able to get around this size issue
with the ODS method? Proc export will do it but we loose a lot of
features with the output of the spreadsheet.