[resolved] Graph on Excel disappeard when i run my job

[Anonymous]

Welcome everybody,
here is my job:



the problem is when i run my job, my Excel file is update, so we can see in my Excel a table with data but my graph that i create before in the same Excel disappear.

Is there anyone who can help me please?

[Anonymous]

Hi,
Did you select "Append existing file" check box in tfileoutputexcle component to add the new lines at the end of the file and select "Append existing sheet" check box to add the new lines at the end of the Excel sheet?
Best regards
Sabrina

[Anonymous]

hi,
I check "Append existing file" and "append existing sheet", but the graph is not update because the new data are in a new line so they are not in the data range

[Anonymous]

Hi,
Would you mind posting your actual output excel file screenshots into forum? What does the expected result looks like? Elaborating your case with an example will be preferred.
Best regards
Sabrina

[Anonymous]

This cannot work. A graph will only apply new data if the data are part of a so called table. If suggest you create a table and write into this table.
With the build-in Excel components you have to take care the number of rows are exactly the same as you have designed the table before because it needs more than simply writing rows in a table to update the table. 
I suggest you choose the components tFileExcelSheetOutput to do this job. In this component suite you can open a excel file (containing your graph based on a table) and you can write into it and there is an option to setup any table you have written in. The component does everything automatically.
https://exchange.talend.com/#marketplaceproductoverview:gallery=marketplace%252F1&pi=marketplace%252...
Please take a look at the documentation. The use case writing in tables is described as well as updating pivots (works in the same way as charts).

[Anonymous]

this is my Excel file

[Anonymous]

We cannot see your excel file. I guess such kind if attachments are not allowed here. But as I have already described, with the build-in components you have no chance to solve your use case.

[Anonymous]

 So if i use tFileExcelSheetOutput it means that i have to download tFileExcelWorkbookOpen

[Anonymous]

Yes. Open your template file within tFileExcelWorkbookOpen (or simply create a new empty one) and write your result excel file with tFileExcelWorkbookSave.
And between both you can read / write in the excel workbook as you like.
It is pretty much the same way as you would do in excel itself.

[Anonymous]

i find tFileExcelWorkbookSave in Talend exchange but i can't find tFileExcelWorkbookOpen