I am working with SAS 9.1.3 for windows and am using SAS to create an Excel workbook with several worksheets using -
libname myxl excel path=" "
My excel file is then to be read in by a java application which is looking for an excel 97 workbook.
Unfortunately the java application cannot read the xls file created by my SAS code. However, if I open the xls file in excel and then save it as an excel 97 file then my java application has no trouble reading it. I also notice that when I do this the size of the file roughly doubles.
Is SAS really creating an excel file when I use the above libname statement or just something that can be read by Excel 97 ?
Is there anything I can do to create a proper excel 97 file from SAS ?
Many thanks in advance for any help.
... View more