'How to Programmatically Create OOXML Strict Documents
It is possible to manually save an Excel spreadsheet as a "Strict Open XML" file in Excel filtype drop-down when using "Save as" instead of saving it as the default transitional OOXML file. The file format is the same .xlsx for both Strict and Transitional file format variants of the OOXML standard.
How can I do the same thing programmatically through automated workflows in e.g. C#? The purpose is to bulk convert Transitional Excel files to Strict Excel files.
I have found these code snippets part of the Office XML SDK:
- https://docs.microsoft.com/en-us/dotnet/api/documentformat.openxml.spreadsheet.conformanceclass?view=openxml-2.8.1
- https://docs.microsoft.com/en-us/dotnet/api/documentformat.openxml.spreadsheet.workbook.conformance?view=openxml-2.8.1#documentformat-openxml-spreadsheet-workbook-conformance
Can I use them or other ways of doing bulk conversion from Transitional to Strict?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|