How to change the excel file data inti datatable format

[anjani_priya]

In excel if we press ctrl+t then the data will change as datatable format how can we do that in UiPath

[Praveen_Mudhiraj]

1.Use the “Excel Application Scope” activity to open your Excel file.

2.Inside the “Excel Application Scope,” use the “Read Range” activity to read the data from the Excel worksheet.

3.Create a variable of type DataTable to store the data.

4.After reading the data, use the “Add Data Table” activity. This activity allows you to convert the data into a table format.

5.Configure the “Add Data Table” activity as follows:

Input: Use the DataTable variable created in step 3
Worksheet: Specify the Excel worksheet where you want to add the table.
Table Name: Provide a name for the table.

@anjani_priya

[anjani_priya]

send me the code

[Anil_G (Anil Gorthi)]

@anjani_priya

Fid you try with create table activity under excel activities?

The same is provided in another thread aswell

How to change excel file as table

@anjani_priya For each file in folder Inside loop use excel file with currentfile.FullName format as table with range as excel.SelectedSheet Cheers

Cheers

[anjani_priya]

Can you send me the code

[Anil_G (Anil Gorthi)]

@anjani_priya

As mentioned already this is how it looks

cheers