Hello,
I have an excell file with multiple worksheets in it.
The code shown below does not creat the .txt file and also
it does not convert all the workshees to csv(it only creates
one work sheet always irrespective of the worksheet number
I chage like 1, 2, 3, ....).
Can any one help me?
use Win32::OLE;
$excel = Win32::OLE->new ('Excel.Application') || die "Could not open $!
\n";
$sheet = $excel->workbooks->open("abcd.xls")->Worksheets(2);
$sheet->SaveAs( "c:\\data1\\share\\abcd.csv",24);
$sheet->SaveAs( "c:\\data1\\share\\abcd.txt",'xlText');
$excel-> Quit();
Thanks in advance
Krishna
_______________________________________________
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
