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.