This project has moved. For the latest updates, please go here.

Performance Issue in AddShape

May 10, 2013 at 7:15 PM

i need to create a report which will have 3 three shape in each page. and there will be more than 1000 page in that report. it was running fine with less data <10 page. But now i am having big performance issue as data size increases. Any help will be greatly appreciated.
Here is the code snippet for adding shape.

ExcelShape shape1 = sheet.Drawings.AddShape("txt" + rowNo, eShapeStyle.RoundRect);
                            shape1.Border.Fill.Color = System.Drawing.Color.Black;

                            shape1.Fill.Color = System.Drawing.Color.White;
                            shape1.SetPosition(rowNo + 1, 0, 21, 0);
                            shape1.SetSize(320, 59);