Errors when opening ODS created workbook

Doug____ — Fri, 21 Feb 2020 16:43:26 GMT

I'm receiving the following errors when creating a multi-sheet excel workbook:

Repaired Part: /xl/worksheets/sheet1.xml part with XML error. Load error. Line 37, column 28.
Removed Records: Merge cells from /xl/worksheets/sheet1.xml part
Removed Records: Merge cells from /xl/worksheets/sheet2.xml part
Removed Records: Merge cells from /xl/worksheets/sheet3.xml part
Removed Records: Merge cells from /xl/worksheets/sheet4.xml part
Removed Records: Merge cells from /xl/worksheets/sheet5.xml part
Removed Records: Merge cells from /xl/worksheets/sheet6.xml part
Removed Records: Merge cells from /xl/worksheets/sheet7.xml part
Removed Records: Merge cells from /xl/worksheets/sheet8.xml part
Removed Records: Merge cells from /xl/worksheets/sheet9.xml part

My report build code appears as follows:

All macro variables resolve as expected and there are no errors or warnings in the log.

ODS excel File="x:\Detail Exceptions &&CA&H &rpt_as_of..xlsx" ;

ods excel options (absolute_column_width = "30,8,20,20,20" embedded_titles = "Yes" embedded_footnotes = "Yes" sheet_name = "&sheet");

NOTE: Writing EXCEL file: x:\Detail Exceptions Joe Smith 01-31-2020.xlsx

Re: Errors when opening ODS created workbook

Reeza — Fri, 21 Feb 2020 16:51:30 GMT

What version of SAS do you have? You can run the following to determine the version:

proc product_status;run;

Ideally, if you could show your code as well, or a reproducible example using a SASHELP data set it would help us help you debug the issue. Start with the version first, ODS EXCEL was buggy in 9.4M3/4 though it was production. It's been fairly stable in 5 but doesn't handle large files well still...unfortunately 😞

topic Errors when opening ODS created workbook in ODS and Base Reporting

Errors when opening ODS created workbook

Re: Errors when opening ODS created workbook