Originally posted by: gregkwaste

I am trying pare data directly from excel files, but for some reason I always get the "Exception from IBM ILOG Concert: Problem accessing the Excel file." error.

At first I was thinking that its my file's format or any false values in there, but i just found out about the oil example provided with CPLEX that supposedly reads from an xls file and to my great surprise I still get this error.

This line is enough to trigger the error :

SheetConnection sheet("oilSheet.xls");

Does anybody have a clue what is going on? Has something changed in 12.8 regarding excel files?

thanks in advance

Hi,

do you run on windows and do you have Excel installed ?

regards

Originally posted by: gregkwaste

I'm on win 10 right now. I did try from linux as well but there I get platform errors (I suppose interfacing with xls files does not work at all from linux). And yes I do have excel installed, this is how I created the excel files in the first place. I've also tried both the xlsx as well as the 2003 xls format.
 

Originally posted by: Marco S.

Hi, I´m getting the same error on win10 and office2016. Greg, have you solved this problem? Alex,do you have any suggestion?

Hi,

what happens when you run the Excel example that is in example/oil ?

regards

Originally posted by: Marco S.

Hi Alex.

Yes, I´m trying the oil example in OPL dir.

I think is something with my Office version. I´ll try another version or authenticate my version again.

Regards.

Originally posted by: gregkwaste

Hi Marco,

yes I did resolve this issue. So from what I understood cplex uses MSOffice dlls or something in order to interface with excel files. This process also involves some user authentication tests before being able to process anything, but there is no error reported to the user or anything if something goes wrong. So what I realized was that indeed I had to authenticate Office. Once I did everything worked perfectly. I hope this your issue as well.

Regards

Greg

Originally posted by: Marco S.

Hi Greg,

Thanks! I´ll try this.

Regards.