'Split Parameter value for the excel sheet name in Jasper Report [duplicate]
I am generating an excel file with multiple sheets from Jasper.
I am getting some comma(,) separated values in Jasper's input
for eg:- 000324,000323,000322.
I want to split this value and give them as the sheet names in a single excel file.
As we can see in the above example we are having 3 inputs so 4 excel sheets will be generated first sheet name will be given as info
and the remaining should be named 000324,000323 and 000322.
if there are 4 inputs then 5
excel sheets
will be generated in a single excel file and apart from the first sheet other sheets will be named from that 4 values which will be taken as comma separated in the input field (eg: 001,002,003,004).
I am new to Jasper Report so can anyone help me to split this input and give the name to the excel sheets.
Thanks in Advance!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|