Hi Dharmendr,
I have (.xlsb) excel files therefore OLEDB does not work properly.
OpenXml go through each rows. Which is not optimal if you have 200 workbooks and each workbook contains 70,000 rows and 70 columns of data.
However I found a way:
var inputData = valueArray.Cast<object>().Select(Convert.ToString).ToList();