You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The following example looks for costSheet in the spreadsheet file notfind.xlsx:
set PROD;
param cost {PROD};
table costTab IN "amplxl" "notfind.xlsx" "costSheet": [PROD], cost;
read table costTab;
But if costSheet does not exist, the following general error message is displayed:
Error reading table costTab with table handler amplxl:
could not find table
This confuses users because "table" refers both to the AMPL table and to a table of data in the spreadsheet. Instead, amplxl should identify the problem more specifically; for example, the error message could be
could not find a range or sheet named costSheet
The same comments apply to
table costTab IN "amplxl" "notfind.xlsx": [PROD], cost;
when no range or sheet named costTab can be found.
The text was updated successfully, but these errors were encountered:
4er4er4er
changed the title
Uninformative error message when spreadsheet location not found
Uninformative error message when range or sheet name not found
Jan 1, 2021
The following example looks for
costSheet
in the spreadsheet filenotfind.xlsx
:But if
costSheet
does not exist, the following general error message is displayed:This confuses users because "table" refers both to the AMPL table and to a table of data in the spreadsheet. Instead, amplxl should identify the problem more specifically; for example, the error message could be
The same comments apply to
when no range or sheet named
costTab
can be found.The text was updated successfully, but these errors were encountered: