Solapas principales

Pregunta
Flávio Lúcio Na... · Ago 27, 2019

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.

00
0 7 206 1

Respuestas

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!

Thank you,

But how i use the RTD or DDE function?