I have implemented a feature where a solution can interact with Word documents, by filling out or reading values from Sdt controls. The Sdt Controls are each given a Tag value that identifies the content of the tag.
This enables me to create/update a Word document from the solution, let the user fill out the document, and upon save/close of Word I can read out the values and persist the values in a database.
I now have a feature request for obtaining the same functionality for Excel (Aspose.Cells).
What is the best practice for doing this in Excel?
What I need is:
- a way to identify where to insert values (same value can be put multiple places, several cells in Excel can have same Tag value)
- a way to find what the users has entered in the cells (if multiple tags, just the “first” that matches the tag value)
- If possible a way to programmatically remove the fields if an Excel sheet is to be sent to external systems/parties
- If possible the same as Word Sdt where you can define if it is a Date, DropDown, text or checkbox field)
I hope some of you have experience with this and can give a headstart on what works - and what doesn’t work.