public void ShouldCreateSchemaSuccess()
{
var tempExcelFile = Path.Combine(System.IO.Path.GetTempPath(),
$"{Path.GetRandomFileName()}");
var writer = new NpoiExcelWriter();
var schema = new Dictionary <string, ColumnInfo[]>
{
["Sheet1"] = new[] {
new ColumnInfo {
DisplayName = "Column1"
},
new ColumnInfo {
DisplayName = "Column2"
}
}
};
writer.CreateSchemas(tempExcelFile, schema);
System.Console.WriteLine(tempExcelFile);
}
public void ShouldWriteDataSuccess()
{
var tempExcelFile = Path.Combine(System.IO.Path.GetTempPath(),
$"{Path.GetRandomFileName()}.xls");
var writer = new NpoiExcelWriter();
var schema = new Dictionary <string, ColumnInfo[]>
{
["Sheet1"] = new[] {
new ColumnInfo {
DisplayName = "Column1"
},
new ColumnInfo {
DisplayName = "Column2"
}
}
};
writer.CreateSchemas(tempExcelFile, schema);
writer.AppendData(tempExcelFile, new Dictionary <string, object[][]>
{
["Sheet1"] = new object[][]
{
new object[] { "a1", "a2" },
new object[] { "a3", "a4" }
}
});
writer.AppendData(tempExcelFile, new Dictionary <string, object[][]>
{
["Sheet1"] = new object[][]
{
new object[] { "b1", "b2" },
new object[] { "b3", "b4" }
}
});
System.Console.WriteLine(tempExcelFile);
}
