Help for this page

Select Code to Download


  1. or download this
    my @value;
    
    ...
            $cell ? $cell->value() : '';
        } @required_col;
    }
    
  2. or download this
    ##to get the headers of the excel file;
    my @value = map {
        my $cell = $worksheet->get_cell(0, $_);
        $cell ? $cell->value() : '';
    } @required_col;
    
  3. or download this
    sub changeformat {
        my ($header,$data) = @_;
        my @header = @$header;
        my @data = @$data;