MiniExcel
MiniExcel copied to clipboard
7. 创建多个工作表(Sheet),这个功能亲测不可用
- 创建多个工作表(Sheet) // 1. Dictionary<string,object> var users = new[] { new { Name = "Jack", Age = 25 }, new { Name = "Mike", Age = 44 } }; var department = new[] { new { ID = "01", Name = "HR" }, new { ID = "02", Name = "IT" } }; var sheets = new Dictionary<string, object> { ["users"] = users, ["department"] = department }; MiniExcel.SaveAs(path, sheets);
// 2. DataSet var sheets = new DataSet(); sheets.Add(UsersDataTable); sheets.Add(DepartmentDataTable); //.. MiniExcel.SaveAs(path, sheets);
以上是描述,我建立了一个demo,结果如图所示
根本不是写入多个sheet!!!!
发个demo谢谢
直接贴进C#就可以了 完全没得问题
The issue is not reproducible