XLSB：如何在.net中没有Interop格式化单元格 [英] XLSB : How to format cells without Interop in .net

问题描述

在我们的应用程序中，我们使用.net程序触发的SSIS作业同时生成多个XLSB文件。在将文件数据填充到XLSB文件之后，我们当前正在使用Interop格式化单元格，因为服务器无法一次创建超过15到20个实例，因此创建Excel实例
反过来会产生瓶颈问题。

In our application we have multiple XLSB files getting generated simultenously using SSIS jobs triggered by .net program. After the files data are populated into the XLSB file, we are currently formatting the cells using Interop which is creating Excel instance in-turn producing bottleneck issue as the server could not create more than 15 to 20 instances at a single time.

有人可以给我一个解决方案，例如使用.net格式化XLSB文件而不使用Interop和

without  Excel实例创建。

Can someone give me a solution with example to format XLSB file using .net without Interop and without  Excel instance creation.

推荐答案

如果您要创建.xlsx文件，我建议
SpreadSheetLight （免费），使用样式类进行样式设置，不需要安装Excel。

If you were creating .xlsx files I would recommend SpreadSheetLight (free) that does styling with a style class and does not need Excel installed.

Keepi使用免费库，您可以查看
EPPlus ，但没有使用它，但相信它值得一试。

Keeping with free libraries you can check out EPPlus, have not used it but believe it's worth checking out.

对于第三方库，有
GemBox SpreadSheet库，不需要Excel安装并使用样式类（类似于SpreadSheetLight库）来设置样式单元格。 GemBox有一个试用版，购买时只需使用序列号即可完全激活。

For a third party library there is GemBox SpreadSheet library which does not require Excel to be installed and uses style classes (similar to SpreadSheetLight library) to style cells. GemBox has a trial version which when purchased you simply use a serial number to fully activate.

还有 Aspose.Cells ，简而言之，类似于GemBox库，不需要Excel和使用样式。

There is also Aspose.Cells which in short is similar to GemBox library, no Excel needed and uses styles.

鉴于你的Excel格式，我先看Gembox，然后再看Aspose然后EPPlus 。为什么这个订单，因为付费产品更强大并且持续支持。我曾与Aspose和Gembox合作，并相信Gembox为整体
降压提供了最好的效果。

Given your Excel format I would look at Gembox first then Aspose then EPPlus. Why this order, because the paid products are more robust and have continued support. I've worked with both Aspose and Gembox and believe Gembox provides the best bang for the buck overall.

这篇关于XLSB：如何在.net中没有Interop格式化单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！