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();

相关内容

热门资讯

透视线上(WEPOKER)we... 透视线上(WEPOKER)wepoker一直输的号能继续打吗(透视)本来真的是有挂(2025新版)一...
透视好友房(wpk透视插件)好... 透视好友房(wpk透视插件)好像是真的有挂(透视)插件(AA德州教程);1、起透看视 wpk透视插件...
透视辅助(WePoKer)we... 透视辅助(WePoKer)wepoker免费脚本咨询(透视)都是是有挂(扑克教程)wepoker免费...
透视肯定(wpk模拟器多开)竟... 透视肯定(wpk模拟器多开)竟然有挂(透视)俱乐部辅助器(AA德州教程)1、wpk模拟器多开透视辅助...
透视私人局(wpk作弊是真的吗... 透视私人局(wpk作弊是真的吗)确实是有挂(透视)透视工作室(力荐教程)1、操作简单,无需注册,只需...
透视app(WePoKer)w... 透视app(WePoKer)we poker插件(透视)竟然是真的有挂(高科技教程);1、we po...
透视科技(wpk透视怎么安装)... 透视科技(wpk透视怎么安装)一贯存在有挂(透视)透视是真的假的(透牌教程);1、构建自己的wpk透...
透视透视(WePoKer)we... 透视透视(WePoKer)wepoker透视脚本下载(透视)真是真的有挂(力荐教程);1、进入到we...
透视计算(wpk透视辅助方法)... 透视计算(wpk透视辅助方法)其实是有挂(透视)插件(线上教程)暗藏猫腻,小编详细说明wpk透视辅助...
透视软件(wepoker)we... 透视软件(wepoker)wepoker永久免费脚本(透视)都是真的是有挂(2025教程);一、we...