Help for this page

Select Code to Download


  1. or download this
    # This is the code that works
    $mydata = [["Item",     "Category", "Price"], 
    ...
    # Write all the data at once...
    $rng = $xlBook->ActiveSheet->Range("A1:C7");
    $rng->{Value} = @mydata;
    
  2. or download this
    use Win32::OLE;
    
    ...
    $rng->{Value} = $mydata;
    
    print "All done.";