Need code for Excel file upload in SysOperation Framework with Excel Pakages

Finance and Operations/AX
1

Hi Developers,

Could please anyone provide code for data import from excel to d365 F&O through code only. The file should be uploaded in my own custom table which had date, enum and string variables.

Pls anyone help me.

Thanks,

Mustafa.

2

Hi,
If you are using D365FO, you can use DIXF to import the excel data. Is there any specific reason for importing the excel through code?

3

Yes, I have a task to do.

4

Hi @Mustafa_Ahmed,

I’m afraid this won’t be possible since Excel is a client application and cannot be set to run on the server side. As you said, your requirement is to upload data from Excel into your own custom tables using SysOperationFramework - this Framework is running on server side, thus making this impossible. Could you please elaborate what kind of ‘Excel’ files are you talking about ? Because if you are talking about .csv files, then you can achieve this by storing your .csv files on Azure Storage, and then fetch them from there, process the data in them and insert the processed data in your custom tables in D365 FO.