Discussion (7)1
Log in or sign up to continue

What do you want to achieve?

Do you want to read or write excel files?

Thank you Henrique,

But i need to write Excel files with a client server architecture, this is not a web application. I thought in a Class or something like this.

@Flávio Lúcio Naves Júnior 

Check out my thread: https://community.intersystems.com/post/use-cache-write-excel-files

Basically people mentioned using Zen, Apache POI or Python.

What we ended up doing was reverse engineering a Excel spreadsheet and using the %XML.Writer class, created functions to build out an XML file that is built and optimized for Excel.  The problem is that you're left with just and XML file and not a true Excel file.  We are working on that post processing challenge now.

Hope this helps!