Help for this page

Select Code to Download


  1. or download this
    my $excel = Win32::OLE -> new("Excel.Application");
    $excel->{Visible} = 0;
    ...
    my $workbook1    = $excel->Workbooks->Open($OutFileName);
    
    my $worksheet1  = $workbook1->Worksheets(1);
    
  2. or download this
        $worksheet1->Cells($Row, $Col)->{'Value'} = $var1;
        $worksheet1->Cells($Row, $Col+1)->{'Value'} = $var2;
        $worksheet1->Cells($Row, $Col+2)->{'Value'} = $var3;
        $worksheet1->Cells($Row, $Col+3)->{'Value'} = $var4;
    
  3. or download this
        for i = 1:num_worksheets
        # write in worksheet[i] cell (j,k) with variable var1
        end