public void Sample2()
{
var wb = new WorkbookDfn
{
Worksheets = new[]
{
new WorksheetDfn
{
Name = "MyFirstSheet",
ColumnHeadings = new[]
{
new CellDfn
{
Value = "DataType",
Bold = true,
},
new CellDfn
{
Value = "Value",
Bold = true,
HorizontalCellAlignment = HorizontalCellAlignment.Right,
},
},
Rows = new[]
{
new RowDfn
{
Cells = new[]
{
new CellDfn {
CellDataType = CellDataType.String,
Value = "Boolean",
},
new CellDfn {
CellDataType = CellDataType.Boolean,
Value = true,
},
}
},
new RowDfn
{
Cells = new[]
{
new CellDfn {
CellDataType = CellDataType.String,
Value = "Boolean",
},
new CellDfn {
CellDataType = CellDataType.Boolean,
Value = false,
},
}
},
new RowDfn
{
Cells = new[]
{
new CellDfn {
CellDataType = CellDataType.String,
Value = "String",
},
new CellDfn {
CellDataType = CellDataType.String,
Value = "A String",
HorizontalCellAlignment = HorizontalCellAlignment.Right,
},
}
},
new RowDfn
{
Cells = new[]
{
new CellDfn {
CellDataType = CellDataType.String,
Value = "int",
},
new CellDfn {
CellDataType = CellDataType.Number,
Value = (int)100,
},
}
},
new RowDfn
{
Cells = new[]
{
new CellDfn {
CellDataType = CellDataType.String,
Value = "int?",
},
new CellDfn {
CellDataType = CellDataType.Number,
Value = (int?)100,
},
}
},
new RowDfn
{
Cells = new[]
{
new CellDfn {
CellDataType = CellDataType.String,
Value = "int? (is null)",
},
new CellDfn {
CellDataType = CellDataType.Number,
Value = null,
},
}
},
new RowDfn
{
Cells = new[]
{
new CellDfn {
CellDataType = CellDataType.String,
Value = "uint",
},
new CellDfn {
CellDataType = CellDataType.Number,
Value = (uint)101,
},
}
},
new RowDfn
{
Cells = new[]
{
new CellDfn {
CellDataType = CellDataType.String,
Value = "long",
},
new CellDfn {
CellDataType = CellDataType.Number,
Value = Int64.MaxValue,
},
}
},
new RowDfn
{
Cells = new[]
{
new CellDfn {
CellDataType = CellDataType.String,
Value = "float",
},
new CellDfn {
CellDataType = CellDataType.Number,
Value = (float)123.45,
},
}
},
new RowDfn
{
Cells = new[]
{
new CellDfn {
CellDataType = CellDataType.String,
Value = "double",
},
new CellDfn {
CellDataType = CellDataType.Number,
Value = (double)123.45,
},
}
},
new RowDfn
{
Cells = new[]
{
new CellDfn {
CellDataType = CellDataType.String,
Value = "decimal",
},
new CellDfn {
CellDataType = CellDataType.Number,
Value = (decimal)123.45,
},
}
},
new RowDfn
{
Cells = new[]
{
new CellDfn {
CellDataType = CellDataType.Date,
Value = new DateTime(2012, 1, 8),
FormatCode = "mm-dd-yy",
},
new CellDfn {
CellDataType = CellDataType.Date,
Value = new DateTime(2012, 1, 9),
FormatCode = "mm-dd-yy",
Bold = true,
HorizontalCellAlignment = HorizontalCellAlignment.Center,
},
}
},
}
}
}
};
var fileName = Path.Combine(TempDir, "Sw_Example2.xlsx");
using var stream = File.Open(fileName, FileMode.OpenOrCreate);
wb.WriteTo(stream);
}
public void Sample1()
{
var wb = new WorkbookDfn
{
Worksheets = new[]
{
new WorksheetDfn
{
Name = "MyFirstSheet",
TableName = "NamesAndRates",
ColumnHeadings = new[]
{
new CellDfn
{
Value = "Name",
Bold = true,
},
new CellDfn
{
Value = "Age",
Bold = true,
HorizontalCellAlignment = HorizontalCellAlignment.Left,
},
new CellDfn
{
Value = "Rate",
Bold = true,
HorizontalCellAlignment = HorizontalCellAlignment.Left,
}
},
Rows = new[]
{
new RowDfn
{
Cells = new[]
{
new CellDfn {
CellDataType = CellDataType.String,
Value = "Eric",
},
new CellDfn {
CellDataType = CellDataType.Number,
Value = 50,
},
new CellDfn {
CellDataType = CellDataType.Number,
Value = (decimal)45.00,
FormatCode = "0.00",
},
}
},
new RowDfn
{
Cells = new[]
{
new CellDfn {
CellDataType = CellDataType.String,
Value = "Bob",
},
new CellDfn {
CellDataType = CellDataType.Number,
Value = 42,
},
new CellDfn {
CellDataType = CellDataType.Number,
Value = (decimal)78.00,
FormatCode = "0.00",
},
}
},
}
}
}
};
var fileName = Path.Combine(TempDir, "Sw_Example1.xlsx");
using var stream = File.Open(fileName, FileMode.OpenOrCreate);
wb.WriteTo(stream);
}
