in reply to Re^2: WIN32::OLE Excel Pivot Table Grief
in thread WIN32::OLE Excel Pivot Table Grief
I think the error is earlier. If you add the following lines to your code, it will tell you where:
use Win32::OLE::Const 'Microsoft Excel'; # instead of the constants Win32::OLE->Option( Warn => 3 );
something seems to be wrong at CreatePivotTable
$_app_object->ActiveWorkbook->PivotCaches->Add({SourceType => xlDa +tabase, SourceData => 'Sheet1!R1C1:R4C3'})->CreatePivotTable({TableDe +stination => 'Sheet1!R8C3', TableName => 'PivotTable1', DefaultVersio +n => xlPivotTableVersion10});
Best regards,
perl -e "s>>*F>e=>y)\*martinF)stronat)=>print,print v8.8.8.32.11.32"
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^4: WIN32::OLE Excel Pivot Table Grief
by Anonymous Monk on Nov 21, 2007 at 01:42 UTC | |
by Anonymous Monk on Feb 21, 2008 at 13:26 UTC | |
by Anonymous Monk on Apr 05, 2009 at 04:07 UTC | |
by Anonymous Monk on May 13, 2016 at 02:01 UTC |
In Section
Seekers of Perl Wisdom