You’re offline. This is a read only version of the page.
Hi All,
I am currently working on a report using OpenOffice 4. I have a form and a button where the user would click and export the data into an excel sheet. My environment doesn't have MS Excel installed so that is thrown out the window. I did some research and found out that there is a class called "XMLExcelDocument_RU" that you can used to export data. I downloaded OpenOffice 4 and installed on my environment. I began my development and found out I wasn't able to create a file and writing to the file. So what I did was I created a MS Excel file else where with dummy data and saved it on the environment where I'm doing my report. I then create a new instance of XMLExcelDocument_RU class and was able to read and write to the file. My question is, is there a way for me to create a new file so I don't have to create an excel file somewhere else and then bring it into my environment to do my report? I have looked at the documentation for XMLExcelDocument_RU and wasn't able to find any method where it would create a new file. Thanks in advance!
*This post is locked for comments
I have the same question (0)
Not without installing a supported version of Microsoft Excel I am afraid. The classes involved which Sukrut has linked is using the API of Excel itself to generate the file, so you cannot avoid having a product purchased and installed.
OpenOffice is not supported by Microsoft Dynamics AX.
Maybe one way around could be to find an Office substitution product which can generate XLSX file, and also has some sort of API or command-line parameters, so you would be able to call it from AX to generate the file for you in the expected format.
Share
Report
All responses (
Answers (
46,149
