Custom Cell in Export with Grid mvc kendo

[Houssem]

Hello,

 I need to format some cell in export excell with kendo mvc grid. I use the export in this way :

.Index.cshtml :

 .ToolBar(tools => tools.Excel())
.Excel(excel => excel
.FileName("Export.xlsx")
.ForceProxy(true)
.Filterable(true)
.AllPages(true)
.ProxyURL(Url.Action("ExcelSave", "CieAssistant"))
)

 Controller :

public ActionResult ExcelSave(string contentType, string base64, string fileName)
{
var fileContents = Convert.FromBase64String(base64);
return File(fileContents, contentType, fileName);
}

 

How i can update format of cell in the controller function "ExcelSave" ?!

 

Thanks,

[Patrick | Technical Support Engineer, Senior]

Hello Houssem,

Take a look at the attached project illustrating how to format cells when exporting to Excel.

Here is the process of how the program runs:
1. Hit the Export button.
2. The formatting will occur with the function excelExport() before any exporting takes place.  
3. The file is created.

Hopefully, this helps clear things.

Regards,
Pat
Telerik