The challenge is with point #3: generate single excel output file where column headers are in two top rows again. I know how to transform two header rows into a single header row, but I donât know how to keep two header rows in an output excel file and I havenât found anything like this on the forum.
Any suggestions?
The trick would be to use in a 1st step an -Excel Writer- node to just write the headers and all the rows in a 2nd step using again an -Excel Writer- node to save all the rows but this time configured with the checking of the âappendâ radio button option, the unchecking of the âWrite Column Headersâ option and the checking of âDonât write column headers if sheet existsâ.