You are not logged in.
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.
I'm confused this time.
What's "read sheet" and "read row"?
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.