/// <summary>
/// 读取Sheet中一行数据(如用来获取表头行)
/// </summary>
public static void ReadOneRow()
{
//sheetIndex为Sheet索引(从1开始)，rowLine为行号(从1开始)
var headers = LiteDataHelper.ReadOneRow(filePath: "用户数据.xlsx", sheetIndex: 1, rowLine: 1);
Console.WriteLine($"表头为：{string.Join(" ", headers)}");
}
/// <summary>
/// 非大批量数据便捷导出
/// </summary>
/// <returns></returns>
public IActionResult LiteDataExport()
{
//此方式对象全部在内存中，故数据量大的时候会占用内存，适合数据量不大使用；大数据量不占用内存的请采用上述的AppendData方式
var users = Enumerable.Range(1, ExportCount).Select(index => new UserExportDto {
Account = $"2021-{index}", Name = $"测试用户-{index}", IsMan = true, IsConfirm = true
}).ToList();
var excelInfo = LiteDataHelper.ExportToWebDown(users, fileName: "用户数据");
return(File(excelInfo.Stream, excelInfo.WebContentType, excelInfo.FileName));
}
/// <summary>
/// 非大批量数据便捷导出
/// </summary>
/// <returns></returns>
public IActionResult LiteDataExport()
{
var users = new List <UserExportDto>();
for (int i = 1; i <= ExportCount; i++)
{
users.Add(new UserExportDto {
Account = $"2020-{i}", Name = $"测试用户-{i}"
});
}
var excelInfo = LiteDataHelper.ExportToWebDown(users, fileName: $"用户数据-{DateTime.Now.ToString("yyyyMMddHHmm")}");
return(File(excelInfo.Stream, excelInfo.WebContentType, excelInfo.FileName));
}