##to get the headers of the excel file; my @value = map { my $cell = $worksheet->get_cell(0, $_); $cell ? $cell->value() : ''; } @required_col;