+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).
+18Hi @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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
