Grouping in Infragistics Excel

The below code shows how to group using Infragistics Excel

using System;
using System.Collections.Generic;
using System.Text;
using Infragistics.Excel;
namespace ConsoleApplication1{
class Program
{
static void Main(string[] args)
{
Workbook theWorkBook = new
Workbook();
Worksheet
theWorkSheet;
theWorkSheet =
theWorkBook.Worksheets.Add("Customers");
theWorkSheet.Rows[0].OutlineLevel =
0;
//the outline property is the key to Grouping
theWorkSheet.Rows[0].Cells[0].Value =
"hello";
theWorkSheet.Rows[1].OutlineLevel = 1;

theWorkSheet.Rows[1].Cells[0].Value =
"hello1";
theWorkSheet.Rows[2].OutlineLevel =
2;
theWorkSheet.Rows[2].Cells[0].Value =
"hello2";
theWorkSheet.Rows[2].Expanded =
false;
theWorkSheet.Rows[1].Expanded =
false;
BIFF8Writer.WriteWorkbookToFile(theWorkBook,
"C://file.xls");
}
}
}