I want to read data from an excel file and want to store it in a datatable. Previously I was using interop excel.But it give COM
exception many time.So I want to switch to OPENXML
. But I am unable to read xls file
in it .It is showing Corrupted data exception
.Any 1 has sample code to fix it.
Which is better to read excel file ?
Is dere any way to stop COM