This is a migrated thread and some comments may be shown as answers.

New Export to Excel feature in version 2014.3.1119

10 Answers 101 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Larry
Top achievements
Rank 1
Larry asked on 10 Dec 2014, 11:27 PM
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.

10 Answers, 1 is accepted

Sort by
0
Larry
Top achievements
Rank 1
answered on 10 Dec 2014, 11:45 PM
This issue has been fixed in version 2014.3.1209

Larry
0
Gayathri Rao
Top achievements
Rank 1
answered on 11 Dec 2014, 06:32 AM
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>







0
Dimiter Madjarov
Telerik team
answered on 11 Dec 2014, 03:39 PM
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
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
Gayathri Rao
Top achievements
Rank 1
answered on 12 Dec 2014, 05:38 AM
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
0
Dimiter Madjarov
Telerik team
answered on 12 Dec 2014, 10:05 AM
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
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
Gayathri Rao
Top achievements
Rank 1
answered on 15 Dec 2014, 05:08 AM
Hi Dimiter,

I changed the JS file link,still no luck 

Best Regards,
Gayathri
0
Dimiter Madjarov
Telerik team
answered on 15 Dec 2014, 08:53 AM
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
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
Gayathri Rao
Top achievements
Rank 1
answered on 17 Dec 2014, 08:44 AM
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
0
Dimiter Madjarov
Telerik team
answered on 17 Dec 2014, 12:24 PM
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
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
Gayathri Rao
Top achievements
Rank 1
answered on 18 Dec 2014, 06:19 AM
Hi Dimiter,

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

Best Regards,
Gayathri
Tags
Grid
Asked by
Larry
Top achievements
Rank 1
Answers by
Larry
Top achievements
Rank 1
Gayathri Rao
Top achievements
Rank 1
Dimiter Madjarov
Telerik team
Share this question
or