current script:
$ws = $wb->Worksheet("Food_List");
if ( !$ws ) {
print LOG
"Error: Required 'Food_List' excel spreadsheet(tab). Review worksheet naming convention";
exit 1;
}
so now we need to match the worksheet to 'Food_List'. What if I want to allow more flexibility and allow 'food_list', or 'FOOD_LIST'worksheet?
Assuming you're using
Spreadsheet::ParseExcel
:Update: Use get_name and it works.