How do I add headers to all my excel sheets

Hi guys, I am trying to create a header for every existing excel sheets that is within my excel workbook. Let’s say I scraped some data from the website and then extracted the datatable to my excel sheet (cell: A2 onwards), leaving A1 to C1 for my headers, how do I keep doing that for every new excel sheet that I created? Also, is there an easier way to add my headers (Product; Price and Country) instead of adding multiple write cells?

PS: Please refer to the pic below for your reference
Thank you for helping!

Hi @Conning

After scraping the data from the website and storing it in datatable you can directly use “Write Range Workbook” to write the data table to excel. Make sure to tick Add headers option. It will give the output with headers.

Hope it helps!!

OMG it worked!!! tysm!


You’re welcome
Happy Automation :blush:

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