How to read excel using Invoke code and output as datatable

Help Studio
1

Hi i want to read my excel file using Invoke code and output as data table, if it is possible without using read range activity?

2

Hi Vincent,

Yes, you can read excel from code and pass the datatable as out argument in invoke code activity and use it in uipath workflow further.
For example C# code using oledb is easier (provided oledb driver installed) https://www.c-sharpcorner.com/code/788/how-to-convert-excel-to-datatable-in-C-Sharp.aspx

Regards,
Sruthi YNM