Aspose.Cells生成的Excel表格有没有一种方法可以不调用Workbook.Save()来格式化?
创始人
2024-09-20 11:00:52
0

可以使用Workbook.Settings属性来控制是否必须调用Workbook.Save()来保存对工作表的更改。

以下是示例代码:

// 加载工作簿 Workbook workbook = new Workbook("Book1.xlsx");

// 设置单元格格式 Worksheet worksheet = workbook.Worksheets[0]; Cells cells = worksheet.Cells; Style style = workbook.CreateStyle(); style.Number = 14; cells["A1"].SetStyle(style); cells["B1"].SetStyle(style);

// 设置工作表设置 workbook.Settings.AutoRecoverEnabled = false; workbook.Settings.MemorySetting = MemorySetting.MemoryPreference; workbook.Settings.EnableMultiThreadedCalculation = true;

// 将更改保存到内存而不保存到磁盘 workbook.SaveOptions.MemorySetting = MemorySetting.MemoryPreference; workbook.SaveOptions.CheckFontCompatibility = false; workbook.SaveOptions.ClearData = false; workbook.SaveOptions.SaveFormat = SaveFormat.Xlsx; workbook.SaveOptions.RefreshChartCache = false; workbook.SaveOptions.ValidateMergedAreas = true; workbook.SaveOptions.LightCellsDataProvider = new LightCellsDataProvider();

// 获取内存中的输出文件流 MemoryStream stream = new MemoryStream(); workbook.Save(stream, SaveFormat.Xlsx);

// 将输出流转换为字节数组 byte[] bytes = stream.ToArray();

// 使用字节数组来生成Excel文档 Response.Clear(); Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("Content-Disposition", "attachment;filename=Book1.xlsx"); Response.BinaryWrite(bytes); Response.End();

相关内容

热门资讯

透视美元局!哈糖大菠萝怎么挂,... 透视美元局!哈糖大菠萝怎么挂,哈糖大菠萝攻略,2025教程(有挂辅助);哈糖大菠萝怎么挂辅助器中分为...
透视中牌率!wejoker辅助... 透视中牌率!wejoker辅助器要钱玩吗,起初是有挂(透视)新2025版(有挂教程)1、wejoke...
透视安卓版!德州透视是真的假的... 透视安卓版!德州透视是真的假的,pokemmo手机版修改器,2025新版(有挂脚本);1、许多玩家不...
透视好友房!wepoker辅助... 透视好友房!wepoker辅助真的假的,起初是有挂(透视)透牌教程(有挂详情);wepoker辅助真...
透视好友房!uupoker有透... 透视好友房!uupoker有透视吗,pokernow辅助控制,玩家教你(有挂黑科技);1、不需要AI...
透视辅助!aapoker透视脚... 透视辅助!aapoker透视脚本下载,总是有挂(透视)技巧教程(有挂攻略);在进入aapoker透视...
透视中牌率!pokemmo脚本... 透视中牌率!pokemmo脚本辅助器下载,佛手在线大菠萝智能辅助器,黑科技教程(有挂介绍);1)佛手...
透视软件!hhpoker怎么破... 透视软件!hhpoker怎么破解,先前真的有挂(透视)总结教程(有挂细节)1、上手简单,内置详细流程...
透视肯定!聚星ai辅助工具激活... 透视肯定!聚星ai辅助工具激活码,哈糖大菠萝攻略,必赢方法(有挂揭秘)一、聚星ai辅助工具激活码AI...
透视美元局!xpoker透视辅... 透视美元局!xpoker透视辅助,原来有挂(透视)科技教程(有挂细节)1、下载好xpoker透视辅助...