Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re^4: WIN32::OLE Excel Pivot Table Grief

by Anonymous Monk
on Nov 21, 2007 at 01:42 UTC ( #652049=note: print w/ replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    OLE exception from "Microsoft Office Excel":
    
    ...
    
    Win32::OLE(0.1704) error 0x80020009: "Exception occurred"
        in PROPERTYPUT "Subtotals" at c:\bin\tmp.pl line 54
    
  2. or download this
    $_app_object->ActiveWorkbook->PivotCaches->Add({SourceType => xlDataba
    +se, SourceData => 'Sheet1!R1C1:R4C3'})->CreatePivotTable({TableDestin
    +ation => 'Sheet1!R8C3', TableName => 'PivotTable1', DefaultVersion =>
    + xlPivotTableVersion10});
       $_app_object->ActiveSheet->PivotTables('PivotTable1')->AddDataField
    +($_app_object->ActiveSheet->PivotTables('PivotTable1')->PivotFields('
    +a') );
    ...
       $_app_object->ActiveSheet->PivotTables('PivotTable1')->PivotFields(
    +'b')->{Position}    = 2;
    
       $_app_object->ActiveSheet->PivotTables('PivotTable1')->PivotFields(
    +'a')->{Subtotals} = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0];
    

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://652049]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (11)
As of 2014-07-25 10:37 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (170 votes), past polls