Originally posted by: BhavnaJha

I have double checked my ranges, all seems correct but I still get the error, can not read data from excel. 

Is there a limit to the amount of data it can read from excel? 

PLEASE HELP! 

Originally posted by: BhavnaJha

My Data range is not even huge. It is from D2:K613. But there are many such data sets.

Originally posted by: Michel_Le

Hi,

- What is the exact error message if any ? 

- Do you have Excel installed ? 

- Can  you read your Excel file outside of OPL ? 

- Can you share your mod, dat and excel file ?

Originally posted by: a_wuensch

Hi,

I'm also struggling with the same issue. Maybe you can have a look at my files, too. You can find them in my own thread https://www.ibm.com/developerworks/community/forums/html/topic?id=197a2070-e4fe-464e-9bb2-311b50b30e80&ps=25.

- What is the exact error message if any ? : Exception from IBM ILOG Concert: Can not read data from excel.

- Do you have Excel installed ? Yes, Excel 2016, 64-bit

- Can  you read your Excel file outside of OPL ? Yes

- Can you share your mod, dat and excel file ? see my thread

Thank you.

I will answer  there

Originally posted by: BhavnaJha

I have just changed the sheet from where to read, not even the range.

Earlier my  program was working but now it shows "can not read data". Is there a limit on the size of an excel file you could read from? 

Hi,

can you try the trick I gave at

https://www.ibm.com/developerworks/community/forums/html/topic?id=197a2070-e4fe-464e-9bb2-311b50b30e80&ps=25

?

(Split into smaller rectangles)

regards