How to read data from excel,convert to datatable or dataset?

Question

 

when i open the excel file above error is occurs, and another error inside the excel opening(Excel was able to open the file by repairing or removing the unreadable content) i click the yes and save as another file and upload the excel.but after the upload many lines are ignored how to fix it.i follow some online solutions and apply but not working.

if i copy the data and paste to new excel doc and upload no problem is occurs successfully uploaded.