xlsReadM

Just found that xlsReadM could not load data files saved using Excel 2016!

3 Answers



0



If you are using GAUSS for Windows and you are using the COM interface that directly connects to Excel (the default behavior), then you should be able to read any Excel file that the version of Excel on your computer can read.

If you turned that off, or are on Mac or Linux, then GAUSS will be reading and writing the Excel files directly and you could run into issues with files made by versions of Excel that are much newer than the version of GAUSS. GAUSS 16 can read Excel 2016 files on all platforms (Windows, Mac and Linux).

aptech

1,773


0



Thanks for clarifying this. I assume that it has to deal with the following in xls.src:

#ifOS2WIN
   #define USECOMEXCEL 1
#endif

I commented out previously (and I have GAUSS 15). But once I uncomment, it works.



0



Yes, this is the relevant code.

#ifOS2WIN
   #define USECOMEXCEL 1
#endif

If it is commented out, then GAUSS will read the XLS/XLSX file directly. This is usually quite a bit faster and will work on a computer that does not have Excel installed. However, it will be limited by the XLS reading abilities installed in that version of GAUSS. Whereas, if the code above is uncommented, then older versions of GAUSS will be able to read newer version Excel files if you have a newer version of Excel installed on your computer.

aptech

1,773

Your Answer

3 Answers

0

If you are using GAUSS for Windows and you are using the COM interface that directly connects to Excel (the default behavior), then you should be able to read any Excel file that the version of Excel on your computer can read.

If you turned that off, or are on Mac or Linux, then GAUSS will be reading and writing the Excel files directly and you could run into issues with files made by versions of Excel that are much newer than the version of GAUSS. GAUSS 16 can read Excel 2016 files on all platforms (Windows, Mac and Linux).

0

Thanks for clarifying this. I assume that it has to deal with the following in xls.src:

#ifOS2WIN
   #define USECOMEXCEL 1
#endif

I commented out previously (and I have GAUSS 15). But once I uncomment, it works.

0

Yes, this is the relevant code.

#ifOS2WIN
   #define USECOMEXCEL 1
#endif

If it is commented out, then GAUSS will read the XLS/XLSX file directly. This is usually quite a bit faster and will work on a computer that does not have Excel installed. However, it will be limited by the XLS reading abilities installed in that version of GAUSS. Whereas, if the code above is uncommented, then older versions of GAUSS will be able to read newer version Excel files if you have a newer version of Excel installed on your computer.


You must login to post answers.

Have a Specific Question?

Get a real answer from a real person

Need Support?

Get help from our friendly experts.