Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

tgrady
2012-02-20 21:49:24

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

pedro
2012-02-15 09:42:49

Hi Tom

I'm confused this time.  sad

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

Regards,
Pedro

tgrady
2012-02-14 14:48:05

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

Board footer

Powered by FluxBB