How to read/write multiple excel cells from all excel files into separate excel

[arkd3um1988]

Hello,

I am new to UiPath and the task that I got is to read a range of cells from all excel files located in a folder and write them into another excel file located in a separate folder.
All excel files have same type of structure so the rage of cells that i need to copy from each file is fixed ex: D24:F24.
A quick step by step would be enough since I can search each step individually for further information.

Thank in advance

[supriya117 (Supriya Allada)]

Hi @arkd3um1988

Use read range workbook and append range workbook activities.

Regards,
@supriya117

[Harshith_Adyanthaya]

Hi @arkd3um1988,

Try this. Hope it helps.

[Jithesh_R (Jithesh Karkera)]

@arkd3um1988 ,
You can try this

Note : Variable type of “Files” is array of strings(String())

Regards,

[arjunshenoy]

Hi @arkd3um1988, welcome to the Community.

Get all excel files into an array by using the function:

allExcelFiles = Directory.GetFiles("C:\YourFolderPath", "*.xlsx")

Now, for each file in the array, read the file by specifying the range, get it in a datable variable, append this into a masterDataTable which must be kept outside of the loop.

In the end, all your datat will be avalable in the masterDataTable.

Hope this helps,
Best Regards.

[arkd3um1988]

Thank you so much for the spot on picture.
Maybe because I am a beginner, I still need to learn a little more until I can search all my information on my own.
If only I knew that I would get such a fast reply here it would have saved me a bit of time…ow well
Best reards and thank you all again