how to add red background color in excel export for each row and column

abduls

in this style

var s4 = '<xf numFmtId="0" fontId="2" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1">' +
'<alignment vertical="center" horizontal="center" wrapText="1"/></xf>';

colin

There are many threads on changing the Excel cell colour, for example see here and here.

Colin