讀寫.docx和.xlsx文檔的C#類 - Simple OOXML

Simple OOXML 是 CodePlex 上的一個開源項目，使用Open Xml SDK 2.0 ，封裝了一系列讀寫.docx和.xlsx文檔的類，可以很大程度上簡化工作。
它提供以下這些類：

• SpreadsheetReader - manipulation of templates, retrieval of document parts, row and column reference functionality
• SpreadsheetWriter - writing of document parts and creation of document level attributes. Add or remove spreadsheets.
• SpreadsheetStyle - encapsulates font, border and fill handing in a spreadsheet.
• WoksheetReader - retrieves cell and style information from a worksheet
• WorksheetWriter - allows the pasting or insertion of data and style - using simple value types or DataTables - at a cell or range reference.
• DocumentReader - retrieval of document templates.
• DocumentWriter - pastes and saves text and text lists using predefined bookmarks.

using (var stream = SpreadsheetReader.StreamFromFile("test.xlsx"))
{
    using (var doc = SpreadsheetDocument.Open(stream, true))
    {
        var sheet = SpreadsheetReader.GetWorksheetPartByName(doc, "Sheet1");
        var writer = new WorksheetWriter(doc, sheet);


    //獲取默認樣式
    var style1 = SpreadsheetStyle.GetDefault(doc);
    style1.SetBackgroundColor("97DDFF");//設置背景顏色
    style1.SetHorizontalAlignment(HorizontalAlignmentValues.Center);//設置水平居中對齊
    style1.SetBorder("000000", BorderStyleValues.Thin);//設置邊框
    var data = new[] {
        new {Name = "小鄭",Sex = "男",Age = 20},
        new {Name = "小王",Sex = "女",Age = 19}
    };

    int rowIndex = 2;
    for (int i = 0; i < data.Length; i++)
    {
        writer.PasteText("A" + rowIndex, data[i].Name, style1);//寫入姓名
        writer.PasteText("B" + rowIndex, data[i].Sex, style1);//寫入性別
        writer.PasteNumber("C" + rowIndex, data[i].Age.ToString(), style1);//寫入年齡
        rowIndex++;
    }
    writer.Save();//在內存中保存文檔結構
    SpreadsheetWriter.StreamToFile("test.xlsx", stream);//保存到文件中
}

}</pre> 
  
項目主頁：http://www.baiduhome.net/lib/view/home/1326936587577