Topics started by edward1994
Hello AIMMS community!I currently working with aimms on my thesis and for my model i need the MainExecution read a huge amount of sets and parameters. For that I’m using Excel-Sheets. I also going to need subsets and here is my, i think, for you, very simple question:How can I exclude Excel cells from being readed? For example one of my sets is readed asSpreadsheet::RetrieveSet ( WorkbookName, facilities, "A4:A75");If now a subset of facilities is not contigious in this column A4:A75 but instead maybe the cells A10 to A15 and A20 to A30 and A50. How would i retrieve this subset? I tried this (see below) and many other variants and nothing worked. Hope you can help me. Spreadsheet::RetrieveSet ( WorkbookName, facilities, "A10:A15+A20:A30+A50");
Already have an account? Login
Please use your business or academic e-mail address to register
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.