How to append excel range and make sub-header?

Help Activities
, ,
1

Hi,

I have an automation to make report excel file daily (date today) as seen below (Current Output) :

image
image1125×377 21.5 KB

The data needs to be continuous to the right side as seen below (Expected Output). Assuming the robot is executed tomorrow (30 july), and so on the next day (31 july) :

image
image1513×178 7.75 KB

Is there any way to make the header like that? Merge 3 cell into one and make sub-header?

2

Hello @Rhys18 , please refer this

3

Hello @Rhys18 , refer this acitvity.

  1. Sample excel placed in data folder
  2. Process is dynamic based on Column count and works one day once to fill the current date at the end of the current column.
    Column-Sample.zip (79.7 KB)

Regards
Gokul Jai

4

Hi,

So I don’t have to use balareva activities?

5

If the Template of Merged cell already has, you don’t need to use it. Just copy and paste the last 3 columns 2 rows

6

Okay just modify it a little and it works ! Thank you very much Mr. Gokul

1 Like
7

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