Hi,
I have a workspace that writes a XLSX from a template. The source features come from Smallworld (there's also a very simple Excel spreadsheet that is joined in the process). I can run it in FME Desktop 2018 (32) + Smallworld 4.3 with no problem. But when I run it in FME Desktop 2021 (64) + Smallworld 5.2, the resulting XLSX seems to be corrupted.
While starting Excel, I get a message: "We found a problem with some content in... <file name>. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes".
After clicking Yes, Excel does its recovery thing, and tells me "Removed Feature: Named range from /xl/workbook.xml part (Workbook)".
To rule out an Excel problem, I opened both output files (FME 2018 and FME 2021) in the same computer, and got the errors only in the FME 2021/Smallworld 5 file.
I also see these warnings in the FME log when I run it in FME 2021 / Smallworld 5:
- Excel Reader: Found named range '_xlnm._FilterDatabase' on sheet 'Issues Identified'. This is a Microsoft Excel internal name so FME will not show it as a sheet. If you wish to read this named range, please rename it
- Excel Reader: Unable to convert .xlsb file for reading: FME could not have Microsoft Excel open the file via COM. This operation is not supported in FME Server
- Excel Reader: Unable to convert .xlsb file for reading: FME could not have Microsoft Excel open the file via COM. This operation is not supported in FME Server
Can someone help me troubleshoot this?
Thank you,
Vini
