Hello There,
I use following function code to export GGC context to excel. It takes 20 seconds to export 3033 rows with 10 columns grid. Attached is exported excel result. Any idea to tune up the code to make it faster? Thanks.
public static void ExportToExcel(GridGroupingControl grid,string FileName)
{
IWorkbook myWorkBook = ExcelUtils.CreateWorkbook(1);
IWorksheet sheet = myWorkBook.Worksheets[0];
Hashtable colIndexMapping = new Hashtable();
int count = grid.TableModel.ColCount;
for (int i = 1; i < (count-1); i++)
{
GridColumnDescriptor cd = grid.Table.GetHeaderColumnDescriptorAt(i);
if (cd != null)
colIndexMapping[cd.Name] = i;
}
for (int i=0;i
Untitled2.zip
