Originally posted by: muralee

I need to read an excel sheet. We have 10 columns with unbounded rows.
I have tried read excel file using DBEQUERY but the problem is ,I need to specify column and row positions and I don’t know how many rows exists in the sheet.

Can any one please let me know, how I can give row position dynamically.

Your help will be greatly appreciated!!

Thanks
Murali.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: TarunB

This was discussed a little while back -

http://www.ibm.com/developerworks/forums/thread.jspa?threadID=278851&tstart=15
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Mr. TarunB, I would like to ask if you can help me with my problem, I'am having a hard time figuring what will be the right terminator for excel input file. I'am also extracting data from excel file using Database Interface Designer. I'am successful with extraction but I only get the first line, it didn't show the next line of the excel.

I hope you could me help with my problem
Thanks
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange