Posted 09 Oct 2009 Link to this post
Good afternoon, I tried to export a radgrid to Excel with success using
Telerik.Web.UI.GridExcelExportFormat.ExcelML with ExportOnlyData/IgnorePaging/OpenInNewWindow all set to true. I have search for a couple of days a way to add content to the Excel sheet before adding the radgrid. I mean, I need to add some text to the Excel file and execute some macro on the Excel sheet. How can I do this? The radgrid is using Ajax.
Any help would be most appreciated. Shoud a use an Excel template and feed the datagrid into it? By the way, I am using Excel 2007 but hope everything work's also in Excel 2003. I use the function ExcelMLExportRowCreated and ExcelMLExportStylesCreated to format the loook and feel of the columns with success.
Thank's for your precious time :)
Mario
Posted 13 Oct 2009 Link to this post
Posted 21 Oct 2009 Link to this post
protected
void
RadGrid1_ExcelMLExportRowCreated(
object
source, GridExportExcelMLRowCreatedArgs e)
{
if
(e.RowType == GridExportExcelMLRowType.HeaderRow)
RowElement newRow =
new
RowElement();
CellElement newCell =
CellElement();
int
colsCount = RadGrid1.MasterTableView.AutoGeneratedColumns.Length;
itemsCount = RadGrid1.MasterTableView.Items.Count;
newCell.Data.DataItem =
"Test Test"
;
newRow.Cells.Add(newCell);
e.Worksheet.Table.Rows.Insert(0, newRow);
e.Worksheet.AutoFilter.Range =
"R2C1:R"
+ itemsCount +
"C"
+ colsCount;
}
Posted 14 Jan 2020 in reply to Daniel Link to this post
Hi,
could you please provide code, how ot add sum formula when exporting to xlsx format. I suppose it should be done in InfrastructureExporting event.
Thank you.
Posted 17 Jan 2020 Link to this post
Hi Vasssek,
The ExportInfraStructure will allow you to get access to the output the Grid created but before passed to the Document Processing libraries to actually build the Excel file, see Export Infrastructure. "The Export Infrastructure is designed to be a middle tier structure that sits between an export library and server control."
The Telerik Document Processing (TDP) libraries are the ones that you can use to interact with documents even creating formulas, see General Information - Formulas. For implementing formulas, you'll have to get the XLSX structure out of the Grid and process it further with the Telerik Document Processing (TDP) libraries.
We have RadGrid online demo where the XLSX output is extracted, then imported into the TDP libraries for further processing, see Grid - Export Multiple Grids. In this particular example, you will see that the output is extracted from each grid, and the TDP libraries are used to construct a document with as many Sheets in the same WorkBook as many Grids are extracted. In your case, however, you can get the output, implement the formula instructed in the TDP documentation and return it in the Response for downloading.
See examples using the TDP libraries in different scenarios:
Kind regards, Attila Antal Progress Telerik