GrapeCity.Documents.Excel.IRange.RemoveSubtotal

RemoveSubtotal Method

RemoveSubtotal()

Removes subtotals from a list.

Declaration

void RemoveSubtotal()

Sub RemoveSubtotal()

Examples

worksheet.Range["A1:B4"].Value = new object[,] {{"Region", "Amount"}, {"East", 120}, {"East", 80}, {"West", 90}};
IRange range = worksheet.Range["A1:B4"];
range.Subtotal(1, ConsolidationFunction.Sum, new int[] {2});
range.RemoveSubtotal();
object value = worksheet.Range["A4"].Value;