Hi,

I have a question. I tried to import Excel data to CPLEX but it doesn't work.

There is a problem accessing the Excel file. Can anyone help me how to solve this problem? Here I give the file.data of my file

depot={"D1", "D2"};

customer={"C1", "C2", "C3", "C4", "C5", "C6", "C7", "C8", "C9", "C10", "C11", "C12" };

node={"C1", "C2", "C3", "C4", "C5", "C6", "C7", "C8", "C9", "C10", "C11", "C12", "D1", "D2" };

vehicle={"V1", "V2"};

SheetConnection excelsheet("Exceldata.xlsx");

dist from SheetRead(excelsheet, "dist");

fcost = [100, 100];

D= [20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20];

VC=[140, 140];

VD=[280, 280];

Thank you in advanced.

Hello,

The database support has been updated in version 20.1.

Here is the related documentation:

https://www.ibm.com/support/knowledgecenter/SSSA5P_20.1.0/ilog.odms.studio.help/OPL_Studio/oplrelnotes/topics/opl_relnotes_V201_DBsupport.html

This forum will be sunset soon.

If you need further discussion, please open a support case if you are entitled.

Otherwise, please discuss your question in Data Science Community https://community.ibm.com/community/user/datascience/communities/community-home/digestviewer?communitykey=ab7de0fd-6f43-47a9-8261-33578a231bb7&tab=digestviewer