[研究]OpenOffice 4.1.10、LibreOffice 7.0.6 支援那些檔案格式 (副檔名)
2021-08-14
Apache OpenOffice
https://www.openoffice.org/zh-tw/
Apache_OpenOffice_4.1.10_Win_x86_install_zh-TW.exe
LibreOffice
https://zh-tw.libreoffice.org/download/libreoffice-still/
LibreOffice_7.0.6_Win_x64.msi
LibreOffice 可以儲存成 Excel 的 .xlsx 檔案格式。
(完)
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.IO; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using uno.util; using unoidl.com.sun.star.beans; using unoidl.com.sun.star.frame; using unoidl.com.sun.star.lang; using unoidl.com.sun.star.sheet; using unoidl.com.sun.star.table; using unoidl.com.sun.star.uno; namespace WindowsFormsApp1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Button1_Click(object sender, EventArgs e) { string fileName = ""; Stream myStream = null; OpenFileDialog openFileDialog1 = new OpenFileDialog(); openFileDialog1.InitialDirectory = "c:\\"; openFileDialog1.Filter = "ods files (*.ods)|*.ods|All files (*.*)|*.*"; openFileDialog1.FilterIndex = 2; openFileDialog1.RestoreDirectory = true; openFileDialog1.InitialDirectory = System.IO.Directory.GetCurrentDirectory(); if (openFileDialog1.ShowDialog() == DialogResult.OK) { try { if ((myStream = openFileDialog1.OpenFile()) != null) { label1.Text = openFileDialog1.FileName; // 包含路徑 string inputFilePath = openFileDialog1.FileName; // 包含路徑 fileName = openFileDialog1.FileName; // 包含路徑 XComponentContext context = Bootstrap.bootstrap(); XMultiServiceFactory factory = (XMultiServiceFactory)context.getServiceManager(); XComponentLoader loader = (XComponentLoader)factory.createInstance("com.sun.star.frame.Desktop"); PropertyValue[] args1 = new PropertyValue[1]; args1[0] = new PropertyValue(); args1[0].Name = "Hidden"; args1[0].Value = new uno.Any((Boolean)true); XSpreadsheetDocument doc = (XSpreadsheetDocument)loader.loadComponentFromURL("file:///" + fileName, "_blank", 0, args1); XSpreadsheets sheets = doc.getSheets(); //XSpreadsheet sheet = (XSpreadsheet)sheets.getByName("Sheet1").Value; XSpreadsheet sheet = (XSpreadsheet)sheets.getByName("工作表1").Value; // 繁體中文版 Office XCell cell = sheet.getCellByPosition(2, 2); label1.Text = cell.getValue().ToString(); } } catch (unoidl.com.sun.star.uno.Exception ex) { MessageBox.Show(ex.Message); } } } } } |
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.IO; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using uno.util; using unoidl.com.sun.star.beans; using unoidl.com.sun.star.frame; using unoidl.com.sun.star.lang; using unoidl.com.sun.star.sdbc; using unoidl.com.sun.star.sheet; using unoidl.com.sun.star.table; using unoidl.com.sun.star.uno; namespace WindowsFormsApp1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Button1_Click(object sender, EventArgs e) { string fileName = ""; Stream myStream = null; OpenFileDialog openFileDialog1 = new OpenFileDialog(); openFileDialog1.InitialDirectory = "c:\\"; openFileDialog1.Filter = "ods files (*.ods)|*.ods|All files (*.*)|*.*"; openFileDialog1.FilterIndex = 2; openFileDialog1.RestoreDirectory = true; openFileDialog1.InitialDirectory = System.IO.Directory.GetCurrentDirectory(); if (openFileDialog1.ShowDialog() == DialogResult.OK) { try { if ((myStream = openFileDialog1.OpenFile()) != null) { label1.Text = openFileDialog1.FileName; // 包含路徑 string inputFilePath = openFileDialog1.FileName; // 包含路徑 fileName = openFileDialog1.FileName; // 包含路徑 XComponentContext context = Bootstrap.bootstrap(); XMultiServiceFactory factory = (XMultiServiceFactory)context.getServiceManager(); XComponentLoader loader = (XComponentLoader)factory.createInstance("com.sun.star.frame.Desktop"); PropertyValue[] args1 = new PropertyValue[1]; args1[0] = new PropertyValue(); args1[0].Name = "Hidden"; args1[0].Value = new uno.Any((Boolean)true); XSpreadsheetDocument doc = (XSpreadsheetDocument)loader.loadComponentFromURL("file:///" + fileName, "_blank", 0, args1); XSpreadsheets sheets = doc.getSheets(); //XSpreadsheet sheet = (XSpreadsheet)sheets.getByName("Sheet1").Value; XSpreadsheet sheet = (XSpreadsheet)sheets.getByName("工作表1").Value; // 繁體中文版 Office XCell cell = sheet.getCellByPosition(2, 2); label1.Text = cell.getValue().ToString(); // ----- Write test cell.setValue(1000); cell = sheet.getCellByPosition(1, 1); cell.setFormula("Title"); XStorable xstorable = (XStorable)doc; PropertyValue[] storeProps = new PropertyValue[1]; storeProps[0] = new PropertyValue(); storeProps[0].Name = "Overwrite"; storeProps[0].Value = new uno.Any((Boolean)true); try { String sURL = "file:///d:/Temp/SaveTest2.ods"; xstorable.storeAsURL(sURL, storeProps); //if (doc != null) //{ // //XCloseable xCloseable = (XCloseable)doc; // //xCloseable.close(); // doc = null; // } } catch (unoidl.com.sun.star.uno.Exception ex) { MessageBox.Show(ex.Message); } } } catch (unoidl.com.sun.star.uno.Exception ex) { MessageBox.Show(ex.Message); } } } } } |
private void button2_Click(object sender, EventArgs e) { Stream myStream = null; OpenFileDialog openFileDialog1 = new OpenFileDialog(); openFileDialog1.InitialDirectory = "c:\\"; openFileDialog1.Filter = "ods files (*.ods)|*.ods|All files (*.*)|*.*"; openFileDialog1.FilterIndex = 2; openFileDialog1.RestoreDirectory = true; openFileDialog1.InitialDirectory = System.IO.Directory.GetCurrentDirectory(); if (openFileDialog1.ShowDialog() == DialogResult.OK) { try { if ((myStream = openFileDialog1.OpenFile()) != null) { label1.Text = openFileDialog1.FileName; // 包含路徑 string inputFilePath = openFileDialog1.FileName; // 包含路徑 fileName = openFileDialog1.FileName; // 包含路徑 XComponentContext context = Bootstrap.bootstrap(); XMultiServiceFactory factory = (XMultiServiceFactory)context.getServiceManager(); XComponentLoader loader = (XComponentLoader)factory.createInstance("com.sun.star.frame.Desktop"); PropertyValue[] args1 = new PropertyValue[1]; args1[0] = new PropertyValue(); args1[0].Name = "Hidden"; args1[0].Value = new uno.Any((Boolean)true); //XSpreadsheetDocument doc = (XSpreadsheetDocument)loader.loadComponentFromURL("file:///c:/a.ods", "_blank", 0, args1); XSpreadsheetDocument doc = (XSpreadsheetDocument)loader.loadComponentFromURL("file:///" + fileName, "_blank", 0, args1); XSpreadsheets sheets = doc.getSheets(); //XSpreadsheet sheet = (XSpreadsheet)sheets.getByName("Sheet1").Value; XSpreadsheet sheet = (XSpreadsheet)sheets.getByName("工作表1").Value; XCell cell = sheet.getCellByPosition(2, 2); label2.Text = cell.ToString(); cell.setValue(1000); cell = sheet.getCellByPosition(2, 3); cell.setFormula("Title"); XStorable xstorable = (XStorable)doc; PropertyValue[] storeProps = new PropertyValue[1]; storeProps[0] = new PropertyValue(); storeProps[0].Name = "Overwrite"; storeProps[0].Value = new uno.Any((Boolean)true); try { String sURL = "file:///c:/a2.ods"; xstorable.storeAsURL(sURL, storeProps); if (doc != null) { XCloseable xCloseable = (XCloseable)doc; xCloseable.close(true); doc = null; } } catch (unoidl.com.sun.star.uno.Exception ex) { MessageBox.Show(ex.Message); } //DataSet ds = ReadOdsFile(inputFilePath); DataSet ds = ReadOdsFile2(inputFilePath); dataGridView1.AutoGenerateColumns = true; dataGridView1.DataSource = ds; // dataset dataGridView1.DataSource = ds.Tables[0]; //using (myStream) //{ // // Insert code to read the stream here. //} } } catch (unoidl.com.sun.star.uno.Exception ex) { MessageBox.Show("Error: Could not read file from disk. Original error: " + ex.Message); } } } |
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.IO; using System.Text; using System.Windows.Forms; // 下載安裝 OpenOffice 4.1.3 SDK // "參考" 加入 C:\Program Files(x86)\OpenOffice 4\sdk\cli 目錄的 // cli_basetypes, cli_cppuhelper, cli_oootypes, cli_ure, and cli_uretypes.dll using unoidl.com.sun.star.uno; using unoidl.com.sun.star.lang; using unoidl.com.sun.star.frame; using unoidl.com.sun.star.beans; using unoidl.com.sun.star.sheet; using unoidl.com.sun.star.container; using unoidl.com.sun.star.table; using unoidl.com.sun.star.text; using uno.util; using unoidl.com.sun.star.util; //using unoidl.com.sun.star.sdbc; namespace ODSOpenOffice413SDKDemo { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private string fileName = ""; private void button1_Click(object sender, EventArgs e) { Stream myStream = null; OpenFileDialog openFileDialog1 = new OpenFileDialog(); openFileDialog1.InitialDirectory = "c:\\"; openFileDialog1.Filter = "ods files (*.ods)|*.ods|All files (*.*)|*.*"; openFileDialog1.FilterIndex = 2; openFileDialog1.RestoreDirectory = true; openFileDialog1.InitialDirectory = System.IO.Directory.GetCurrentDirectory(); if (openFileDialog1.ShowDialog() == DialogResult.OK) { try { if ((myStream = openFileDialog1.OpenFile()) != null) { label1.Text = openFileDialog1.FileName; // 包含路徑 string inputFilePath = openFileDialog1.FileName; // 包含路徑 fileName = openFileDialog1.FileName; // 包含路徑 //XComponentContext context = Bootstrap.bootstrap(); XComponentContext oStrap = uno.util.Bootstrap.bootstrap(); XMultiServiceFactory oServMan = (XMultiServiceFactory)oStrap.getServiceManager(); XComponentLoader loader = (XComponentLoader)oServMan.createInstance("com.sun.star.frame.Desktop"); string url = @"private:factory/scalc"; PropertyValue[] loadProps = new PropertyValue[1]; loadProps[0] = new PropertyValue(); loadProps[0].Name = "Hidden"; loadProps[0].Value = new uno.Any(true); //PropertyValue[] loadProps = new PropertyValue[0]; XComponent document = loader.loadComponentFromURL(url, "_blank", 0, loadProps); PropertyValue[] args1 = new PropertyValue[1]; args1[0] = new PropertyValue(); args1[0].Name = "Hidden"; args1[0].Value = new uno.Any((Boolean)true); //XSpreadsheetDocument doc = (XSpreadsheetDocument)loader.loadComponentFromURL("file:///c:/a.ods", "_blank", 0, args1); XSpreadsheetDocument doc = (XSpreadsheetDocument)loader.loadComponentFromURL("file:///" + fileName, "_blank", 0, args1); XSpreadsheets sheets = doc.getSheets(); //XSpreadsheet sheet = (XSpreadsheet)sheets.getByName("Sheet1").Value; XSpreadsheet sheet = (XSpreadsheet)sheets.getByName("工作表1").Value; XCell cell = sheet.getCellByPosition(2, 2); label1.Text = cell.ToString(); cell.setValue(1000); cell = sheet.getCellByPosition(2, 3); cell.setFormula("Title"); XStorable xstorable = (XStorable)doc; PropertyValue[] storeProps = new PropertyValue[1]; storeProps[0] = new PropertyValue(); storeProps[0].Name = "Overwrite"; storeProps[0].Value = new uno.Any((Boolean)true); try { String sURL = "file:///c:/a2.ods"; xstorable.storeAsURL(sURL, storeProps); if (doc != null) { XCloseable xCloseable = (XCloseable)doc; xCloseable.close(true); doc = null; } } catch (unoidl.com.sun.star.uno.Exception ex) { MessageBox.Show(ex.Message); } //DataSet ds = ReadOdsFile(inputFilePath); //DataSet ds = ReadOdsFile2(inputFilePath); //dataGridView1.AutoGenerateColumns = true; //dataGridView1.DataSource = ds; // dataset //dataGridView1.DataSource = ds.Tables[0]; //using (myStream) //{ // // Insert code to read the stream here. //} } } catch (System.Exception ex) { MessageBox.Show("Error: Could not read file from disk. Original error: " + ex.Message); } } } } } |
