The SAS Output Delivery System and reporting techniques

Excel xp tagset generating report with large size file

Reply
N/A
Posts: 0

Excel xp tagset generating report with large size file

Hi

I am using Excel xp tagset to create a excel report . Since the Excel xp tagset will create xml file the report size is large . So inorder to reduce the size i will open it in excel and save it so that the size will get reduced . As long as the Report size is with in range 1 -2 mb i am able to open using excel and save so the report size will reduce to some KB . But When the size of file is larger than 2 mb opening the excel itself will take time .So i am not able to reduce the size of excel.

Please let us know is another option by which we can reduce the size of excel.
SAS Super FREQ
Posts: 8,742

Re: Excel xp tagset generating report with large size file

Hi:
I have had students report that they sometimes write a small script in VB/VBA or some other scripting language to go out and do an open/save as. Basically, they keep all their unconverted XML files in one directory and run the program on a scheduled basis (usually at night) and save the converted .xls or .xlsx files in a different directory, so they know what files have been converted.

cynthia
Super User
Posts: 9,671

Re: Excel xp tagset generating report with large size file

Hi.
Did you use proc export?


Ksharp
Ask a Question
Discussion stats
  • 2 replies
  • 159 views
  • 0 likes
  • 3 in conversation