How to import a whole Excel Table into the DateTable

SuperB1 · July 29, 2021, 8:28am

Hi guys,

How can I import a whole Excel Table into the DateTable instead of inputting the data one by one?
dataTable

Thanks!

pravin_calvin · July 29, 2021, 8:33am

Please refer the screenshot below.

check the add headers property in writerange.

Regards

vinithareddyk123 · July 29, 2021, 8:36am

If you want to convert your excel into data table you can use read range activity the output of this activity is datatable

If you want to write your datatable to excel then use Write range activity

Angel_Llull · July 29, 2021, 8:47am

Hi @SuperB1 You just need to use “Read Range” activity and create a variable. This variable is going to be a DataTable.

system · August 2, 2021, 4:14am

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.