[Excel Package] Creating an Excel file with several sheets

Forge Component
(5)
Published on 2018-08-02 by Carlos Alfaro
5 votes
Published on 2018-08-02 by Carlos Alfaro

Hi Outsystems team,

I'm using version 11, and I am trying to build a page where I can compare two excel files with several sheets, and where the output would be a single Excel file with several sheets. The problem is, I can only create an Excel file with a single sheet. I built an aux function where the output is a binary data list, where basically the data of each element is the content of a single excel sheet. Then, in the main function, I wanted to join all this data and use "Record to Excel File" to create a single Excel file with several sheets, according to the data of each element of that binary data list that I have mentioned before, and then I would just download this final Excel file. Everything is working out, except the part of creating an excel file with more than one sheet (the output of that download is just a file with a single sheet). Can anyone help me out with that? 

Alexandre Pereira

Hi Alexandre

Please note this component has been deactivated.

The Advanced Excel component has the ability, and some samples I believe, to work with multiple sheets. Have a look at it and let us know in a new support thread under that component if you were able to solve your problem.

Regards

Hanno

Hanno wrote:

Hi Alexandre

Please note this component has been deactivated.

The Advanced Excel component has the ability, and some samples I believe, to work with multiple sheets. Have a look at it and let us know in a new support thread under that component if you were able to solve your problem.

Regards

Hanno


Hi Hanno

Thank you so much for the quick reply.

I'll take a look at that, I hope it help me out with this problem. Thank you!

Best regards

Alexandre