how read and change columns in .xls

[sneg86]

i have a rather big .xls file and some columns should be read and shanged if it's necessary. how could it be managed??
thanks..

 

[greadey]

use WIN32::OLE, there are specific examples dealing with Excel in the documentation.

 

[greadey]

There is also Spreadsheet::WriteExcel as well which might be useful.

 

[sneg86]

I have some problems with WIN32::OLE, (Win32::OLE(0.1501) error 0x800a03ec in METHOD/PROPERTYGET "Open&quot i've read that OLE::Storage_Lite needed for WIN32::OLE correct work but unfortunately i can't install this module (it is not intended for this build of Perl (MSWin32-x86-multi-thred)) so .. maybe it's not my day??

 

[greadey]

I haven't got the storage lite module installed on my system and Win32::OLE works perfectly.

Maybe you have got a small syntax error or something.

If you look into the win32:le docs you can copy and paste some code from there and try and run it to see if it works.

 

[r9ronaldo]

Having used Perl very Rarely, this may be a very elementary question.
I have a Perl script which uses write_excel/parse_excel modules, when I try to run this script, It's not working, Other than that I was able to run other Simple Perl scripts successfully.
Should I install any thing special, Please guide me on getting this Perl Module script to runnning.

Thanks for all your time

R9ronaldo

forza inter

 

[PaulTEG]

What version of Perl are you using

ActiveState
on a command line
ppm install Spreadsheet-WriteExcel
ppm install Spreadsheet-ParseExcel

HTH
--Paul