Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

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\ 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});
    +a') );
    +'b')->{Position}    = 2;
    +'a')->{Subtotals} = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0];

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (5)
As of 2015-11-27 16:14 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (731 votes), past polls