• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Accessing the contents of an Excel spreadsheet's column.

#1 2012-02-14 14:48:05

tgrady
Member
Registered: 2010-10-27
Posts: 67

Accessing the contents of an Excel spreadsheet's column.

Hi,

My daily challenge... I have a job that reads data from an Excel file via a tFileInputExcel component and am not sure how to access the contents of a
cell from the read sheet. 

The spreadsheet (which consists of one column) is being read with no issues but I am not sure how to get the details from each read row.  The intent
is to use the accessed cell value further in the job stream.  Once I can get at the cell's value I will be good to go.  Is it possible to isolate a cell's contents? 

I looked at the generated java code and do not see where the cell contents get loaded - I see where the spreadsheet name gets loaded to the global map,
but nothing else.   Also, I took a look at the component documentation and was not able to glean what I need from that.

Thank you in advance for your help on this.

Tom

Offline

#2 2012-02-15 09:42:49

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: Accessing the contents of an Excel spreadsheet's column.

Hi Tom

I'm confused this time.  sad

What's "read sheet" and "read row"?

Regards,
Pedro


Only Paranoid Survive.

Offline

#3 2012-02-20 21:49:24

tgrady
Member
Registered: 2010-10-27
Posts: 67

Re: Accessing the contents of an Excel spreadsheet's column.

Hi Pedro,

Sorry for any confursion.  What I mean by 'read sheet' or 'read row' is in reference to the Excel sheet or row being processed (or read) by the
job.  Hope this clears things up.

Thank you.

Tom

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Accessing the contents of an Excel spreadsheet's column.

Board footer

Powered by FluxBB