To upload an excel :https://documentation.aimms.com/webui/upload-widget.html and then act on the file through the standard AXLL functions.

https://how-to.aimms.com/Articles/85/85-using-axll-library.html
 

hope this helps

@vishweshpatil The FileSelect function will not work with WebUI apps.

Replace FileSelect with FileExists instead and your procedure should work. 

Also, make sure that you are opening the correct workbook in the procedure pr_readInputMasterDataFromExcel. 

You are checking for the file ``excelFileName`` but later on opening the file ``excelFileNameMaster``. 

In the upload widget procedure, you are copying the file to central storage with path ``sp_PublicDataExchangeFileName``. I think you should be checking the existance of this file and then open it to read data from it. 

if not FileExists(sp_PublicDataExchangeFileName) then

return;

endif;

axll::closeallworkbooks;

axll::openworkbook(sp_PublicDataExchangeFileName);

I also wanted to know, when we upload a file to cloud central storage vis upload widget (Eg:"pro:/PublicData/ExchangeFilename"), how can we access that file? Assuming it is an excel file and we need to read it via AXLL Library.

@vishweshpatil 

you are already using pro::SaveFileToCentralStorage to copy files on there. You can use the companion function pro::RetrieveFileFromCentralStorage to do the opposite. 

AIMMS PRO and Data Management — AIMMS Documentation