We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Perfomance of XlsIO

Thread ID:

Created:

Updated:

Platform:

Replies:

80815 Apr 28,2009 10:22 AM Aug 30,2012 03:30 AM Windows Forms 5
loading
Tags: XlsIO
Alexey Levande
Asked On April 28, 2009 10:22 AM

Hello,

We look for .Net component to generate Excel's files from our project. We estimated the time of generating of big (about 50000 rows) plain reports using various components. The Syncfusion XlsIO illustrated the worst performance - more than 3 minutes (the best components performs the same export in 20 seconds). Perhaps we used the XlsIO in wrong way. Could you please investigate what we do improper. Below I attach code of our testing application.

Thank in advance & sorry for my English

public void CreateReportUsingXlsIO()
{
Syncfusion.XlsIO.ExcelEngine excelEngine = new ExcelEngine();
Syncfusion.XlsIO.IApplication application = excelEngine.Excel;

Syncfusion.XlsIO.IWorkbook myWorkbook = excelEngine.Excel.Workbooks.Add();

for (int r = 1; r < 50000; r++)
for (int c = 1; c < 100; c++)
myWorkbook.ActiveSheet[r, c].Value2 = Rnd.Next();

myWorkbook.SaveAs(Path.Combine(DestFilename, "XlsIO_performance_" + ThreadId.ToString() + ".xls"), ExcelSaveType.SaveAsXLS);
excelEngine.ThrowNotSavedOnDestroy = false;
}




Geetha M [Syncfusion]
Replied On April 29, 2009 05:30 AM

Hi Alexey,

Thank you for your interest in Syncfusion products.

I strongly recommend you to go through the our documentation on "Improving Performance" in the link below:

http://help.syncfusion.com/ug_72/xlsio/ImprovingPerformance.html

Also, with v7.2.0.20, I could see that it took 1:40 minute to generated 50000 X 100 data. After changing the code as per the suggestion in our documentation, sheet.SetNumber(r, c, rnd.Next()); it took 40 seconds to generated the same number of data.

Could you please try this and let me know about it?

Regards,
Geetha


Alexey Levande
Replied On April 30, 2009 04:31 AM

Hello,

Thank you for your help, we will re-engineer obligatory our application as you proposed.

Regards, Alexey


Sridhar [Syncfusion]
Replied On August 30, 2012 02:24 AM

Hi Alexey Levande,

We are sorry for the delay in getting back to you.

Please let us know whether the above reproted issue is solved at your end and let us know if you require any further clarifications.

Thanks,

Sridhar.S


Manikandan M [Syncfusion]
Replied On August 30, 2012 03:27 AM

 Hi Casper,

We are sorry for the delay in getting back to you.

We have provided the link for online documentation of template marker below.

 http://help.syncfusion.com/UG/Reporting/XlsIO/ASP.NET/default.htm#!documents/templatemarkers.htm


Thanks for your patience. Kindly let me know if you have any questions.

 

Regards,

Manikandan.M


Manikandan M [Syncfusion]
Replied On August 30, 2012 03:30 AM

Hi Alexey,

 

Please ignore my previous update. Please let us know if you need any clarifications.

 

Regards,

Manikandan.M


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;