topic Re: ods tagsets.ExcelXP export file open issue in SAS Programming

ods tagsets.ExcelXP export file open issue

Jyuen204 — Thu, 18 May 2023 15:16:56 GMT

I have an excel report I built that drop the file into my ftp drive. when I open the file I get a "File Format and Extension .... don't match.."

I can still bypass and open the file. Just wondering if there is a way to have the program be exported "properly" so that the error doesnt pop up.

ods tagsets.ExcelXP path= "&OUTPUT_PATH" file= 'Weekly Report.xls' Style=Printer;

I tried xlsx as the extension but it wont open the file at all.

Re: ods tagsets.ExcelXP export file open issue

ballardw — Thu, 18 May 2023 15:30:24 GMT

@Jyuen204 wrote:

I have an excel report I built that drop the file into my ftp drive. when I open the file I get a "File Format and Extension .... don't match.."

Of course you do. The EXCELXP creates XML content. Not XLS. Not XLSX. Not HTML. You may get away with XLSX, but the file should have an XML extension.

You may have to add XML to whatever program you are using to view XLS files as a default application.

Re: ods tagsets.ExcelXP export file open issue

Jyuen204 — Thu, 18 May 2023 15:33:39 GMT

Is there a different method of export where I can export the report to the excel format? I inherited this code from someone who is long gone.

Re: ods tagsets.ExcelXP export file open issue

Tom — Thu, 18 May 2023 15:40:38 GMT

SAS now had the EXCEL destination you can use that writes an XLSX file.

There are some minor differences in what options the two support, so you might need to also make some other changes.

Re: ods tagsets.ExcelXP export file open issue

SASKiwi — Thu, 18 May 2023 21:01:39 GMT

Try writing the file with an XML file extension. That's what we do with our ExcelXP spreadsheets and Excel opens it successfully by double-clicking on it.