How to change excel file as table

[anjani_priya]

How to change excel file as table format, if i have 10 excel files how to change them all into excel files

[Anil_G (Anil Gorthi)]

@anjani_priya

You can use create table activity in loop

https://docs.uipath.com/activities/other/latest/productivity/excel-create-table

Cheers

[Praveen_Mudhiraj]

can you share the input and out sample

@anjani_priya

[anjani_priya]

I have 10 excel files in a folder I have to change all the data into table format

[Praveen_Mudhiraj]

@anjani_priya

have 10 excel files in a folder I have to change all the data into table format

I have 10 excel files in a folder

this ok

I have to change all the data into table format

show the sample this then easy to build code

@anjani_priya

[anjani_priya]

Book1.xlsx (8.5 KB)
Book2.xlsx (8.5 KB)
I need to convert this two files at a time in table format

[Anil_G (Anil Gorthi)]

@anjani_priya

1. For each file in folder
2. Inside loop use excel file with currentfile.FullName
3. format as table with range as excel.SelectedSheet

Cheers

[Nitya1 (Nitya Tomar)]

Hi @anjani_priya

To change Excel files into table format in Excel, you can follow these steps for each Excel file:

1. Open Excel File:

   • Open the Excel file that you want to convert into a table.

2. Select the Data Range:

   • Click on any cell within the data range you want to convert into a table. This should be the range that you want to include in your table.

3. Create a Table:

   • Go to the “Insert” tab in the Excel ribbon.
   • Click on the “Table” button. This will open a dialog box.

4. Confirm Data Range:

   • Ensure that the correct data range is selected in the dialog box.
   • If your data has headers, make sure the “My table has headers” option is checked.
   • Click “OK” to create the table.

5. Format the Table:

   • Excel will now convert your selected data range into a table format.
   • You can format the table further by giving it a meaningful name in the “Table Name” box in the Design tab that appears when you have the table selected.
   • You can also apply specific table styles, if desired.

6. Repeat for Other Excel Files:

   • Close and save the Excel file that you’ve just converted into a table.
   • Repeat these steps for each of the 10 Excel files you want to convert into tables.

Thanks!

[vinitha_yachamaneni]

@anjani_priya

How to change excel file as table format, if i have 10 excel files how to change them all into excel files

Hi @anjani_priya

You can try this steps

1. Assign activity:
   filesArray = Directory.GetFiles(“YourFolderPath”, “*.xlsx”)

2. For Each activity:
   For Each file In filesArray

3. Excel Application Scope:
   Input: excelFile (from For Each loop)

4. Sequence:
   Read Range:
   Input: excelFile
   Output: dataTable

5. Build Data Table:
   Output: structuredTable

6. Write Range:
   Input: excelFile
   Output: structuredTable

[anjani_priya]

All excel files should be converted into data tables format how?

[vinitha_yachamaneni]

You can Check out this thread Once @anjani_priya

Read an excel file and save it in datatable

You can have the excel file in a particular folder and using Assign string, filelist=directory.GetFiles("location","*.xlsx") you can get the path of the excel, Make sure that there is only the required excel files in your speciifed location To get the sheet name you can follow the below post Also to get the data extracted from excel you might need to store it somewhere like a queue

[Praveen_Mudhiraj]

Hi @anjani_priya

you can try this way

Xaml : - Excels to datatable.zip (2.3 KB)

out put

let me know its working or not

[anjani_priya]

I have to convert into datatable

[Praveen_Mudhiraj]

Try above xaml it will work and

Note : - if you need this as output just disable the headers

1. Read range workbook Activity

2. write range workbook activity

@anjani_priya

[anjani_priya]

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

[Anil_G (Anil Gorthi)]

@Anil_G

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

@anjani_priya

If this resolves the issue…can you please close the topic

Cheers