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?
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.
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