Excel to Data table

Help Studio
, ,
1

Hi all,
In my work flow I have a Excel application scope activity in which it will read an excel file and save the output as a datatable. This excel file has a lot of data and currently I use lookup datatable activity is used to extract data.

But, in the workplace pc, it doesn’t comes with an excel application. Is there any way I can permanently save this datatable inside my workflow. So each time when I run the program, it doesn’t need to open the excel application to lookup datatable.

Any guidance on this is highly appreciated.
Thank you.

2

Hi @Christin_John
you can try System→File→Workbook→Read Range ,then save range as DataTable.

Moreover, Programming→DataTable→Lookup Data Table may get the answer.

image