For me changing from "HDR=NO;" to "HDR=YES;" in following OleDb Connection String resolved the issue:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source='Excele file location in File System';Extended Properties="Excel 12.0 Xml;HDR=YES; IMEX=1";