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

Modify Table Range

Feb 26, 2013 at 8:09 PM
Is there a way to modify the range of an existing table rather than use the InsertRowsBelow method to expand it? I've noticed that InsertRowsBelow is incredibly slow for some reason.

There is nothing complex to my code and it only runs into problems when I add a line to insert rows below and only on that line. If I remove it then I can generate my excel doc quite quickly just those rows won't be part of the table. I'm opening an existing spreadsheet that has table already defined in it.
if (!string.IsNullOrEmpty(outputPath))
            {
                using (XLWorkbook workbook = new XLWorkbook(outputPath))
                {
                    IXLWorksheet sheet = workbook.Worksheet("Sheet1");

                    IXLTable table = sheet.Table("BlueTable");

                    table.InsertRowsBelow(10);
That's the code before hand, output path is simply a path string to the existing xlsx file.