KB-29645: Communication between E3 and Excel via DDEClient.

Question:

Is it possible to read/write data in several spreadsheets of an Excel file?

Solution:

Yes, it is. To do so, insert a DDEClient driver, and set Excel as the DDE server. Next, insert as many I/O tags in the application as there are spreadsheets set on Excel, and set each tag’s Device property with the name of one of the spreadsheets. That way, you will be able to use each tag’s paramDevice property to signal the spreadsheet to be handled. Later, you can insert another I/O tag to read/write values, typed as SetPoints by the user, to the desired cell.

Attached to this article is a sample application illustrating this case.

Note: You can find all drivers available for download by Elipse at our website.

Attachments:

ExemploDDE

Print Friendly, PDF & Email

Este artigo foi útil? Was this helpful?

Classificação média - Average rating 0 / 5. Count: 0

Leave a Reply

Your email address will not be published.Required fields are marked *