How to add headers in append range?

Hi, I used these steps.

  1. Data Scraping - got table
  2. Append Range

However , there is no Header in appended xlsx file. I need to append table with header how do i append table with headers

Hi @Gabriel_Choi

Use write range and check the property as add headers ll add in .xlsx file

Thanks
Ashwin.S

Im Sorry But I have to add multiple datatable in one xlsx with header so thats not answer.

Hello There,

You could make standard which will contain headers,

  1. Create a excel file and write columns how many you want,
  2. Start appending datatables,

This way, your task could be done.

Cheers,
Pankaj