java excel API - Validation Design
800792Sep 27 2010 — edited Sep 27 2010Hi,
I'm using an application, which uploads an excel file to the server. New Users generally download the excel sheet from my application(Excel sheet template -name,age,dept), and they fill in the data(from downloaded excel sheet - name,age,dept) and they upload the filled in excel sheet to the server.
As a part of validation, i need to find out whether the user is uploading the correct excel sheet or not.
excel sheet with 3 columns (name, age,dept). one way of identifying whether the user is uploading the correct excel sheet or not , is to read the columns ...if the uploaded excel sheet has 3 columns,(name , age, dept), then it is the correct excel sheet.
is there any other way of doing this validation? can i set some version number in the downloaded excel sheet(i.e ) excel sheet downloaded by users)and then if the uploaded excel sheet has the same version number? if not , invalid excel sheet.
Can you help on this?