Kendo Upload - Validate File Content

[Jerome]

Good day,

How do I validate the content of a file on the upload event?  I want to read the contents of an excel file and get a distinct list from one of the columns.  Thank you.

Regards,

Jerome

[Anton Mironov]

Hello Jerome,

Thank you for contacting the team.

The Upload supports three types of validation:

• By file extension.
• By maximum file size.
• By minimum file size.

The following article provides further information about the Telerik UI Upload Validation:

• https://docs.telerik.com/aspnet-mvc/html-helpers/editors/upload/validation

Here is a demo of the Telerik Upload Validation:

• https://demos.telerik.com/aspnet-mvc/upload/validation

In order to make the needed distinct filtration and validations, make it before using the Upload Component.

 

Kind Regards,
Anton Mironov
Progress Telerik

[Jerome]

Good day,

Thank you for your response.

I am aware of the upload validations.  However, I want to validate the file contents.

Should I use the Select event with a function?  If so, how would I open the file and read its contents? 

I thought by using the upload event and creating a byte array and copying the contents to a fileStream - but it looks like that only works for .txt files.

Thank you.

Regards,

Jerome

[Anton Mironov]

Hi Jerome,

Thank you for the additional details provided.

The Telerik UI Components stands for visualizing the data provided. In order to upload, open, and read the Excel content, I would recommend using the Telerik UI Spreadsheet Component.

The following demo is representing the server import and export functionality:

• https://demos.telerik.com/aspnet-mvc/spreadsheet/server-side-import-export

For further information about the configuration, methods, and events of the Spreadsheet visit the following article:

• https://docs.telerik.com/kendo-ui/api/javascript/ui/spreadsheet

I hope the Spreadsheet Component will help for achieving the desired result.

 

Best Regards,
Anton Mironov