Skip to main content
Question

Hello, is there a possibility with FME to read in an excel "xml spreadsheet 2003"? Thank you very much. Greetings Ebi

  • January 31, 2023
  • 4 replies
  • 35 views

ebiku

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

4 replies

redgeographics
Celebrity
Forum|alt.badge.img+59
  • Celebrity
  • 3700 replies
  • January 31, 2023

Have you tried it?


ebiku
  • Author
  • 3 replies
  • February 1, 2023

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


debbiatsafe
Safer
Forum|alt.badge.img+21
  • Safer
  • 648 replies
  • February 2, 2023

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.


steveatsafe
Safer
Forum|alt.badge.img+13
  • Safer
  • 422 replies
  • May 26, 2023

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