using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.IO;

#region NPOI

using NPOI.HSSF.UserModel;

using NPOI.HPSF;

using NPOI.POIFS.FileSystem;

#endregion NPOI

namespace WinFormNPOI

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

        private void btnNPOI_Click(object sender, EventArgs e)

        {

            // 建立新的 Excel 工作簿

            HSSFWorkbook hssfworkbook = new HSSFWorkbook();

            // 在 Excel 工作簿中建立工作表，名稱為 Sheet1

            HSSFSheet sheet1 = hssfworkbook.CreateSheet("Sheet1");

            // 寫入資料到工作表中

            sheet1.CreateRow().CreateCell().SetCellValue("點部落");

            sheet1.CreateRow().CreateCell().SetCellValue("小歐ou");

            // 儲存檔案

            FileStream file = new FileStream(@"C:\NPOI.xls", FileMode.Create);

            hssfworkbook.Write(file);

            file.Close();

        }

    }

}

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

#region OpenXML SDK

using DocumentFormat.OpenXml.Packaging;

using DocumentFormat.OpenXml.Spreadsheet;

using DocumentFormat.OpenXml;

#endregion OpenXML SDK

namespace WinFormOpenXML

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

        private void btnOpenXML_Click(object sender, EventArgs e)

        {

            // 1. 開啟 Excel 檔案，取得工作簿

            using (SpreadsheetDocument document = SpreadsheetDocument.Open(@"C:\OpenXML.xlsx", true))

            {

                WorkbookPart wbPart = document.WorkbookPart;

                // 2. 取得工作簿中的工作表，並透過 Linq 判斷工作表是否存在

                Sheet theSheet = wbPart.Workbook.Descendants<Sheet>().

                  Where(s => s.Name == "工作表1").FirstOrDefault();

                if (theSheet != null)

                {

                    // 3. 建立 Cell 物件，設定寫入位置，格式，資料

                    Cell cell = new Cell() { CellReference = "A1" };

                    cell.DataType = new EnumValue<CellValues>(CellValues.String);

                    cell.CellValue = new CellValue();

                    cell.CellValue.Text = "點部落";

                    // 4. 建立 Row 物件，將 Cell 加入

                    Row theRow = new Row();

                    theRow.InsertAt(cell, );

                    // 5. 將 Row 加入工作表中

                    Worksheet ws = ((WorksheetPart)(wbPart.GetPartById(theSheet.Id))).Worksheet;

                    SheetData sheetData = ws.GetFirstChild<SheetData>();

                    sheetData.Append(theRow);

                    // 6. 儲存檔案

                    ws.Save();

                }

            }

        }

    }

}

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

#region OpenOffice.org SDK

using unoidl.com.sun.star.lang;

using unoidl.com.sun.star.bridge;

using unoidl.com.sun.star.frame;

using unoidl.com.sun.star.view;

using unoidl.com.sun.star.beans;

using unoidl.com.sun.star.text;

using unoidl.com.sun.star.style;

using unoidl.com.sun.star.container;

#endregion  OpenOffice.org SDK

namespace WinFormOpenOffice

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

        private void btnOpenOffice_Click(object sender, EventArgs e)

        {

            #region 元件初始化

            string sFileName = "C:\\OpenOffice.xlsx";

            unoidl.com.sun.star.uno.XComponentContext m_xContext;

            unoidl.com.sun.star.lang.XMultiServiceFactory mxMSFactory;

            unoidl.com.sun.star.sheet.XSpreadsheetDocument mxDocument;

            unoidl.com.sun.star.container.XIndexAccess xSheetsIA;

            unoidl.com.sun.star.sheet.XSpreadsheets xSheets;

            unoidl.com.sun.star.sheet.XSpreadsheet xSheet;

            // OpenOffice.org 使用網址的方式，因此必須先將檔案路徑做轉換

            String sUrl = "file:///" + sFileName.Replace(@"\", "/");

            // 載入文件前屬性設定，設定文件開啟時隱藏

            PropertyValue[] loadDesc = new PropertyValue[];

            loadDesc[] = new PropertyValue();

            loadDesc[].Name = "Hidden";

            loadDesc[].Value = new uno.Any(true);

            m_xContext = uno.util.Bootstrap.bootstrap();

            mxMSFactory = (XMultiServiceFactory)m_xContext.getServiceManager();

            XComponentLoader aLoader = (XComponentLoader)mxMSFactory.createInstance("com.sun.star.frame.Desktop");

            // 載入文件

            XComponent xComp = aLoader.loadComponentFromURL(sUrl, "_blank", , loadDesc);

            mxDocument = (unoidl.com.sun.star.sheet.XSpreadsheetDocument)xComp;

            xSheets = mxDocument.getSheets();

            xSheetsIA = (unoidl.com.sun.star.container.XIndexAccess)xSheets;

            xSheet = (unoidl.com.sun.star.sheet.XSpreadsheet)xSheetsIA.getByIndex().Value;

            #endregion 元件初始化

            #region 寫入資料到 Excel

            xSheet.getCellByPosition(, ).setFormula("點部落");

            xSheet.getCellByPosition(, ).setFormula("小歐ou");

            #endregion 寫入資料到 Excel

            #region 列印 Excel

            PropertyValue[] printerProp = new PropertyValue[];

            printerProp[] = new PropertyValue();

            printerProp[].Name = "Hide";

            printerProp[].Value = new uno.Any(true);

            XPrintable xPrintable = (XPrintable)xComp;

            // 設定列印參數

            xPrintable.setPrinter(printerProp);

            printerProp = xPrintable.getPrinter();

            PropertyValue[] printOps = new PropertyValue[];

            int indexOps = ;

            int iCopyNum = ;  // 列印一份

            printOps[indexOps] = new PropertyValue();

            printOps[indexOps].Name = "CopyCount";

            printOps[indexOps].Value = new uno.Any(iCopyNum);

            xPrintable.print(printOps);

            xComp.dispose();

            #endregion 列印 Excel

        }

    }

}