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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

ExcelRW: setting border styles performance

Thread ID:





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


I have a problem with the performance of setting cell border styles while using ExcelRW v. 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?


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.


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 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.



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.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

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