本文整理汇总了C#中Workbook.Add方法的典型用法代码示例。如果您正苦于以下问题：C# Workbook.Add方法的具体用法？C# Workbook.Add怎么用？C# Workbook.Add使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Workbook的用法示例。
在下文中一共展示了Workbook.Add方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Main
static void Main(string[] args)
{
var wb = new Workbook();
wb.Title = "Workbook Title";
wb.Author = "The Author";
var sheet = new Worksheet("Test");
sheet.PageSetup.Orientation = Orientation.Landscape;
sheet.PageSetup.PrintRepeatRows = 2;
sheet.PageSetup.PrintRepeatColumns = 2;
sheet.ColumnWidths[0] = 24.6;
sheet.Cells["A1"] = "Test";
sheet.Cells["A1"].FontName = "Arial Black";
sheet.Cells[0, 1] = "Another Test";
sheet.Cells[0, 1].Border = CellBorder.Bottom | CellBorder.Right;
sheet.Cells[0, 2] = "Bold Red";
sheet.Cells[0, 2].Bold = true;
sheet.Cells[0, 2].TextColor = Color.Red;
Cell cell = "BIU Big Blue";
cell.Bold = true;
cell.Underline = true;
cell.Italic = true;
cell.TextColor = Color.Blue;
cell.FontSize = 18;
cell.Hyperlink = "https://github.com/mstum/Simplexcel";
sheet.Cells[0, 3] = cell;
sheet.ColumnWidths[3] = 40;
sheet.Cells[0, 4] = 13;
sheet.Cells[0, 5] = 13.58;
for (int i = 1; i < 55; i++)
{
sheet.Cells[1,i] = Guid.NewGuid().ToString("N");
sheet.Cells[i,0] = Guid.NewGuid().ToString("N");
}
Cell cell2 = "Orange";
cell2.Bold = true;
cell2.Italic = true;
cell2.TextColor = Color.Orange;
cell2.FontSize = 18;
sheet.Cells[0, 2] = cell2;
wb.Add(sheet);
wb.Save(@"testCompressed.xlsx", CompressionLevel.Maximum);
wb.Save(@"testUncompressed.xlsx", CompressionLevel.NoCompression);
}