I filtered the excel and only grab a part of it in the middle, along with the header of that section but when i further filter the excel by columns and then write it to a new excel sheet, the header becomes Column0,Column1 etc if the read and write range’s “add header” option is selected
This is what it looks like before filtering the row
After filtering the first row would disappear.
How do i assign the role as header before writing it to the sheet or can i filter say, Month column and still keep the first row?