protected void setupData() { SalesCreateOrder_SalesTable_CustAccount = "US-010"; }
how read data from excel file on Virtual machine , to store values in above defined variable !!
It is not possible to read the data from an excel file stored on a location in a virtual machine. The vm is hosted on azure. For this scenario, as Girish suggested, user have to upload the file and then you need to read that file and from that you should be able to save the data.
Hi Sachin,
What are the business requirements?
Also, you cannot hard code the path of the VM machine where the file is present - You need to build the dialog - Get a file from the user and the process the file. Refer to the blog I posted above.
Thanks,
Girish S.
Hi sachin,
Are you asking how to import data from excel?
If yes, please refer to the below blogs and see if it helps.
https://www.cloudfronts.com/blog/dynamics-ax/x-code-to-import-data-from-excel-to-d365-fno/
https://www.d365snippets.com/2021/12/how-to-import-records-from-excel-using-xpp-code-in-d365fo.html
Thanks,
Girish S.
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156