Skip to main content
Question

Identify the cell information XLS

  • November 25, 2015
  • 3 replies
  • 31 views
danilo_fme
Celebrity
Forum|alt.badge.img+52

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.

Partner Solutial Brazil - www.solutial.com.br
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

pratap
Contributor
Forum|alt.badge.img+12
  • pratapContributor
  • Contributor
  • November 26, 2015
Hi, Column information can be treated from attribute header in your reader. Pratap
gio
Contributor
Forum|alt.badge.img+15
  • gioContributor
  • Contributor
  • November 26, 2015
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
Celebrity
Forum|alt.badge.img+52
  • danilo_fmeCelebrity
  • Author
  • Celebrity
  • November 27, 2015

Thanks @pratap and @gio

Partner Solutial Brazil - www.solutial.com.br

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.