Solved

Error when importing percentage data from Excel to an AIMMS model

  • 26 December 2020
  • 2 replies
  • 102 views

I have been trying to import the phasing in capital data which is in the attached Excel file. I have added the identifiers on the attached word file. The data I am importing has numbers which I want AIMMS to convert to percentages.

On my side the PhasingInCapital is a worksheet inside the Input Data workbook. Here is the error:

ExcelSetActiveSheet(Input Data.xlsx, PhasingInCapital) failed: Workbook doesn't contain the specified sheet. Invalid index.

I have imported a lot of data files from Excel, I am not sure what am I doing wrong this time.

Please assist.

icon

Best answer by mohansx 12 January 2021, 22:55

View original

2 replies

Userlevel 5
Badge +5

Hello @Mantombi , believe the identifier ExcelworkbookName is pointing to file “Input data.xlsx” which does not have this sheet “PhasingInCapital”, which is in the attached file “PhasingInCapital.xlsx”.

 

You can try copying this sheet into Input data.xlsx or, update the ExcelworkbookName to point to PhasingInCapital.xlsx and open that file. 

Userlevel 5
Badge +5

Or check if the sheet name has spaces - “Phasing in Capital”

Reply


Didn't find what you were looking for? Try searching on our documentation pages:

AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator