Notice
Starting from GemBox.Spreadsheet 3.7, all methods presented on this page are obsolete.
For more information about all obsolete members and their alternatives, see GemBox.Spreadsheet Obsolete Members.
GemBox.Spreadsheet 2.9 introduces support for XLSX files (Open XML format).
However, builds for different frameworks have different ways of supporting XLSX format:
| Target Framework | Supported OpenXML load/save methods |
|---|---|
| .NET Framework 1.1 | LoadXlsxFromDirectory(string,XlsxOptions) SaveXlsxToDirectory(string) |
| .NET Framework 2.0 | LoadXlsxFromDirectory(string,XlsxOptions) SaveXlsxToDirectory(string) |
| .NET Framework 3.0 (only WindowsBase.dll from .NET Framework 3.0 is used) | LoadXlsx(string,XlsxOptions) LoadXlsx(string,XlsxOptions) LoadXlsx(Stream,XlsxOptions) LoadXlsx(Stream,XlsxOptions) SaveXlsx(string) SaveXlsx(Stream) LoadXlsxFromDirectory(string,XlsxOptions) SaveXlsxToDirectory(string) |
Version for .NET Framework 3.0 requires that your machine contains WindowsBase.dll from .NET Framework 3.0 (you don’t have to reference it directly; it is used by our assembly). You have various LoadXlsx() and SaveXlsx() overloads which allow you to read/write XLSX files directly.
Versions for .NET Framework 1.1 and 2.0 lack support for opening/creating ZIP files (XLSX files are internally ZIP archives). Therefore, if you use that DLLs you need to use LoadXlsxFromDirectory() and SaveXlsxToDirectory() methods which read/write contents of entire XLSX file from/to directory. Therefore, you will need some external ZIP tool which can extract ZIP archive (with XLSX extension) to a certain directory (for loading) and can compress the contents of a certain directory to ZIP archive (with XLSX extension). You can use shell ZIP tools or some free .NET libraries as SharpZipLib.
Feel free to report any problems with XLSX support to support@gemboxsoftware.com