Hello,
I have a problem when i want to open Excel File with many sheets after a proc export on server.
Sometimes its works, sometimes not.
After analyse, for Data < 5500 rows, i can't open the excel file, for the data > 5500 rows, it's working.
Do you have a idea ? Thanks a lot.
ps : On server, i can't use XLSX, EXCEL, EXCEL5.
%MACRO Export_ness (data,table, sheet);
PROC EXPORT DATA = &data.
OUTFILE = "/..../&table..xlsx"
DBMS = xlsx REPLACE ;
SHEET = "&sheet." ;
RUN ;
%mend;
%Export_ness (test,FIILE, sheet1);
%Export_ness (test,FILE, sheet2);
Best Regards
Hazou