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


ebiku

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

4 replies

redgeographics
Celebrity
Forum|alt.badge.img+49

Have you tried it?


ebiku
  • Author
  • February 1, 2023

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


debbiatsafe
Safer
Forum|alt.badge.img+20
  • Safer
  • 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+12

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings