OpenXML in AX2012

(0) Share

Report

Posted on by Community Member

Hi there,

I want to use OpenXML for a Excel export in AX2012. The OpenXML assembly reference is registered in my AOT.

So i found heaps of examples using C# - how can i transition them to X++? I know i have to use full qualified names, but still X++ gives me

Syntax errors, e.g.:

DocumentFormat.OpenXml.Packaging.SpreadsheetDocument    spreadSheet;
DocumentFormat.OpenXml.SpreadsheetDocumentType          doctype;  
spreadSheet = DocumentFormat.OpenXml.Packaging.SpreadsheetDocument.Create(filename, doctype, true)

Also, how do i deal with the generics used in C#?

I'm new to AX, so please give a detailed description of your solutions. Thanks in advance!

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Zain Bokhari 3,208 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

I think this link might help you resolve your errors.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks for your answer. This already helped me a lot, I'm still struggling to create a working example though.

Do you have a example for just a basic file with one sheet and some data for me? Thanks alot in advance.

Was this reply helpful? Yes No
Martin Dráb 238,147 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I provided a trivial example in a similar thread, Create/Read/Write Word Document using Open XML.

Was this reply helpful? Yes No