Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find method fails in hidden range | Excel Programming | |||
select method of range class fails | Excel Programming | |||
Select method of Range fails | Excel Programming | |||
Copy method fails in IIS | Excel Programming | |||
Tracing method calls | Excel Programming |