關于讀取Excel模板對模板讀寫操作
1.根據檔案名稱(帶盤符的檔案目錄)，建立SLDocument物件
SLDocument sldocument = new SLDocument(filename); sldocument.SelectWorksheet("Sheet1");
2.讀取某一單元格的內容
string Astring = sldocument.GetCellValueAsString("A" + (3 + i * 4).ToString());
3.寫入某一單元格
sldocument.SetCellValue("A1", DateTime.Now.ToString("yyyy/MM/dd"));
4.設定某一單元格的樣式
SLStyle slstyle0 = new SLStyle(); slstyle0.Alignment.Horizontal = HorizontalAlignmentValues.Center; slstyle0.Alignment.Vertical = VerticalAlignmentValues.Center; sldocument.SetCellStyle("A1", slstyle0);
SLStyle sStyle1 = sldocument.CreateStyle(); sStyle1.Alignment.Horizontal = HorizontalAlignmentValues.Center; sStyle1.Alignment.Vertical = VerticalAlignmentValues.Center; sStyle1.Fill.SetPattern(PatternValues.Solid, System.Drawing.Color.FromArgb(147, 205, 221), System.Drawing.Color.Black); sldocument.SetCellStyle("A1", sStyle2);
5.保存檔案
sldocument.Save();
注：需參考SpreadsheetLight.dll
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/36084.html
標籤：C#
下一篇：不干膠、熱敏列印