Skip to main content
Answer

How to provide excel headers

  • March 2, 2023
  • 3 replies
  • 538 views

Forum|alt.badge.img+1

Hi,

In Automation anywhere if we want to right headers in to excel, without manually writing how we can provide? Which activity we can use for this...?

Best answer by Padmakumar

Hi,

 I’m new to this AA tool, can you please share sample videos...

 

You can start with the below tutorial.

 

 

3 replies

Padmakumar
Premier Pathfinder | Tier 7
Forum|alt.badge.img+15
  • Premier Pathfinder | Tier 7
  • March 2, 2023

Hi @chippykolot ,

 

You can use the Set Cell action either in Excel Basic or Advanced packages. Within a Loop→ For Each Row in Excel file, with the help of a Counter variable (to assign the current row index), use the Set Cell action and iterate till your requirement fulfills. Don't forget to increment the counter variable at the end of the loop.


Forum|alt.badge.img+1
  • Author
  • Cadet | Tier 2
  • March 2, 2023

Hi,

 I’m new to this AA tool, can you please share sample videos...


Padmakumar
Premier Pathfinder | Tier 7
Forum|alt.badge.img+15
  • Premier Pathfinder | Tier 7
  • Answer
  • March 2, 2023

Hi,

 I’m new to this AA tool, can you please share sample videos...

 

You can start with the below tutorial.