This project is read-only.

Create *.xlsx file is too slow

Nov 28, 2012 at 1:21 AM
Edited Nov 28, 2012 at 2:51 AM

Now I try to create a 2007 Excel file with NPOI 2.0,but it's too slow. If I create 2003 xls file,it takes 10s,but when I create 2007 xlsx file ,it takes about 3min.

How can I improve my speed?

My system is Win7 U 64Bit, VS2010, net 4.0

I need some help.

Thank you! 

Nov 28, 2012 at 5:17 PM

This is a known issue. We will try to improve somewhat in the final release of NPOI 2.0. However, the root cause may be the xml serialization in .NET using XmlSerializer. We are looking for alternative solutions for this. In java, POI use XmlBean, which is more efficient than .NET Xml.

Nov 29, 2012 at 12:26 AM
tonyqus wrote:

This is a known issue. We will try to improve somewhat in the final release of NPOI 2.0. However, the root cause may be the xml serialization in .NET using XmlSerializer. We are looking for alternative solutions for this. In java, POI use XmlBean, which is more efficient than .NET Xml.

Thank U