This project has moved and is read-only. For the latest updates, please go here.

Performance about the border style setting

Mar 29, 2013 at 3:25 AM
My excel have about 500 rows and 2800 columns. When I set the border style using the code worksheet.Cells[1, 1, 500, 2800].Style.Border.Left.Style = ExcelBorderStyle.Thin,it takes half a hour to do it. Why setting the border style is so slow?