How to provide excel headers

Question

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...?

Padmakumar · Accepted Answer

Hi,I’m new to this AA tool, can you please share sample videos...You can start with the below tutorial.

Padmakumar · Answer

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.

Reply

Sign up

Login to the Pathfinder Community

Scanning file for viruses.

This file cannot be downloaded