ExcelBanter - Column heads on second row

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Column heads on second row (https://www.excelbanter.com/excel-programming/447024-column-heads-second-row.html)

Ronald Randall

Column heads on second row

How do I set styling or XML settings so an Excel file exported with the following headings will accept sortable, filterable column heads in row 2 instead of the top row? Related: how can a file be exported with filtering already turned on?

<cfcontent type="application/vnd.ms-excel" reset="yes"
<html xmlns:x="urn:schemas-microsoft-com:office:excel"

Any help appreciated.

All times are GMT +1. The time now is 08:37 PM.