New Export to Excel feature in version 2014.3.1119

11 posts, 0 answers
  1. Larry
    Larry avatar
    11 posts
    Member since:
    Jul 2014

    Posted 10 Dec 2014 Link to this post

    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.
  2. Larry
    Larry avatar
    11 posts
    Member since:
    Jul 2014

    Posted 10 Dec 2014 Link to this post

    This issue has been fixed in version 2014.3.1209

    Larry
  3. Gayathri Rao
    Gayathri Rao avatar
    5 posts
    Member since:
    Nov 2014

    Posted 11 Dec 2014 Link to this post

    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>







  4. Dimiter Madjarov
    Admin
    Dimiter Madjarov avatar
    2310 posts

    Posted 11 Dec 2014 Link to this post

    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.

     
  5. Gayathri Rao
    Gayathri Rao avatar
    5 posts
    Member since:
    Nov 2014

    Posted 11 Dec 2014 Link to this post

    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
  6. Dimiter Madjarov
    Admin
    Dimiter Madjarov avatar
    2310 posts

    Posted 12 Dec 2014 Link to this post

    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.

     
  7. Gayathri Rao
    Gayathri Rao avatar
    5 posts
    Member since:
    Nov 2014

    Posted 14 Dec 2014 in reply to Dimiter Madjarov Link to this post

    Hi Dimiter,

    I changed the JS file link,still no luck 

    Best Regards,
    Gayathri
  8. Dimiter Madjarov
    Admin
    Dimiter Madjarov avatar
    2310 posts

    Posted 15 Dec 2014 Link to this post

    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.

     
  9. Gayathri Rao
    Gayathri Rao avatar
    5 posts
    Member since:
    Nov 2014

    Posted 17 Dec 2014 in reply to Dimiter Madjarov Link to this post

    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
  10. Dimiter Madjarov
    Admin
    Dimiter Madjarov avatar
    2310 posts

    Posted 17 Dec 2014 Link to this post

    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.

     
  11. Gayathri Rao
    Gayathri Rao avatar
    5 posts
    Member since:
    Nov 2014

    Posted 18 Dec 2014 in reply to Dimiter Madjarov Link to this post

    Hi Dimiter,

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

    Best Regards,
    Gayathri
Back to Top