Range.Group() method fails after 7 calls

S

serhio

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top