Reading from excel worksheet

[pranav]

Hi,

I am having a situation where I require to read data from an excel sheet. I know that an excel sheet can be converted to an CSV file which can be utilized but that would make our process manual, while we want it to be automated.
Is there any way by which we can directly read from an excel sheet if we have the format of data fixed within. I use the server edition for development purpose.

Many thanks
Pranav

[DSguru2B]

You will need to purchace a unix based odbc driver to connect to xls files. Other than that it is not possible to read xls files.

[ray.wurlod]

You can create a small Windows application to dump the worksheet in CSV format (and, perhaps, to initiate a file transfer), and invoke that remotely from the UNIX machine. Otherwise, you need to acquire a UNIX-based ODBC driver for Excel.

[sb_akarmarkar]

Use ExecSH before-subroutine to rename the file... even you can pass parameter for file name


Thanks,
Anupam
sb_akarmarkar@smart-bridge.co.in

[TJX Companies]

Hi Pranav,

Did you resolved this issue ? I have same problem in my project and would like to know how you resolved this. Did you acquired ODBC driver for Excel ? Could you please let me know ?

Thanks,

Aruna.