Hidden Columns Show in Excel Download
Hello,
I have a requirement to have columns match between UI and an excel sheet download. With optimized tables a user is able to hide and show fields as they choose. With our design of using a binary file as a template for the excel document, we can not control if a column shows up on the download or not (we can control what data gets exported, but the column will still show up per the binary file uploaded).
Any suggestions on a way to design this that allows the file to have excel formatting(table width, colors, etc.) and dynamically generated columns from the table?
Thanks