Is it possible to import values from multiple sheets of same excel file?

[jenic]

Hi,

We can import the values from the excel sheet as shown below.

Input from value(v-excelfile).

Repeat:
Create w-file.
Import delimiter "," w-file.


end.

Is it possible to import the values from multiple worksheet of the same excel file?


Thanks & Regards,
Jeni.

 

[jdpjamesp]

It looks like you're importing from a csv there, not an excel file. csv files do not have multiple sheets.

 

[D.Cook]

If you do need to read from an Excel document (xls or xlsx) you can use ActiveX to control Excel and read the data you need (requires Windows with Excel installed of course).

These functions should get you started:

CREATE "Excel.Application" chExcel.                   /* create a new Excel Application object */
chWorkbook = chExcel:Workbooks:Open(vl_input_file).   /* open the specified Excel document */
chWorkbook:Worksheets:Count()
chWorkbook:Worksheets(vl_int):Name
chWorksheet:Range("A1"):Value

This document helps get started on Excel ActiveX automation: http://progresscustomersupport-surv...1671?retURL=/apex/KnowledgeSearch&popup=false
And here are some more handy tips: http://www.oehive.org/node/555