i want to format the excel while export from the rad grid the for mat as follows :
Lines(Rows in Excel).
Lines(Rows in Excel).
Lines 1 and 2: the lines must be there as blank lines
Line3: date with format dd.mm.yyyy in first cell (Column A)
Line 4 and 5: the lines must be there as blank lines
Line 6: i have display the Data of Rad grid.
Can you please help me out .
Thanks And Regards,
Guru Kiran.P
2 Answers, 1 is accepted
0
Richard
Top achievements
Rank 1
Rank 1
answered on 30 Dec 2011, 09:04 PM
Guru:
I do not believe that is possible to make the modifications to the Excel file that you require when calling RadGrid's "GridTableView.ExportToExcel()" method. All available modifications are spelled out on the description tab of the
Grid/MS Excel/MS Word/CSV online demo.
You would have to format the data source of the grid by inserting blank rows and formatting the date colum prior to calling the export method.
RadGrid simply exports the data grid to ExcelML format, as is.
Hope this helps.
I do not believe that is possible to make the modifications to the Excel file that you require when calling RadGrid's "GridTableView.ExportToExcel()" method. All available modifications are spelled out on the description tab of the
Grid/MS Excel/MS Word/CSV online demo.
You would have to format the data source of the grid by inserting blank rows and formatting the date colum prior to calling the export method.
RadGrid simply exports the data grid to ExcelML format, as is.
Hope this helps.
0
Shinu
Top achievements
Rank 2
Rank 2
answered on 02 Jan 2012, 05:40 AM
Hello Guru,
Check the following help documentation which explains more about this
Word/Excel export (HTML-based).
-Shinu.
Check the following help documentation which explains more about this
Word/Excel export (HTML-based).
-Shinu.