Import Excel File In to Kendo Grid

[Arsham]

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

[Dimiter Topalov]

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

[Archana]

"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

[Dimiter Topalov]

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

[Ani]

"when i uploaded my excel file , the excel data display in to Kendo Grid "
Please guide me to achieve this functionality

[Dimiter Topalov]

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