RE : Jaspersoft Ireport export to excel

0

I am able to export the data into three sheets in excel. xls  from jasper ireport ,after getting open my excel i got three sheet names which i given x y z ,but i want my data to be  reflect only sheet wise for example x details i need to get in x sheet ,y details into y sheet & z detials in Z sheet , but all my data is combining into single one sheet .

for example table name vinod having three columns  x y z ;

select x,y,z from vinod;

after exporting i need to get in excel (bottom of sheet X sheeet,  Y sheet ,  Z sheet ) ;

please any one try to help what to do already in menu bar > tools > options > export options > selected excel > (selected first 4 otions) side sheet names i have given x,y,z.

hope give any suggestions what to do.

vinodkumar071791's picture
Joined: Mar 22 2021 - 12:18am
Last seen: 1 month 1 week ago

1 Answer:

0

Page Properties add these Properties

net.sf.jasperreports.export.xls.one.page.per.sheet

value =>true

net.sf.jasperreports.export.xls.sheet.names.all
value #X/Y/Z

shreekrishna.shankhwar's picture
Joined: Mar 26 2021 - 12:50am
Last seen: 1 month 2 weeks ago
Feedback