C# EXCEL分组Range.Rows.Group()，Aspose Cells如何快速实现数据分组

string fileName = AppDomain.CurrentDomain.BaseDirectory + "1.xls";
            Excel.Application xApp = new Excel.ApplicationClass();
            xApp.Visible = false;
            xApp.AlertBeforeOverwriting = false;//覆盖不弹窗
            xApp.DisplayAlerts = false;
            Excel.Workbook xBook = xApp.Workbooks._Open(fileName,
            Missing.Value, Missing.Value, Missing.Value, Missing.Value
            , Missing.Value, Missing.Value, Missing.Value, Missing.Value
            , Missing.Value, Missing.Value, Missing.Value, Missing.Value);
            Excel.Worksheet xSheet = (Excel.Worksheet)xBook.Sheets[1];
           //关键代码
            Range range = xSheet.get_Range(xSheet.Cells[4, 1], xSheet.Cells[7, 1]);
            range.Rows.Select();
           range.Rows.Group(Type.Missing, Type.Missing, Type.Missing, Type.Missing);
           xSheet.SaveAs(AppDomain.CurrentDomain.BaseDirectory + "2.xls",  //保存路径也可为上面打开的路径
                               Excel.XlFileFormat.xlExcel7,  //指定保存格式
                               Missing.Value,
                               Missing.Value,
                               Missing.Value,
                               Missing.Value,
                               Excel.XlSaveAsAccessMode.xlShared,
                               Missing.Value, Missing.
                               Value, Missing.Value); 
            //关闭Excel            
            xSheet = null;
            xBook = null;
            xApp.Quit(); //这一句是非常重要的，否则Excel对象不能从内存中退出
            xApp = null;
            GC.Collect();
            System.GC.WaitForPendingFinalizers();

 Aspose Cells是一款Excel文档处理控件，可以对Excel文件进行创建、处理、转换和各种操作，几乎可以实现Microsoft Excel一样的功能，在Excel里可以在数据区域范围外创建数据分组，当用户点击分组按钮时可以进行分组和显示。Aspose Cells提供一个类Workbook，里面包含了一系列函数和方法，GroupRows 和 GroupColumns 方法就是用于进行分组。

 

 

下面的事例简单介绍了分组行和列：
//Creating a file stream containing the Excel file to be opened
FileStream fstream = new FileStream("C:\\book1.xls", FileMode.Open);

//Instantiating a Workbook object
//Opening the Excel file through the file stream
Workbook workbook = new Workbook(fstream);

//Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

//Grouping first six rows (from 0 to 5) and making them hidden by passing true
worksheet.Cells.GroupRows(0, 5, true);

//Grouping first three columns (from 0 to 2) and making them hidden by passing true
worksheet.Cells.GroupColumns(0, 2, true);

//Saving the modified Excel file
workbook.Save("C:\\output.xls");

//Closing the file stream to free all resources
fstream.Close();

同样地可以控制是否统计行是否显示
worksheet.Outline.SummaryRowBelow = false;
worksheet.Outline.SummaryColumnRight = false;