Hide columns in Excell template for pxGenerateExcelFile
Hi,
When using pxGenerateExcelFile, we pass in a excel template that defines what data to include. If we wanted some columns in the excel to be visible only when some conditions are met then it seams the only option to do this is to have another excel template, and chose the template dynamically.
This creates the need for multiple different templates, that all have to be managed seprately; e.g if a new row is added to the excel for all scenarios we then have to go edit every template we have.
Is there a better solution where we can have one template but define the conditions that have to be met for a column in the excel to be included.
Many thanks,