Modify already created .xlsx file (send bean data to write to excel)
Posted on July 25, 2016 at 10:03pm
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
Joined: Jul 18 2016 - 1:18am
Last seen: 6 years 10 months ago
Posted on July 26, 2016 at 6:35pm
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.
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 11 months ago
Posted on July 27, 2016 at 8:30pm
hi Mr. Hozawa, thanks for the insight!
can you please describe a step by step to accomplish that?
thanks in advance
Joined: Jul 18 2016 - 1:18am
Last seen: 6 years 10 months ago