Hi Henry,
The Open-Xml-Sdk does not contain a calculation engine. Its purpose is only to read and write the file formats.
Typical uses with regards to Excel are:
- Generation of spreadsheets
- Querying spreadsheets and retrieving data
Modifying existing spreadsheets is a less common and useful scenario for the Open-Xml-Sdk.
If you need to have an actual calculation engine, you need to automate Excel. I believe that there are commercial products other than Excel that contain Excel compatible calculation engines, but I have no experience with them.
Regards, Eric
.
