Export Grid using GridExcelConverter

[Pankaj Minda]

how do i export grid to excel using the GridExcelConverter class?

[Administrator]

Hi Pankaj, Attached is a sample which shows how to export a grid using the GridExcelConverterControl class. Regards, Calvin.

CS6.zip

[Pankaj Minda]

Thanks for the sample.

1) Is there any option to turn off the Message Box being shown?

2) Text Alignment in covered cells is not proper, just add the following line to your sample to reproduce:

gridControl1.CoverredRanges.Add(GridRangeInfo.Cells(1,1,2,2))

Regards,
Pankaj

[stanleyj]

Hi Pankaj,

We will get these corrected, by setting the alignment for the grid cells there is proper alignment in the excel and that mismatch could be avoided.

gridControl1.CoveredRanges.Add(GridRangeInfo.Cells(1,1,2,2));
this.gridControl1.TableStyle.HorizontalAlignment = GridHorizontalAlignment.Left;
this.gridControl1.TableStyle.VerticalAlignment = GridVerticalAlignment.Top;

Thanks,
Stanley