MiniExcel
MiniExcel copied to clipboard
SaveAsByTemplate will change template style after exporting


void Main()
{
var manager = new DataTable();
{
manager.Columns.Add("GMS_ERRFLAG");
manager.Columns.Add("GMS_ERRINFO");
manager.Columns.Add("Pn_Type");
manager.Rows.Add("Pn_Type","GMS_ERRINFO","Pn_Type");
}
var value = new Dictionary<string, object>()
{
["GMS"] = manager,
};
var memoryStream = new MemoryStream();
memoryStream.SaveAsByTemplate(templatPath, value);
var newFilePath = Path.GetTempPath() + Guid.NewGuid() + ".xlsx";
using (var fileStream = File.Create(newFilePath))
{
memoryStream.WriteTo(fileStream);
}
Console.WriteLine(newFilePath);
}