in reply to Trying to use Win32::OLE PasteExcelTable method

What is the meaning of  {'LinkedToExcel'} => 0? How do you get that from PasteExcelTable Method?

Replies are listed 'Best First'.
Re^2: Trying to use Win32::OLE PasteExcelTable method
by Anonymous Monk on Oct 02, 2014 at 00:01 UTC

    I think either  $range->PasteExcelTable( 0, 0, 0 );

    or  $range->PasteExcelTable({ LinkedToExcel => 0, WordFormatting => 0, RTF => 0, }); aka 

    my %args = ( qw/ LinkedToExcel 0 WordFormatting 0 RTF 0 / );
$range->PasteExcelTable( \%args );

    [download]

    But I don't have ole/word/excel/table to test

[reply]
[d/l]
[select]

      Thanks for the suggestions, but they didn't work either. I've listed the code lines and commented the exceptions/errors each gave me below

      my %args = ( qw/ LinkedToExcel False WordFormatting False RTF False / 
+);
    $range->PasteExcelTable( \%args ); #Gives me "Command not availabl
+e"
    #my %args = ( qw/ LinkedToExcel 0 WordFormatting 0 RTF 0 / );
    #$range->PasteExcelTable( \%args ); #Gives me "Command not availab
+le"
    #$range->PasteExcelTable( 0, 0, 0);  #Gives me "Command not availa
+ble"
    #$range->PasteExcelTable({'LinkedToExcel'} => 0, {'WordFormatting'
+ => 0}, {'RTF' => 0});  #Gives me "Invalid number of parameter"
    #$range->PasteExcelTable({'LinkedToExcel' => 0, 'WordFormatting' =
+> 0, 'RTF' => 0});  #Gives me "Command not available"

      [download]
[reply]
[d/l]
        Command not available seems like a very important message, like "out of hot dogs" ... you can't get a hot dog if the store doesn't have hot dogs
[reply]

In Section Seekers of Perl Wisdom