Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • I'm getting an error in an Excel spreadsheet - Removed Feature: Named range - written by XSLXW from a template. Where exactly does it come from?

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

This looks like a bug. There are lots of them regarding using Excel templates. I also have this case open: Case: C678561 (safe.com)

You should Submit a Case | FME Community (safe.com) to Safe.

Are there any updates on this issue? I run into the same error with FME 2024.1 (build 24612).

It could be something in FME because 2018 version is running on 32 bit, while the rest of the version are on 64 bit. Also I notice that the Smallworld version also different between the two system.

I’m thinking Smallworld 5.2 when export to excel, something has change. I wonder if that is where you can start troubleshooting. I never use Smallworld, so I can’t tell you much about it.

But If you can provide some testing sample of the excel export from Smallworld 5.2 and Smallworld 4.3 so we can compare the different. That would be helpful.



 

Reply


Community Stats

30,102
Posts
114,271
Replies
37,736
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.