AD
Administrator
Syncfusion Team
November 6, 2006 07:14 AM UTC
Hi Edmond ,
If all you want to do is copy and paste the text (including headers) from the grid into Excel, then try setting this property.
this.gridDataBoundGrid1.Model.CutPaste.ClipboardFlags |= GridDragDropFlags.ColHeader;
Then when you click on cell 0,0, and paste into Excel, the column headers should also be included.
If you actually want to export an XLS file, then take a look at the sample Essential Studio\4.3.0.30\Windows\Grid.Windows\Samples\Quick Start\Excel Export which shows how this can be done.
Please let us know if you have further questions on this matter.
Best Regards,
Haneef
EL
Edmond Lee
November 7, 2006 09:13 AM UTC
That's exactly what I wanted to do. Thanks.
Edmond Lee
AS
Ashok
May 10, 2007 11:57 PM UTC
I want this feature in Syncfusion.Grid.Grouping.Windows not in "gridDataBoundGrid1"
>Hi Edmond ,
If all you want to do is copy and paste the text (including headers) from the grid into Excel, then try setting this property.
this.gridDataBoundGrid1.Model.CutPaste.ClipboardFlags |= GridDragDropFlags.ColHeader;
Then when you click on cell 0,0, and paste into Excel, the column headers should also be included.
If you actually want to export an XLS file, then take a look at the sample Essential Studio\4.3.0.30\Windows\Grid.Windows\Samples\Quick Start\Excel Export which shows how this can be done.
Please let us know if you have further questions on this matter.
Best Regards,
Haneef
AS
Ashok
May 10, 2007 11:57 PM UTC
I want this feature in Syncfusion.Grid.Grouping.Windows not in "gridDataBoundGrid1"
>
I want this feature in Syncfusion.Grid.Grouping.Windows not in "gridDataBoundGrid1"
>Hi Edmond ,
If all you want to do is copy and paste the text (including headers) from the grid into Excel, then try setting this property.
this.gridDataBoundGrid1.Model.CutPaste.ClipboardFlags |= GridDragDropFlags.ColHeader;
Then when you click on cell 0,0, and paste into Excel, the column headers should also be included.
If you actually want to export an XLS file, then take a look at the sample Essential Studio\4.3.0.30\Windows\Grid.Windows\Samples\Quick Start\Excel Export which shows how this can be done.
Please let us know if you have further questions on this matter.
Best Regards,
Haneef
AS
Ashok
May 11, 2007 12:34 AM UTC
Thanks Haneef my problem solved
>Hi Edmond ,
If all you want to do is copy and paste the text (including headers) from the grid into Excel, then try setting this property.
this.gridDataBoundGrid1.Model.CutPaste.ClipboardFlags |= GridDragDropFlags.ColHeader;
Then when you click on cell 0,0, and paste into Excel, the column headers should also be included.
If you actually want to export an XLS file, then take a look at the sample Essential Studio\4.3.0.30\Windows\Grid.Windows\Samples\Quick Start\Excel Export which shows how this can be done.
Please let us know if you have further questions on this matter.
Best Regards,
Haneef