Here''s my code if that helps:
// Create Excel automation objects
IWorkbook myWorkBook = ExcelUtils.CreateWorkbook(1);
IWorksheet sheet = myWorkBook.Worksheets[0];
Syncfusion.GroupingGridExcelConverter.GroupingGridExcelConverterControl ggecc = new GroupingGridExcelConverterControl();
ggecc.GroupingGridToExcel(this, sheet, Syncfusion.GridExcelConverter.ConverterOptions.ConvertVisible);
// Save the workbook to disk so we can launch it via the file system
myWorkBook.SaveAs(path);
myWorkBook.Close();
ExcelUtils.ThrowNotSavedOnDestroy = false;
if (openFile)
{
// Launch the saved workbook
Process proc = new Process();
proc.StartInfo.FileName = path;
proc.Start();
}
>Instead of setting each column header to a single column in excel, an entry is made:
>GridColumnHeaderRow(GridColumnHeaderSection): <
>
>
>It would be more helpful for me to have either the column headers in individual columns, or to exclude them all together
>
>Any ideas?