topic Re: import and export XLSM format in SAS Programming

import and export XLSM format

Mushy — Mon, 26 Feb 2024 08:49:55 GMT

Hello,

Is there a way to import and export xlsm(macro enables) workbooks without the pc server?

Thanks,

Mushy

Re: import and export XLSM format

JosvanderVelden — Mon, 26 Feb 2024 11:51:37 GMT

The short answer is NO. For more information see https://communities.sas.com/t5/SAS-Procedures/proc-import-for-xlsm-file/td-p/254918

Re: import and export XLSM format

Sajid01 — Mon, 26 Feb 2024 15:25:40 GMT

Hello @Mushy
If the intention of the import is to get data, then disable the macros and save it as xlsx.
Then it should be possible to get the data into SAS.

Re: import and export XLSM format

SASKiwi — Mon, 26 Feb 2024 19:13:07 GMT

If your SAS installation runs on Windows then the EXCEL engine (which uses MS Office components) should be able to read XLSM workbooks. This won't work for non-Windows SAS as the EXCEL engine isn't available.

Re: import and export XLSM format

Reeza — Mon, 26 Feb 2024 20:11:11 GMT

I haven't tested this in a while, but I would try writing to an XLSM file using the LIBNAME XLSX and see what happens.

Ultimately it depends on what exactly you're trying to accomplish here.

Re: import and export XLSM format

Ksharp — Tue, 27 Feb 2024 03:05:46 GMT

You could import xlsm file by
proc import + dbms=xlsx or excel
But You are unable to export xlsm file I guess.