2016年12月29日 星期四

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

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

2016-12-23

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.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.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).
商業付費,免費有限制
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
商業付費

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

找到一個範例

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

沒有留言:

張貼留言