Hi All,
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 exception ?