Retrieve excel data from multiple workbooks in sharepoint
 

Hello!

Is there sample code for openning excel workbooks one by one from sharepoint
and copy datasheet from each workbook to another workbook which collects all
data from each workbook in sharepoint?

Thank you so much!