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

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: 6 years 10 months ago

2 Answers:

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
176469
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 11 months ago

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: 6 years 10 months ago
Feedback
randomness