Read formulaes from Excel Sheet

diggi86 — Sat, 16 Nov 2024 01:47:42 GMT

Hi,

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.

Thanks

Re: Read formulaes from Excel Sheet

diggi86 — Tue, 28 Jul 2020 10:58:12 GMT

@Jan Lolling any help on this please

topic Read formulaes from Excel Sheet in Talend Studio

Read formulaes from Excel Sheet

Re: Read formulaes from Excel Sheet