New Export to Excel feature in version 2014.3.1119

[Larry]

I am reviewing the  new export to Excel feature in version 2014.3.1119.   This feature is really nice, but I cannot find a way to correctly export a grid with dropdownlists.   The export shows the column, but include the foreign key, not the dropdownlist text.   The new Export to PDF works correctly and downloads the text for the dropdownlist.    Is there a way to get the Export to Excel to work correctly on dropdownlists?

Thanks for your help.

[Larry]

This issue has been fixed in version 2014.3.1209

Larry

[Gayathri Rao]

Hi,

I am not able to use the new export excel feature in my kendo grid.It is not calling the controller action specified in .ProxoyURL.

Please find below the the View,Js files used and controller method.

View

@(Html.Kendo().Grid<DataMap.Models.DataMap>()
       
        .Name("DataMapSelected")
        .Columns(columns =>
        {
            /*Columns of the grid*/
            
           
        })
        .DataSource(dataSource => dataSource
        .Ajax()
        .PageSize(30)
        .Read(read => read.Action("DataMap_Read_Service","DataMap").Type(HttpVerbs.Get)))
        .BindTo((IEnumerable<DataMap.Models.DataMap>)ViewData["DataMapSelected"])
         .Scrollable( scroll => scroll.Height(400)) 
         .Pageable(pageable => pageable
            .Refresh(true)
            .PageSizes(new int[] {10,30,50,70,100})
           
            .ButtonCount(5))
        .ToolBar(tools => tools.Excel())
        .Groupable()
        .Sortable(sorting => sorting.Enabled(true))
        .Filterable() 
        .Resizable(resize => resize.Columns(true))
        .Reorderable(reorder => reorder.Columns(true))
        .Excel(excel => excel
        .FileName("DataMap.xlsx")
        .Filterable(true)
        .ProxyURL(Url.Action("Excel_Export_Save", "DataMap")))
        .ColumnMenu(columnMenu => columnMenu.Enabled(true)))  

        DataMapController.cs
     [HttpPost]
       public ActionResult Excel_Export_Save(string contentType, string base64, string fileName)
       {
           var fileContents = Convert.FromBase64String(base64);

           return File(fileContents, contentType, fileName);
       }
Script references

   <link href="http://cdn.kendostatic.com/2014.3.1119/styles/kendo.common-material.min.css" rel="stylesheet" />
    <link href="http://cdn.kendostatic.com/2014.3.1119/styles/kendo.rtl.min.css" rel="stylesheet" />
    <link href="http://cdn.kendostatic.com/2014.3.1119/styles/kendo.silver.min.css" rel="stylesheet" />
    <link href="http://cdn.kendostatic.com/2014.3.1119/styles/kendo.silver.mobile.min.css" rel="stylesheet" />
    <link href="http://cdn.kendostatic.com/2014.3.1119/styles/kendo.dataviz.min.css" rel="stylesheet" />
    <link href="http://cdn.kendostatic.com/2014.3.1119/styles/kendo.dataviz.silver.min.css" rel="stylesheet" />
    
     <script src="http://code.jquery.com/jquery-1.9.1.min.js"></script>
     <script src="http://cdn.kendostatic.com/2014.3.1209/js/jszip.min.js"></script>
     <script src="http://cdn.kendostatic.com/2014.3.1119/js/kendo.all.min.js"></script>
     <script src="http://cdn.kendostatic.com/2014.3.1119/js/kendo.timezones.min.js"></script>
      <script src="http://cdn.kendostatic.com/2014.3.1119/js/kendo.aspnetmvc.min.js"></script>

[Dimiter Madjarov]

Hello Gayathri,


The proxy URL will be invoked in legacy browsers only, where the browser is not capable of saving files locally.

Regards,
Dimiter Madjarov
Telerik

 

 

[Gayathri Rao]

Hi,

I am using Firefox 34.0.5 and IE 11 and Chrome  39.0.2171.71.

Could you please let me know the steps(it would be helpful if u send a code snippet) to be followed for these browsers.

Best Regards,
Gayathri

[Dimiter Madjarov]

Hello Gayathri,


I assume the reason for the issue is that the URL to the JSZip library CDN is incorrect, but it is required for the Excel export functionality to work correctly. It should be:
http://cdn.kendostatic.com/2014.3.1119/js/jszip.min.js

Regards,
Dimiter Madjarov
Telerik

 

 

[Gayathri Rao]

Hi Dimiter,

I changed the JS file link,still no luck 

Best Regards,
Gayathri

[Dimiter Madjarov]

Hello Gayathri,


Could you please send us an isolated runnable example that demonstrates the problem, so we could inspect it locally and provide further assistance? I am looking forward to hearing from you.

Regards,
Dimiter Madjarov
Telerik

 

 

[Gayathri Rao]

Hi Dimiter,

I am not able to attach the file. Reply posted with attachment is giving error. Please let me know any other means through which I can send the code.

Best Regards,
Gayathri

[Dimiter Madjarov]

Hello Gayathri,


Probably the file is bigger than the file size limit. You could either use some file sharing platform or send us a ticket, regarding the issue, in our support system, in which the file size is bigger - 20 mb.

Regards,
Dimiter Madjarov
Telerik

 

 

[Gayathri Rao]

Hi Dimiter,

I have raised the ticket.Ticket Id is 890469.Please assist.

Best Regards,
Gayathri