span8
span4
span8
span4
Good morning,
I'm currently facing a really weird issue.
In my workbench I have a Reader that is loading a quite large Excel file, containing multiple tabs.
I decided to remove all the unwanted data from the Excel sheet and keep only the tab I really need.
When I try to update the Reader feature types the Excel tabs that I just removed keep showing!
I have tried adding this Excel sheet to a new workbench;same result.
What I've tried so far:
- Adding the Reader to a new workbench in 2018.1 and 2019 beta.
- Purged temporary files in FME.
- Restarting FME / computer
- Ran Windows disk cleanup
Nothing helped, I'm still seeing the tabs I deleted.
Cheers,
Ed
Does it work when re-adding the Reader?
Did you migrate the workspace from a earlier FME version?
This is what I have seen regarding excel readers.If you upload a reader with multiple tabs, and delete a tab later, it will still read the excel spreadsheet tab.I don't know why.The same goes for column headers.If you rename a column header or even spell it a little different (case-sensitive), it will still read it as if the column header was the way it was originally.And if you delete a column, it will still read it as if the column is there.
The only way to fix it is to delete the reader and reintroduce it back into your workspace.
When dealing with Excel readers I follow this rule of thumb.Setup your data structure the way you always want to use it.If you change any data structure, you will have to delete the reader and bring it back in to get your updates.And when you bring it in, always check the parameters before bringing it in to verify your data is coming in correctly.And always remember, Column headers are case-sensitive.
I use excel readers a lot so I have done a lot of research regarding this so hopefully what I have learned will help.Good luck!
Always seen this in many versions including transformers including SchemaMapper, and Schema from Table etc.Has caught me out on more than one occasion
@gmbutler2
Thanks for your comment.
This is exactly what I have observed using Excel readers, basically in every FME version.
Normally the workaround of deleting the reader and adding it again fixes the problem of the deleted data still showing.However this time the problem was a bit more persistent.
我最终所需的表复制到一个新的Excel file and have the reader read this new file.
Cheers,
Ed
Try the following:
I've encountered similar issues in 2018.1, where changes to the excel file aren't picked up.Updating feature types or deleting and adding the reader again doesn't help.My workaround thus far is to give the file a new name which fixes the issue (not ideal, but fine for the work I'm doing at the moment)
Excel Reader showing formula values as missing4 Answers
Reading XLSX Files3 Answers
Excel - Format of Attribute1 Answer
Read Dynamic Attributes In Excel2 Answers
How to Read 4 Records at a time from an Excel Document4 Answers
© 2020 Safe Software Inc |Legal