Since you are using some older version of the component and I am not sure about it. I think you should open the Excel object first which is compulsory (alternatatively, you may use Excel.LoadData method which is a bit faster than Open method), then get your desired worksheet in the workbook, you may extract your desired data either through cell by cell or use methods i.e., Cells.ExportDataTable() method (if available) or Cells.ExportArray() method to fill a datatable or an object array. Now you can update your datasource with your desired data based on datatable or array.
But the problem tat we will be faced with is, the excel sheet will get opened at the client side, which is not at all intended and we have to manually close that excel sheet
When the only thing intended to be done is read the excel data, these methods are infact getting the excel file opened at the client side which is to be avoided completely.
I am not very clear what you have described. Well, Excel.Open and Excel.LoadData only loads the excel file with data / objects into memory not physically displays into MS Excel. When you save the excel file using the following method, the resultant file would be opened into MS Excel / browser: