Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • General
  • Hello, is there a possibility with FME to read in an excel "xml spreadsheet 2003"? Thank you very much. Greetings Ebi

 The  excel "xml spreadsheet 2003" based on SpreadsheetML (XML schema for Microsoft Office Excel 2003)

Have you tried it?

I tried the XLSXR Reader. It doesn't work (what a suprise 😬 )

Hello @ebiku​ 

If the XML Spreadsheet 2003 file is based on XML (likely given the name), it should be possible to work the file as XML within FME.

You would likely have to correctly configure the XML reader and use attribute transformers to extract the values required. Here is an article on XML reader configuration with examples in case it helps.

@ebiku​  I'm following up on this question. Were you able to have success reading this XML file format?

Reply


Community Stats

30,162
Posts
114,483
Replies
37,809
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.