To read multiple tables in excel snd store it in different dt

Hey Guys,

I wanted to read an excel sheet which is having multiple tables with different headers. I want to read each table and store it in respective datatable. Can you please help me how to perform this?

1 Like

Hello @Dinesh_rag,

Do you know the ranges of each table? If so, are these ranges always the same? :slight_smile:

Hi @Dinesh_ragu ,

Would you be so kind as to provide us with a sample dataset so that we may be in a better position to assist you?

If the number of tables in the sheet are fixed, and have fixed ranges then you can simply pass in the top left cell from where the table starts as the range:

image

If the ranges are dynamic, we will require a sample data sheet in order to come up with a logic that will enable you to capture the data you want.

Kind Regards,
Ashwin A.K

1 Like


Please find the sample data, and i might have multiple tables similar to that one. Each table will have only one row excluding the header and the range will not be unique for every time

@ashwin.ashok @Angel_Llull

@Dinesh_ragu,

In this case you should use read range activity with range = A1:D2 and assign it a dt variable.

Then another, read range activity with range = A5:D6 and assign it a dt variable :slight_smile:

Hi

Welcome to uipath forum

Have a view on this exact similar scenario with a sample workflow

Cheers @Dinesh_ragu