How to create a excel sheet and add the headers from another excel sheet

plz help me to do that

welcome to the forum

use a read range for reading in excel1 into a datatable (addHeader is ticked on) - dtData
use write range to write out into the same excel, other excel a new worksheet:

  • configure new worksheet name
  • ensure AddHeaders is ticked on
  • datatable: dtData.Clone
1 Like