Create Excel with header & footer in VBScript from command prompt by EasyXLS component! XLSX, XLSM, XLSB, XLS files in VBScript.
https://www.easyxls.com/manual/tutorials/vbs/excel-footer-header.html