Notifications
Announcements
No record found.
"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.
Hi,
Are you using SysExcelApplication in a batch process?
yes...thats the place i am getting the error.
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?
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 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?
Only excel ...any suggestions.
Have you already tried something like what is mentioned in this link?
Hi Axbeginerss,
You can take a look at EPPlus library as well
github.com/.../EPPlus
stackoverflow.com/.../epplus-read-excel-table
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..
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 565 Most Valuable Professional
André Arnaud de Cal... 450 Super User 2025 Season 2
Sohaib Cheema 250 User Group Leader
