Skip to main content
  • EN
Hi.

 

 

I'm trying to get my FME workbench to read an excel spreadsheet that is automatically generated and has an asterisk in the column header of two columns. It reads this and displays it in the drop down list of attributes, but when I connect an inspector straight to the reader (I'm trying to get it to ignore a title line)  It wont read any of the columns with asterisks. They're not empty theyre just not there.

 

 

Does anyone know why this is or if there's a workaround?

 

 

I've tried creating a copy of the file, deleting the asterisks, pointing to that, then adding them back in but of course the workbench then cant find the columns. Since its an automattically produces xls file, I can't edit it manually everytime so what I need is for the FME workbench to ignore the title line and read all of the attributes as they are.

 

 

Thanks
Edit: I've just seen that the missing rows appear under attrubutes in the feature information apanel when I click on a row in the table in inspector. Its just the columns that are excluded from the table... wierd

 

 

Hi,

 

 

I tested with FME 2014 SP1 and it seems to work fine. Since asterisks often have a special meaning (wildcards), FME did replace them with an underscore on the input feature type, but otherwise both the attributes and the values were read and displayed without a problem.

 

 

If you have an older version of FME, be aware that the Excel reader got a major overhaul around FME 2013 SP2 (if I'm not mistaken). There were also some bugs that got ironed out later, so I'd strongly recommend to at least use FME 2013 SP4.

 

 

David
ahh. I'm in 2013 SP1, perhaps an upgrade is in order. For the benefit of anyone else using this, AttributeRenamer seems to do the trick - just remove the asterisks.

 

 

Cheers

Reply


Community Stats

30,108
Posts
114,291
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.