読み書き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);//
}
}