hi,
Refering to thread: Open and create new Excel file with Perl and win32::OLE
Can you please give a code to save an excel sheet with a different extension?
my $Excel = Win32::OLE-> new ('Excel.Application', 'Quit') or die ("Can't create object: ", Win32::OLE->LastError());
$Excel->{DisplayAlerts}=0;
my $excelfile = 'C:\PERL\bin\INBOUND.xls';
my $Book = $Excel->Workbooks->Open($excelfile)or die ("Can't open Workbook: ", Win32::OLE->LastError());
my $Sheet = $Book->Worksheets("ELEMENT");
now i need to save the excel sheet ,ELEMENT to ELEMENT.csv as a different file into a different folder.how do i do this?