How to get the cell data in to the varaible from existed Excel file.

[Bsr]

Hi,


Please tell the solutions for the following queries.

1. How to read the data from Excel file.
2. How to get the cell data in to the varaible from existed Excel file.

Its very argent for me. Please do the needful

Bhuvan

[miller]

Hi Bhuvan,

For parsing an excel file, use the following:

cpan Spreadsheet::Pa rseExcel

- Miller

[Bsr]

Hi Miller,

Thanks for reply.

I tried ,but i was not able to get.

My Question:

I have test2.xls file it has some data.

I want to open that file,read the data from the same file, get the content of the cell in to in scalar variable and display the same(content) at the command prompt.


Please help me with sample code if anybody knows.its argent for me.


Regards
Bhuvan