Range.Group Method - group rows, not columns
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? |
Range.Group Method - group rows, not columns
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 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? |
All times are GMT +1. The time now is 04:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com