使用OPEN XML SDK Tool花费很长时间来生成Excel文件 [英] Takes long time to generate Excel file using OPEN XML SDK Tool

问题描述

你好
我已经使用OPEN XML SDK Tool 2.0开发了一个可生成Excel文件的应用程序.我有100000行和30列的数据表，我想用这100000行和30列来生成Excel文件，但是生成Excel文件大约需要2分钟的时间.我该怎么做才能减少这段时间.
请帮帮我.

在此先感谢
mohit

Hello
i have developed an application using OPEN XML SDK Tool 2.0 which generates Excel file. I have Data table of 100000 row and 30 columns and i want to generate excel file with these 100000 rows and 30 columns but it takes about 2 minutes of time to generate excel file. What can i do to reduce this time.
please help me.

thanks in advance
mohit

推荐答案

实际上，考虑到记录和字段的数量以及需要执行的操作，这似乎是一个合理的时间.

但是，问题中没有足够的信息可以全面回答.

例如，是否有任何数据字段复杂的计算，是否存在奇怪的格式化问题?

显示代码和示例.



如果您将数据加载给我们，答案将更加有用，并且会更加有用.

Actually, given the number of records and fields, and what needs to be done, that seems about a reasonable amount of time.

However, there is not enough information in the question to be able to answer it comprehensively.

Are any of the data fields complex calculations for example, are there odd formatting issues?

Show the code and an example.



An answer will be more forthcoming and will be more helpful if you load us with data.

这篇关于使用OPEN XML SDK Tool花费很长时间来生成Excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！