Exporting data to Excel (More than 1 worksheets)
Question
Application Type
Reactive

Hi Expert , appreciate your help to export data to more than one worksheets

Example Sheet1 - Schedule Maintenance , Sheet2 Spare Parts Required

Can we do the above without the need to install additional component ?

I had tried Advanced  Excel but it seem quite slow just 6 records it took quite sometime before the Excel get downloaded

Thank you in advance

Hi Jerah,

for more excel export features i can recommend OfficeUtils - Overview | OutSystems. It also has the possibility to create/write to different sheets.

Best

Stefan

Do you have a working example that i can learn from i try to follow the documentation but the output was not successful

Hi Jerah this Forge component OfficeUtils Excel Sample - Overview | OutSystems  explains the process how to create an excel export with Office Utils.

Hi @Jerah 

Go through this oml file:

and logic is :

Thanks

Mansur

TwoExcel.oap

Thank you all for the input i manage to resolve the advance Excel issue and improve the performance. 

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.