Originally posted by: sdormidontov

Hello!

I have a problem with connection to the xls and xlsx files.

in .dat file I've got:

SheetConnection sheet1("Book.xlsx");
data1 = 1;
data2 = 2;

// and so on...

As you can see I even do not use my connection to the spreadsheet, only try to connect.

After running configuration following error is raising:

internal error (please notify IBM)

If I comment string

// SheetConnection sheet1("Book.xlsx");

everything works fine

• I tried to install different versions of CPLEX ILOG Studio (12.5.1 - 64b, 12.6.0 - 64b, 12.6.0 - 32b)
• Version of OS : Windows 7 - 64b
• Tried to install and run ILOG as Administrator
• Tried to create xlsx and xls files using Lotus Symphony, Google-docs, Office-online

Even when I try to launch standard example 'oil' which is preset in CPLEX Studio, configuration with xls file does not work (It seems very unlikely that developers did not test their example)

I also tried to install ILOG 12.5.1 on a different computer (with Windows Server 2008 64b installed on it) and have the same problem using example 'oil'

Please, help me. I absolutely lacked of ideas, but need to import data to the model from excel spreadsheets

Thank you!

Hi

is installing excel on your machine an option ?

regards

Originally posted by: sdormidontov

The problem is solved.

Yes, I needed excel to work with xlsx files (it seems like cplex uses some components of ms excel), that is why I installed trial version and test it - it worked

Anyway, thank you for your response