"Stack trace: Invalid attempt to call SysExcelApplication.construct running in CIL on the client."
if we can use sysexcel then what is the option any reference.
"Stack trace: Invalid attempt to call SysExcelApplication.construct running in CIL on the client."
if we can use sysexcel then what is the option any reference.
You can't use SysExcelApplication from a batch job that executes on the server. If you cannot use the DIXF, remember that you are not bound to X++ , why not use C#.net and then consume the .net assembly in AX? If you want to follow this approach, it's explained in this Link
And if don't want to use C#.net use the CommaTextIo class to import csv file (you have to convert the excel file to csv)
Best regards..
Hi Axbeginerss,
You can take a look at EPPlus library as well
Have you already tried something like what is mentioned in this link?
Only excel ...any suggestions.
I think importing using CSV files will be the easiest to implement. Will that be an acceptable solution or do you clients want to import excel files only?
As per the client requirement ..i cant use DIXF so..do u have another option that can help to import data from batchjob any reference??
I don't think you can run SysExcelApplication in batch class. It only works on client.
Can you not use DIXF for importing excel files?
yes...thats the place i am getting the error.
Hi,
Are you using SysExcelApplication in a batch process?
André Arnaud de Cal...
292,884
Super User 2025 Season 1
Martin Dráb
231,748
Most Valuable Professional
nmaenpaa
101,156
Moderator