Import Excel File In to Kendo Grid

6 posts, 0 answers
  1. Arsham
    Arsham avatar
    4 posts
    Member since:
    Aug 2017

    Posted 01 Sep 2017 Link to this post

    Hello Telerik Team

    Is there any way to upload an excel file by using angular 2 ?

    actually I looking for way that when i uploaded my excel file , the excel data display in to Kendo Grid 

    thanks in advance

  2. Dimiter Topalov
    Admin
    Dimiter Topalov avatar
    1289 posts

    Posted 05 Sep 2017 Link to this post

    Hi Arsham,

    The Kendo UI for Angular suite includes an Upload component that can be used to upload any kind of files. It comes with built-in forms support and other features as described in the following section of our documentation:

    http://www.telerik.com/kendo-angular-ui/components/upload/#toc-upload-overview

    As for loading excel files in the Grid, such functionality is currently not supported. The Grid can be bound to an array of data, an object of type GridDataResult, or directly to an observable via the async pipe. Further details are available here:

    http://www.telerik.com/kendo-angular-ui/components/grid/data-binding/

    If you have the time, please submit feature requests for any ideas that you feel will improve the quality of our product to our UserVoice portal:

    http://kendoui-feedback.telerik.com/forums/555517-kendo-ui-for-angular-feedback

    It is closely monitored and helps us prioritize, based on customer demand, when updating our roadmap. Thank you in advance.

    Regards,
    Dimiter Topalov
    Progress Telerik
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  3. Archana
    Archana avatar
    2 posts
    Member since:
    Feb 2017

    Posted 11 Apr 2018 Link to this post

    "when i uploaded my excel file , the excel data display in to Kendo Grid "

    Is this feature, uploading Excel sheet Data to Grid is up now? 

    Thanks

    Archana

  4. Dimiter Topalov
    Admin
    Dimiter Topalov avatar
    1289 posts

    Posted 13 Apr 2018 Link to this post

    Hi Archana,

    You can find the detailed response in the private support thread regarding the same topic (Ticket ID: 1161966), but I will also paste it here, so other members of the community that are interested can see it too:

    Thank you for creating and supporting this UserVoice item. Providing such a built-in functionality is currently no included in our immediate plans, but depending on the customer interest the feature request generates in the UserVoice portal, we can consider it in the future.

    Meanwhile the only available option is a custom implementation, based on parsing the excel file such that an array of JSON objects that the Grid can be bound to, is produced. There are some third-party libraries that seem to be offering such a functionality, e.g.:

    https://www.npmjs.com/package/excel-as-json

    You can check them out and determine whether they could be of any use in your scenario.

    I can also recommend the Progress Professional Services for any required assistance with custom implementation and custom-tailored solutions:

    https://www.progress.com/services

    Typically, our roadmap and priorities depend largely on the business value and customer demand for specific components and features, but I can also present you an offering that may be relevant and applicable to your needs - our Feature Acceleration program. 

    It allows a customer to negotiate a certain component or functionality to be implemented on demand or sooner than our roadmap implies. Feature acceleration fits well in scenarios where a feature or enhancement is important for an application's success, but it is not planned to be available at the time of the application's completion.

    Let me know if you are interested in pursuing this option or otherwise benefiting from the expertise of our Professional Services team at any time and I will put you in touch with them to discuss your exact specifications and possible timeframes.

    Regards,
    Dimiter Topalov
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  5. Ani
    Ani avatar
    1 posts
    Member since:
    Jun 2018

    Posted 16 Oct 2020 in reply to Archana Link to this post

    "when i uploaded my excel file , the excel data display in to Kendo Grid "
    Please guide me to achieve this functionality
  6. Dimiter Topalov
    Admin
    Dimiter Topalov avatar
    1289 posts

    Posted 21 Oct 2020 Link to this post

    Hello Sree,

    As described in my previous response, such functionality is not available. In theory it can be achieved via a custom implementation, involving a custom solution or a third-party tool for parsing an excel file and creating a collection of JavaScript objects from the excel file rows - then this collection can be provided as Grid data.

    Such custom implementations and third-party library integration fall outside of the scope of our support service.

    I can suggest supporting the Feedback portal feature request item:

    https://feedback.telerik.com/kendo-angular-ui/1360693-import-excel-file-in-to-kendo-grid-for-angular-2

    We also recommend our Professional Services for any required assistance with custom scenario implementation, consulting, training, development, and more:

    https://www.progress.com/services

    Regards,
    Dimiter Topalov
    Progress Telerik

    Five days of Blazor, Angular, React, and Xamarin experts live-coding on twitch.tv/CodeItLive, special prizes, and more, for FREE?! Register now for DevReach 2.0(20).

Back to Top