validation on uploaded excel sheet

[Swetha]

Hi, I want users to upload excel sheets in predefined manner which we already defined to them.

Upon upload, we would need to validate and save to database.

i think I can use radupload to upload it, but how to mark cells in red which are not valid

For example, say a cell for last name is empty or birthdate is not in correct format,etc

Appreciate if you can give approach to this or sample code

Thanks

Swetha

 

[Bozhidar]

Hello,

The following demo showcases the validation options provided by the Spreadsheet control:
http://demos.telerik.com/aspnet-ajax/spreadsheet/examples/validation/defaultcs.aspx

Regards,
Bozhidar
Telerik

[Swetha]

Thanks for the response Bozhidar.

Can you briefly give me steps to create this use case?

I wanted users to upload excel sheets in pre defined format which we already give them.

validation should happen when they upload and should show alerts in those columns which failed

users should be able to fix it and save it and click on submit button when done

Thank You

Swetha

[Bozhidar]

Hi,

Once the Spreadsheet is loaded on the client, you can use the client set_validation method to define validation to a range of your choice. The method is described in our online documentation:
http://docs.telerik.com/devtools/aspnet-ajax/controls/spreadsheet/client-side-programming/objects/spreadsheetrange

Regards,
Bozhidar
Telerik