[研究] C# .NET 存取 OpenOffice, LibreOffice Calc 試算表 .ods 套件評估

[研究] C# .NET 存取 OpenOffice, LibreOffice Calc 試算表 .ods 套件評估

2016-12-23, 2023-01-15 更新

Comparison of ODF software - The Document Foundation Wiki

https://wiki.documentfoundation.org/Comparison_of_ODF_software

ODF release dates:

ODF 1.0 May 2005

ODF 1.1 February 2007

ODF 1.2 September 2012

ODF 1.3 January 2020

OpenOffice
https://www.openoffice.org/zh-tw/

Apache OpenOffice - 維基百科，自由的百科全書
https://zh.wikipedia.org/wiki/Apache_OpenOffice

LibreOffice 
https://zh-tw.libreoffice.org/

LibreOffice - 維基百科，自由的百科全書 - Wikipedia
https://zh.wikipedia.org/zh-tw/LibreOffice

開放文檔格式 - 維基百科，自由的百科全書
https://zh.wikipedia.org/wiki/%E5%BC%80%E6%94%BE%E6%96%87%E6%A1%A3%E6%A0%BC%E5%BC%8F

(下圖) Office 2010 只支援到 ODF 1.1 版，Excel 2010 開啟 LibreOffice Calc 試算表 .ods 內容會失敗，Office 2013 和 2016 才支援目前最新的 ODF 1.2版

.ods  => OpenDocument Spreadsheet

(下圖) Excel 2010 開啟檔案支援格式

(下圖) Excel 2010 儲存檔案支援格式

微軟 Office 軟體對 ODF 的支援 FAQ
2015-06-16
https://blogs.technet.microsoft.com/officetw/2015/06/16/office-odf-faq/

OpenDocument 試算表 (.ods) 格式和 Excel Onnline (.xlsx) 格式之間的差異
https://support.office.com/zh-hk/article/OpenDocument-%E8%A9%A6%E7%AE%97%E8%A1%A8-ods-%E6%A0%BC%E5%BC%8F%E5%92%8C-Excel-Onnline-xlsx-%E6%A0%BC%E5%BC%8F%E4%B9%8B%E9%96%93%E7%9A%84%E5%B7%AE%E7%95%B0-0cbaf06f-7de3-4dbc-a5ac-8a8876835d37?ui=zh-TW&rs=zh-HK&ad=HK

Office 2007 with SP2 只支援到 ODF 1.1
https://forum.moztw.org/viewtopic.php?t=26832

國家發展委員會 - 推動ODF-CNS15251為政府文件標準格式
http://www.ndc.gov.tw/cp.aspx?n=D6D0A9E658098CA2
( 似乎推薦使用的是 Libre Office，而非 Apache Open Office )

8千名國稅局員工改用OpenOffice
文/楊晨欣 | 2013-01-15發表
http://www.ithome.com.tw/node/78367

********************************************************************************

OpenDocument Format for developers
http://www.opendocumentformat.org/developers/

ODFtoolkit.org AODL
Creator: SUN Microsystems
AODL is the .net module of the ODF Toolkit. The library is completly written in pure C# and can be used to extend your .Net based software to support the OpenDocument Format.
https://wiki.openoffice.org/wiki/AODL
https://wiki.openoffice.org/wiki/ODF_Toolkit
好像更新到2008.12版就不再更新，只支援到 ODF 1.1

ODF.net
Creator: Independentsoft
ODF .NET is Open Document Format API for .NET Framework and .NET Compact Framework. ODF .NET supports Open Document Format standard as defined in the OASIS Open Document Format. ODF .NET allows you to write applications to create, modify and parse text documents and spreadsheets. The API is written in 100% managed C# code.
http://www.independentsoft.de/odf
付費商業版，有30天試用版

Aspose.Cells

https://docs.aspose.com/cells/net/
Aspose.Cells for .NET supports the popular spreadsheet (XLS, XLSX, XLSM, XLSB, XLTX, XLTM, CSV, SpreadsheetML, ODS) file formats your business use every day. It also allows exporting Excel files to PDF, DOCX, PPTX, JSON, XPS, HTML, MHTML, JSON，Plain Text and popular image formats including TIFF, JPG, PNG, BMP and SVG.

Licensing|Documentation

https://docs.aspose.com/cells/net/licensing/#evaluation-version-limitations

Evaluation version of Aspose.Cells product (without a license specified) provides full product functionality, but it is limited to open 100 files in one program and an extra worksheet with evaluation watermark.

The limitations are shown below:

• Number of Opened Files (Aspose.Cells) When running your program, you can only open 100 Excel files using Aspose.Cells library. If your application exceeds this number, an exception will be thrown.
• Config file settings (Aspose.Cells.GridWeb) You can’t re-specify the script path by adding the following lines of code into the configuration section (e.g in the web.config file). The acw_client is a folder that contains files and Aspose.Cells.GridWeb uses this folder to manage its internal configuration, it has script files, image files and other files to specify GridWeb’s behavior and set other operations. The config file is used to prevent the control from using the embedded client resources (images, scripts, etc.) which is useful in some cases / scenarios. Moreover, this configuration settings in the web.config file will only take effect with the LICENSED version of the control.

Aspose.Cells 產品的評估版（未指定許可證）提供完整的產品功能，但僅限於在一個程序中打開 100 個文件和一個帶有評估水印的額外工作表。

限制如下所示：

• 打開文件數(Aspose.Cells) 當你的程序運行時，你只能使用Aspose.Cells庫打開100個Excel文件。如果你的應用程序超過這個數，將會拋出異常。
• 配置文件設置（Aspose.Cells.GridWeb） 您不能通過在配置部分（例如在web.config文件中）添加以下代碼行來重新指定腳本路徑。acw_client是一個文件夾，其中包含文件和Aspose.Cells.GridWeb使用這個文件夾來管理它的內部配置，它有腳本文件、圖像文件等文件來指定GridWeb的行為和設置其他操作。config文件用於防止控件使用嵌入式客戶端資源（圖像，腳本等），這在某些情況/場景中很有用。

Aspose.Words
Creator: Aspose
Aspose.Words is a class library that enables your applications to perform a great range of document processing tasks. Aspose.Words supports OpenDocument as well as DOC, MS Word 2007, RTF, HTML, PDF, XPS, EPUB and other formats. With Aspose.Words you can generate, modify, convert, render and print documents without utilizing other software.
http://www.aspose.com
沒看到支援odf、ods、OpenOffice、LibreOffice

Aspose.Recognition for .NET V1.1
Creator: Aspose
With Aspose.Recognition you can add intelligent PDF to word processing documents conversion to your 32-bit and 64-bit .NET applications. Aspose.Recognition reads a PDF file, recognizes editable document structures and allows saving the resulting document as OpenDocument (ODT), Microsoft Word (DOC) and Word 2007, Rich Text Format (RTF), WordprocessingML (XML), HTML, XHTML, MHTML and Plain Text (TXT).
http://www.aspose.com
沒看到支援odf、ods、OpenOffice、LibreOffice

GemBox.Spreadsheet
Creator: http://www.gemboxsoftware.com
GemBox.Spreadsheet is a .NET component that enables developers to write, read or convert spreadsheet files (XLS, CSV, XLSX, HTML or ODS) from their .NET applications using one simple API. GemBox.Spreadsheet requires only .NET Framework. GemBox.Spreadsheet Free is free of charge while GemBox.Spreadsheet Professional is a commercial version (licensed per developer).
商業付費，免費有限制

https://www.gemboxsoftware.com/spreadsheet/free-version
Maximum number of rows per sheet is 150.
Maximum number of sheets per workbook is 5.

XMLmind XSL-FO Converter
Creator: XMLmind
XMLmind XSL-FO Converter is an XSL-FO processor which converts XSL-FO v1.0 to Open Document Format and other tools. XMLmind XSL-FO Converter is available in two versions, targeted at the Java 1.4+ Platform and the Microsoft .NET 2.0+ Framework respectively.
http://www.xmlmind.com/foconverter | XSL-FO v1.0

商業付費

FreeSpire.XLS
https://www.nuget.org/packages/FreeSpire.XLS

Free version is limited to 5 sheets per workbook and 200 rows per sheet

********************************************************************************

找到一個範例

How to Read and Write ODF/ODS Files (OpenDocument Spreadsheets)
28 Jul 2011
https://www.codeproject.com/articles/38425/how-to-read-and-write-odf-ods-files-opendocument-s%20here%20for%20reference

(完)

相關

[研究] C# .NET 存取 OpenOffice Calc 試算表 .ods 套件評估
http://shaurong.blogspot.com/2016/12/c-net-openoffice-calc-ods.html

[研究] [C#] 讀取 LibreOffice 5.1.6 的試算表(Calc) 檔案 (.ods)(使用 .NET 4.5 的 ZipFile)
http://shaurong.blogspot.com/2016/12/c-libreoffice-516-calc-ods-net-45.html

[研究] [C#] 讀取 LibreOffice 5.1.6 的試算表(Calc) 檔案 (.ods)(使用 DotNetZip)
http://shaurong.blogspot.com/2016/12/c-libreoffice-516-calc-ods.html