guha has asked for the wisdom of the Perl Monks concerning the following question:
Hi fellow monks, today I have spent some time trying to transponate a range (2D-grid) in Excel.
I have followed the usual(?) procedure to record a macro in excel doing the operation and then converting the VBA-code to perl
OLE exception from "Microsoft Excel": Could not find PasteSpecial property for the Range class Win32::OLE(0.15) error 0x80020009: "Exception occured" in METHOD/PROPERTYGET "PasteSpecial" at cp2.pl line 31
I have followed the usual(?) procedure to record a macro in excel doing the operation and then converting the VBA-code to perl
The line that does the actual transpose look like this
This results in the following errormessage from Win32::OLE$sheet->Cells(10,5)->PasteSpecial( {Paste => xlAll, Operation => xlNone, SkipBlanks => 0, Transpose => 1 });
OLE exception from "Microsoft Excel": Could not find PasteSpecial property for the Range class Win32::OLE(0.15) error 0x80020009: "Exception occured" in METHOD/PROPERTYGET "PasteSpecial" at cp2.pl line 31
I get the same errormessage when I invoke the function with the more standard call approach
HOWEVER when I skip the fourth argument, "Transpose", thing work OK except that no transposition is done as the argument defaults to false$sheet->Cells(10,5)->PasteSpecial(xlAll, xlNone, 0, 1);
Any ideas someone??
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Troubles transposing a range in Excel with Win32::OLE
by jmcnamara (Monsignor) on Jan 10, 2002 at 04:21 UTC | |
by guha (Priest) on Jan 10, 2002 at 14:10 UTC | |
by jmcnamara (Monsignor) on Jan 10, 2002 at 19:10 UTC | |
Re: Troubles transposing a range in Excel with Win32::OLE
by c-era (Curate) on Jan 10, 2002 at 01:34 UTC |
Back to
Seekers of Perl Wisdom