Last activity: 9 Jan 2023 9:10 EST
Generate Dynamic .xlsx Excel file NOT based on binary template
I have a requirement in v8.6 to be able to export values to an excel file without invoking "MSOGenerateExcelFile" OOTB as they require a binary template.
At code development I will not be having the column header name and the corresponding column data. Those values will be populated by user selection from UI.
CSV's can be dynamically generated using "pxConvertResultsToCSV" OOTB. I need a similar approach for generating .xlsx file. Or any other solution implemented.