Skip to main content
  • EN

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.

Hi,

Column information can be treated from attribute header in your reader.

Pratap
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."

Thanks @pratap and @gio

Reply


Community Stats

30,108
Posts
114,293
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.