In my application one of the tasks is storing the excel file data in to database. for this i am using POI api . but i want to validate the whole data of excel file whether it is correctly entered or not.
for this validation please give me some suggestions.
nir sharma wrote:hi,
You can first check what is the type of cell, in case your excel sheet contains all different types of data. Then on the basis of the cell type, you can call your validation methods on that data.
thanks for your reply.
but i want to restrict the user to upload the excel files, whose cells are fixed to some type. if user doesn't give the excel file with predefined cell types then we have to show some error message.
for this validation , what i have to do.