I've got an issue with my app. Using a form, user can choose an excel file to populate some table in database. I validate data before saving it and show the table with some validation messages. I also presents whole data from excel. Here's my issue:
Thank you for your help.
Update: If validation failed user can't use any data from excel file to populate database. He has to correct data from excel file manually and then try to use it again.
If i where you - i would upload excel to server, validate it and
if validation failed - return validation log to user as text file.
if validation success - upload file to db without additional confirmations.
In any cases user cannot fix errors in your grid, so save button will not becom accessible before valid excel will be loaded.
In some circumstances you can return to user his excel with validation column added to it. But i'm not sure that this will be more useful to user.