I am trying to open particular Worksheet from MS Excel workbook (WIN32 :: OLE).
I cannot able to work on particular sheet. Please help me on this :
Code:
$Excel = Win32::OLE->GetActiveObject('Excel.Application'); $Excel->{'Visible'} = 0; $Excel->{DisplayAlerts}=0; # Open File and WorkSheet $Book = $Excel->Workbooks->Open("d:\test.xls");