"be consistent" | |
PerlMonks |
Unable to set the Function property of the PivotField classby Michaelc (Initiate) |
on Nov 18, 2014 at 21:07 UTC ( [id://1107649]=perlquestion: print w/replies, xml ) | Need Help?? |
Michaelc has asked for the wisdom of the Perl Monks concerning the following question: I am trying to change Pivot table {Function} property to specify it is xlCount or xlAverage or xlSum etc. But I got the error msg below: ========== Unable to set the Function property of the PivotField class Win32::OLE(0.1711) error 0x80020009: "Exception occurred" in PROPERTYPUT "Function" at WeeklyRpt.pl line 138 ========== Here is the code. I am using Win32::OLE.
The last line code causes the problem. I have also ever tried $pv_table->PivotFields("Owner Region")->SetProperty("Function",xlCount); but does not work out either. Could you help out? Thank you!
Back to
Seekers of Perl Wisdom
|
|