+8I am trying to read cell A1 from an Excel file but FME Desktop seems to have a problem with that cell for any Excel.
Example 1 (fail):
Example 2 (success with other cell):
What is happening with cell A1? Why can't I read it like the rest of the cells?
Any help would be appreciated! Thank you!
Best answer by evieatsafe
Hi @david_ I can replicate this and I'm not sure the reasoning behind this behavior. You should be able to set the range to A:A1 to get around this. Another way around this is by limiting how many features are being read in with these writer parameters and setting Max Features to Read to 1:
I'll file a bug to have this investigated further, internal ticket FMEENGINE-76786. Hope this helps in the meantime.
@david_ You are reading A1:A1 = Qualifications. That is the very top, left cell in a spreadsheet. Perhaps you're meaning to read A2:A2 ?
Including a small example dataset and your workspace might let the community look more closely
+8Hi @Mark Stoakes ,
First of all, thank you for your answer!
However, I don't want to read A2:A2, I want to read only the cell A1 with the text "Quantifications". The field name should be "A" (the column name).
Hi @david_ I can replicate this and I'm not sure the reasoning behind this behavior. You should be able to set the range to A:A1 to get around this. Another way around this is by limiting how many features are being read in with these writer parameters and setting Max Features to Read to 1:
I'll file a bug to have this investigated further, internal ticket FMEENGINE-76786. Hope this helps in the meantime.
+8It works with your "workaround" @Evie Lapalme .
From my point of view, cell A1 should work like the rest. Maybe this can be fixed for the next FME Desktop version.
thank you very much!
Best regards
