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.
Discussion (7)0
Log in or sign up to continue
https://community.intersystems.com/post/does-anyone-know-if-iris-or-cach%C3%A9-has-functionality-excel-dde-or-rtd
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.
@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!
Check this post.
Thank you,
But how i use the RTD or DDE function?