web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Export to excel throug...
Microsoft Dynamics AX (Archived)

Export to excel through batch process

(0) ShareShare
ReportReport
Posted on by Pravasti AK 2,985

When I try to do i am getting error when i tried to run in batch.

. System. NullReferenceException: Object reference not set to an instance of an object. at Dynamics. Ax.fim.spreadsheet .

error line "spreadSheet.InstantiateColumn(columnProperties);".help me out to go ahead with my process.

Reply

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    Where did you try this export? In which form/report?

    Best regards,

    Ludwig

  • Pravasti AK Profile Picture
    Pravasti AK 2,985 on at

    Hi ludwig,

    From customized form i am pulling around 20 fields into excel.when i try to run as a job its working fine.I also tried using sysexcelapplication classes  it ended up with error in sysexcelapplication ::construct  ().Later i decided to use fim classes but it also ended up with error.

  • Community Member Profile Picture
    Community Member on at

    Hi Kavitha Rajan

    The error occur when you try run the export by job ?

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    The excel class can not run in a batch process, you can use the IO framework and convert the csv file into a excel using a Dll.

    You will run one batch to create the csv file and a second batch to convert the cvs to a excel file (using dll).

    There is a lot of examples how to convert a csv file into a excel file using .NET (dll).

    Thanks!

  • Community Member Profile Picture
    Community Member on at

    I tried that and didn't worked.

    So I did what I wrote in my post.

  • Verified answer
    Pravasti AK Profile Picture
    Pravasti AK 2,985 on at

    Hi All,

    Filename is not passed properly ,and thats fixed the issue.

    Thanks,

    Kavitha.

  • Community Member Profile Picture
    Community Member on at

    Hi,

    Did anybody try to export in excel in batch because i am also facing the same issue as it is working fine interactively but not working in batch mode and saying that it can only be run on client. Also , sysexcel classes construct are set on client only so how it can run on batch mode.

    Please revert if anybody has done it or have any solution.

    Thanks & Regards,

    Lalit Gupta

  • Suggested answer
    Pravasti AK Profile Picture
    Pravasti AK 2,985 on at

    Hi Lalit,

    Please follow the below link :

    http://sashanazarov.blogspot.com/2012/11/exporting-to-excel-with.html

    Thanks,

    Kavitha

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans