Export To Grid using ExcelRW . .

[Adam K.]

Is there any quicker way of exporting the current grid with all of its formatting etc to excel rather than having to copy over the entire grid model, cell by cell and line by line and setting the style of each cell like this below ..

style.FillBackground = ExcelKnownColors.Grey_25_percent;
style.Borders[ExcelBordersIndex.EdgeBottom].LineStyle = ExcelLineStyle.Thin;
style.Font.Color = ExcelKnownColors.Black;
style.Font.Bold = true;

I would have guess that you guys would have build a more simple API to do this since you built both products . .

thks,
ak

[Administrator]

Version 4.1 has a special class (GridExcelConverterBase) to support doing most of this type of work. Here is a link to a forum post on getting a beta copy of this code.

http://www.syncfusion.com/Support/Forums/message.aspx?MessageID=38226

[Prashant]

>Version 4.1 has a special class (GridExcelConverterBase) to support doing most of this type of work. Here is a link to a forum post on getting a beta copy of this code.
>
>http://www.syncfusion.com/Support/Forums/message.aspx?MessageID=38226