Modify already created .xlsx file (send bean data to write to excel)

0

HI all,

i want to ask about a question regarding the title.

let's say i have a .xlsx file, already filled wih formulae and chart is prepared, but i want the data to be dynamic here, so the chart shown will change according to data sent

i already created a function to generate .xlsx file and send data to it, but can't write data to existing .xlsx file as it will always being replaced by the generated one.

is this possible with jasper java api?

thanks

gentur_1's picture
Joined: Jul 18 2016 - 1:18am
Last seen: 3 years 3 months ago

2 Answers:

2

The way I do is in reverse. I just have Excel VBA script to get data from JasperReports Server via REST API to update my sheet.

hozawa's picture
52592
Joined: Apr 24 2010 - 4:31pm
Last seen: 5 months 1 week ago
0

hi Mr. Hozawa, thanks for the insight!

can you please describe a step by step to accomplish that?

thanks in advance

 

gentur_1's picture
Joined: Jul 18 2016 - 1:18am
Last seen: 3 years 3 months ago
Feedback