In the Appian User Interface, I have a grid with colored rows. My requirement is that when I click on 'Export to Excel' from the grid, the downloaded Excel file should retain the same row colors. How can I achieve this?

Is there any alternative method with customization can we achieve?

As mentioned in your link, I believe the Export DSE to Excel Node will actually overwrite the formatting in any cells that it's used to add data to (and that's beyond how much of a pain it is to create a copy of your template file first so you don't accidentally overwrite it, since they never added a Base Template option).

I think OP might need to try with the JSON to Excel smart service or one of the deprecated Excel Tools smart services (CDT to Excel or SQL to Excel), though these merely don't overwrite formatting, but nothing I know of really allows addition of dynamic formatting.