Hi,
I want to read data for a parameter P(x,y) from excel file. The parameter is two dimensional.
And the data lies in one of the sheet(say Demand) of a excel file(say DataFile).
I have tried ReadList but it is not working as the range of x lies in A2:A50 and the range of y lies in E2:E50 and data lies in T2:T50.
Help me to read the data with out creating another sheet.
Best answer by MarcelRoelofs
Alternatively, use the DataExchange library and bind column A to x, column E to y and map column T to P. I assume the names to bind/map to can be found in header (i.e. row 1) of those columns.
Hi
Please check out:
+5Alternatively, use the DataExchange library and bind column A to x, column E to y and map column T to P. I assume the names to bind/map to can be found in header (i.e. row 1) of those columns.
Going forward,
Might you be interested to learn more, check out this post:
Already have an account? Login
Please use your business or academic e-mail address to register
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Didn't find what you were looking for? Try searching on our documentation pages:
