Perl scripting help required

[viveks2585]

Hi,

Please help me.
I need a perl script which extracts the particular row, coloum from an excel sheet and puts it on a text file (*.txt).
Can any one help me out how it can be done.
I have been trying out with parseexcel, but not able to find the right way of doing it.


Thanks,
Vivek.S

 

[kam1787]

Excel has so many versions, I doubt the XLS file can be read directly

 

[viveks2585]

Hi,

xls file is the spreadsheet file format from microsoft office.
*.xls file it is.
I have tried to read from excel file and it works. but i am not able to pick from required column and row and put in on a txt file.

Please help me...

Thanks,

 

[lijason2009]

Hi,

You could try Spreadsheet:arseExcel in the cpan.

Thanks,
Jason

 

[viveks2585]

Hi Jason,

Thank you for the post. It was helpfull

Thanks,
VivekS