Question

Identify the cell information XLS

  • 25 November 2015
  • 3 replies
  • 3 views
danilo_fme
Rank
Userlevel 4
Badge +30

Hello, i would like to get the cells information on table XLS.

For example, i know that has a format attribute in xls reader ( xlsx_row_id ) but i need too the information columm. The image below is G 14, but how can i get it with FME wie a value attribute? Thanks.

3 replies

pratap
Rank
Badge +2
Hi, Column information can be treated from attribute header in your reader. Pratap
G
Badge +3
If you want to use G14 to locate the value, you can set "Field Names Row" to 0 If you don't want to keep the header row, set "Cell range" to start from row 2, as row 1 has the headers. Now u have attributes A,B,C etc. With row_id's. You can do this in the reader Parameters. Another way would be to use a "attribute exploder."
danilo_fme
Rank
Userlevel 4
Badge +30

Thanks @pratap and @gio

Reply


Community Stats

28,670
Posts
109,364
Replies
36,531
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.