Range.Group() method fails after 7 calls
Hello,
I have a problem with Microsoft.Office.Interop.Excel.Range.Group() method. The problem is that I can apply this method only 7 times, before it throws me an exception. I don't understand quite well why this happens, and for witch documents this affirmation is valid, but the problem exists, probably, for a large files. For example, if you save this file - http://serhio.atspace.com/ExcelData.xls on the drive C, and executes the following code: static void Main(string[] args) { Microsoft.Office.Interop.Excel.Application excelApp = new ApplicationClass(); excelApp.Visible = true; // Makes Excel visible to the user. string workbookPath = @"C:\ExcelData.xls"; // Add your own path here // The following code opens an existing workbook Workbook excelWorkbook = excelApp.Workbooks.Open(workbookPath, 0, false, 5, "", "", false, XlPlatform.xlWindows, "", true, false, 0, true, false, false); // The following gets the Worksheets collection Worksheet worksheet = excelWorkbook.Worksheets.get_Item(1) as Worksheet; worksheet.Outline.SummaryRow = XlSummaryRow.xlSummaryAbove; Range aRange; int groupCounter = 0; try { for (int i = 10; i < 450; i = i + 11) { aRange = worksheet.get_Range(string.Format("C{0}:C{1}", i, i + 10), Missing.Value); aRange.Group(Missing.Value, Missing.Value, Missing.Value, Missing.Value); groupCounter++; } } catch (Exception ex) { throw ex; } } Is there somebody qho can explain this behavior, and how can I resolve this issue? Thanks a lot /sergiu |
All times are GMT +1. The time now is 06:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com