Does Anyone Know if IRIS or Caché has functionality for Excel DDE or RTD?
Hello Everyone,
I want to Know Caché or IRIS has some way to communicate with DDE or RTD from Excel?
Att. Flávio.
Comments
What do you want to achieve?
Do you want to read or write excel files?
I want to write Excel files.
@Flávio Lúcio Naves Júnior maybe this article can help you:
https://community.intersystems.com/post/light-weight-excel-download
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.
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!
Check this post.
Thank you,
But how i use the RTD or DDE function?