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

ExcelRW: setting border styles performance

Thread ID:

Created:

Updated:

Platform:

Replies:

47613 Aug 9,2006 08:50 AM UTC Aug 17,2006 05:25 AM UTC Windows Forms 2
loading
Tags: XlsIO
Arek Sobiech
Asked On August 9, 2006 08:50 AM UTC

Hi,

I have a problem with the performance of setting cell border styles while using ExcelRW v.2.0.5.1. I''m setting style using the following code:

sheet.Range[1,1,sheet.Rows.Length,sheet.Columns.Length].CellStyle.Borders[ExcelBordersIndex.EdgeBottom].LineStyle = ExcelLineStyle.Thin;

sheet.Range[1,1,sheet.Rows.Length,sheet.Columns.Length].CellStyle.Borders[ExcelBordersIndex.EdgeLeft].LineStyle = ExcelLineStyle.Thin;

sheet.Range[1,1,sheet.Rows.Length,sheet.Columns.Length].CellStyle.Borders[ExcelBordersIndex.EdgeRight].LineStyle = ExcelLineStyle.Thin;

sheet.Range[1,1,sheet.Rows.Length,sheet.Columns.Length].CellStyle.Borders[ExcelBordersIndex.EdgeTop].LineStyle = ExcelLineStyle.Thin;

For a sheet with approx. 1000 rows and 15 cols, just this part of code takes more than 30 secs to execute, which is more than 50% of time consumed by the whole process of creating Excel spreadsheet.

Is there a way to optimize it?

Thanks,
Arek

Melba Winshia [Syncfusion]
Replied On August 10, 2006 02:39 PM UTC

Hi Arek,

We are looking into this issue. I will update you regarding this issue as soon as possible.

Regards,
Melba.

Melba Winshia [Syncfusion]
Replied On August 17, 2006 05:25 AM UTC

Hi Arek,

Sorry for the delay in responding. I just realized that you are using version 2.0.5.1. We have improved our performance in later versions. Would it be possible to upgrade to later versions since it is likely that this issue has already been addressed?

Please let me know if you have any other questions.

Regards,
Melba

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

;