validation on uploaded excel sheet

4 posts, 0 answers
  1. Swetha
    Swetha avatar
    2 posts
    Member since:
    Jul 2015

    Posted 06 Mar Link to this post

    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

     

  2. Bozhidar
    Admin
    Bozhidar avatar
    1102 posts

    Posted 09 Mar Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Swetha
    Swetha avatar
    2 posts
    Member since:
    Jul 2015

    Posted 24 Mar in reply to Bozhidar Link to this post

    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

  5. Bozhidar
    Admin
    Bozhidar avatar
    1102 posts

    Posted 25 Mar Link to this post

    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
    Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
Back to Top