Hello,
I have been using Talend for some time now, but this is an issue I could not figure a solution for.
I need to produce Excel reports on a regular basis where data is presented in pivot tables and charts.
For some time I used Hugo's Excel component -- Thank you, Hugo. In fact, I discovered and corrected and error and sent the correction to Hugo a couple of years ago, but it is not sufficient anymore and I lack the expertise to rewrite the whole component.
Recently I discovered Jan Lolling's set of components and I love them -- a big thank you, Jan.
With the improved behavior of tables within an Excel sheet in recent versions (pretty much since the new xlsx format appeared it makes the most sense to dump data into an existing table in a template file and make the related pivots and charts refresh. This is because of the dynamic re
I have not been able to do this without manual intervention, i.e. actually opening the files and copy/pasting the data into the target table. Of course, this is not preferred.
The solution might be in front of my eyes, but I cannot see it. Does anyone have any ideas?
P.S. Jan: when I am in Germany next time I should swing near your hometown and invite you to have some bier, or whatever your preferred beverage may be...