We have a requirement to show a Excel report with multiple sheets and graphs incorporated in it which requires Macros to be enabled. legacy system is built on .net and it generates Excel with multiple sheets with graphs in it by using .dll. my requirement is to implement that excel in PEGA. Can we do it in PEGA? if not how can we integrate with it to use the .net dll file.
You can generate an excel file using MSOGenerateExcelFile activity (the data from pega can be populated in to multiple tabs). Look at the references to this activity to understand on building the template excel file.