Prev: Microsoft Map is no longer supported with Microsoft Office Excel
Next: code to extract data from a website runs of XP but not Vista
From: serhio on 7 May 2008 07:29
Hello,
I use the

Range.Group Method
_______________
When the Range object represents a single cell in a PivotTable field’s
data range, the Group method performs numeric or date-based grouping
in that field.

Namespace: Microsoft.Office.Interop.Excel
______________

after performing the groupment, I noticed that the groupment was in
columns, not in rows, as I expected. how can I group in rows? is there
a option to group rows or columns?
From: serhio on 7 May 2008 08:26
The code is in C#, i - an

for(int i = upperLine, i < lowerLine, i++)
{
currentCell = worksheet.get_Range(string.Format("A{0}", i),
Missing.Value);
currentCell.Group(Missing.Value, Missing.Value, Missing.Value,
Missing.Value);
}



thanks
On May 7, 2:29 pm, serhio <gser...(a)gmail.com> wrote:
> Hello,
> I use the
>
> Range.Group Method
> _______________
> When the Range object represents a single cell in a PivotTable field’s
> data range, the Group method performs numeric or date-based grouping
> in that field.
>
> Namespace: Microsoft.Office.Interop.Excel
> ______________
>
> after performing the groupment, I noticed that the groupment was in
> columns, not in rows, as I expected. how can I group in rows? is there
> a option to group rows or columns?

 | 
Pages: 1
Prev: Microsoft Map is no longer supported with Microsoft Office Excel
Next: code to extract data from a website runs of XP but not Vista