Uipath cant pull datatable into excel

Hi

I am building a process which requires pulling a report from PowerBi into Uipath and then creating a datatable with specific information which will be read into an excel template. The template then requires the data to be read in from row A6 however the problem i am having is that the only row being populated it row A6.

I have an Output data table activity in the workflow and can see there are a lot of rows which need to be added to the template but i am unsure why the write range isn’t pulling them in. Any help is greatly appreciated.

Thanks

I dont know if i understand you well, but A6 is a cell and not a row… If you use that as range, you will get only that…

Yes sorry - I want to pull the datatable in starting at that cell however it doesnt seem to be working. It only pulls one line from the datatable

Can you help?

What i like to do is make a table of the data in excel, so in range i use the table name instead.

Like this?

image

instead of “A6” you put like “Table1”. Also dont forget your data table contains headers, you cant write it in row 6…

But i am reading it in from a datatable? which is called “filteredDefferedRevenue”

That is not the range property…

ok so what should be in the range property to read in the full datatable?

You are writing, not reading… i think there is some confusion here…

I understand that i am writing into the excel - i am writing the data from my datatable "filteredDefferedRevenue” into a excel template. I have used a write range not a read range


I told you to create a table in you excel range to use as the range name in the write range…

How do i do this? I dont know how many rows will be brought in weekly from the powerbi report which is where my datatable "filteredDefferedRevenue” gets its data

In my case i would use Table1 instead of your A6, so your new data would automatically be added in your excel in the right place…