How to resize a table on Excel?

Help Studio
1

Hi all,

I have a question:
I created a table template into an Excel sheet as in attached file.
In this table template the robot need to paste some value and extend the table (green).
However the robot paste data but don’t extend the table.
I try “Auto Fill Range” activity, but it works only if there is a formula.
Did you know how can I resolve this issue ?
excel table

Thanks

2

Hi @MigT

Try using below activities by @balupad14 :-

image

Mark as solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

2 Likes
3

Thanks @Pratik_Wavhal.

Do you know the name of the package to have these activities please ?
Thank you.

Best,

4

Hi @MigT

Below is the Activity Name :-

image

Mark as solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

5

Thanks @Pratik_Wavhal

I try it, but my table into my Excel sheet is not extended automatically

6

Hi @MigT,

What is the activity you used to update the Excel?
I am asking because Workbook activities do not copy the table format,
but Excel activities(Write Range, Append Range) should be able to.

7

Hi @marci080,

I used Write Range activity to paste my data into the table. However the table is not adjusted according to the number of data rows pasted.

8

Instead of just WriteRange, please use ExcelWriteRange activity. Please see ExtendExcelTbl.zip (21.2 KB) attachment for sample. Hope it helps.

1 Like
9

Finally, I find the solution.
I used the write range activity for Excel scope and independently to have a formula or not the table is resize proportionally to the number of data row.

1 Like
10

We published in the same time ^^, I find this solution too. Thanks @marci080

1 Like
11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.