I wanted to know how is one supposed to take input from excel sheet when I publish my app on Cloud. I have tried uploading the excel sheet on cloud but I’m not sure how to locate the file on cloud and read data from that. Could you please guide me through this? Thanks.
I have attached some screenshots for your reference.
+6
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
+5
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);
+2
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.
+5
you are already using pro::SaveFileToCentralStorage to copy files on there. You can use the companion function pro::RetrieveFileFromCentralStorage to do the opposite.
Already have an account? Login
Please use your business or academic e-mail address to register
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Didn't find what you were looking for? Try searching on our documentation pages:
