Could you please suggest me a method for this situation

Background
I collect some data from multiple sources; based on which I have to
prepare a comprehensive
excel report which needs to be forwarded to multi-stake holders.
I have a formula based Excel template in which I feed the data and
generate a report.
I am trying to automate this process in linux environment using perl

Current solution:
I have split my excel file into two, 1. this file contains all the
formulas and the final summary report(based on formulas) 2. I use
Spreadsheet::WriteExcel to prepare the all the collected data in excel
format in multiple sheets. The first file formulas refer to the second
file data to get the final report.

Problem
Is there any way of preparing a excel report by preserving the
formulas from the template and simply adding the data in certain
sections of a given template? I would like to have a single file
report to be sent across

regards
Srisurya