I have use case of writing few specific columns in an existing excel template. My excel template contains formulas which needs to be evaluated once I dump records in the needed columns. I am using custom component tFileExcelSheetutput built by Jon. I am using the "use individual column positions" for now.
Now what I find is that writing only 5 columns in an existing excel template which contains around 200 columns is quite CPU and memory consuming. I was thinking to save my excel template along with the formulas into MySQL DB and then dump the data into a new excel. any views on this ? However, I am unable to read the formulas from the template and what is receive is values resolved by those formulas.
