Hi all

Using BPMUI toolkit, We can export data as excel file.
I can export only one excel file include only one sheet.

My question is that Can I export one excel file include multiple sheets?

As we know, Created/Exported Test1.excel file and this file have sheet1 & sheet2 etc

Thanks. 

[Updated]
I have tried something but This is impossible using current component. right? 

------------------------------
Kwangho Kim
------------------------------

Hello Kwangho,

Yes, you are correct, this cannot be achieved using the out of the box component.
Handling multiple sheets in Excel is not very straightforward, you need to use some external libraries.
There are multiple ways of doing this, one way could be developing a custom web application implementing a servlet which would use Apache POI.
You can send the required data to the servlet from UI via HTTP call and in return the servlet would give file stream to download that file from browser.
Then, you can simply implement a button/ui widget to make that HTTP call from UI.

Thanks!

------------------------------
Atanu Roy
Solution Architect
Salient Process
------------------------------

Hi Atanu 
Thanks for your update.
Kim

------------------------------
Kwangho Kim
------------------------------

Original Message:
Sent: Thu February 02, 2023 11:18 PM
From: Atanu Roy
Subject: BAW 20.0.0.1 BPMUI Toolkit - DataExport

Hello Kwangho,

Yes, you are correct, this cannot be achieved using the out of the box component.
Handling multiple sheets in Excel is not very straightforward, you need to use some external libraries.
There are multiple ways of doing this, one way could be developing a custom web application implementing a servlet which would use Apache POI.
You can send the required data to the servlet from UI via HTTP call and in return the servlet would give file stream to download that file from browser.
Then, you can simply implement a button/ui widget to make that HTTP call from UI.

Thanks!

------------------------------
Atanu Roy
Solution Architect
Salient Process
------------------------------