Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Uninformative error message when range or sheet name not found #15

Open
4er4er4er opened this issue Jan 1, 2021 · 1 comment
Open

Comments

@4er4er4er
Copy link

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.

@4er4er4er 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
@nfbvs
Copy link
Contributor

nfbvs commented Jan 5, 2021

Fixed in 44ff3c7

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants