topic Re: [resolved] Graph on Excel disappeard when i run my job in Talend Studio

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

Anonymous — Wed, 18 May 2016 09:31:43 GMT

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?

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

Anonymous — Wed, 18 May 2016 10:02:14 GMT

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

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

Anonymous — Wed, 18 May 2016 10:14:45 GMT

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

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

Anonymous — Wed, 18 May 2016 10:21:20 GMT

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

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

Anonymous — Wed, 18 May 2016 10:29:14 GMT

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%252F1%252Fproducts%252F541%252Fitems%252F2252
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).

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

Anonymous — Wed, 18 May 2016 10:32:29 GMT

this is my Excel file

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

Anonymous — Wed, 18 May 2016 10:36:16 GMT

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.

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

Anonymous — Wed, 18 May 2016 11:36:55 GMT

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

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

Anonymous — Wed, 18 May 2016 11:38:52 GMT

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.

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

Anonymous — Wed, 18 May 2016 11:44:58 GMT

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

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

Anonymous — Wed, 18 May 2016 11:48:37 GMT

i find it

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

Anonymous — Wed, 18 May 2016 12:46:16 GMT

I guess you have used the Exchange view in your studio. I strongly suggest to ignore that. It is not reliable. Use the web site!

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

Anonymous — Wed, 18 May 2016 13:55:21 GMT

I got a problem: i put the first component on the palette and when i want to put a second component the first one disappear

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

Anonymous — Wed, 18 May 2016 14:06:33 GMT

Take a look at this article:
https://help.talend.com/pages/viewpage.action?pageId=190513200
If you follow this way, it will work (usually 😉

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

Anonymous — Wed, 18 May 2016 14:53:07 GMT

I do the same as the web site but when i put a second component the first one do this (blue arrow)

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

Anonymous — Wed, 18 May 2016 14:56:21 GMT

blue arrow

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

Anonymous — Wed, 18 May 2016 15:27:35 GMT

i succeed to put the 3 new component in the palette i copy and paste the 3 folder in a new folder and i update this new folder in the palette

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

Anonymous — Wed, 18 May 2016 15:55:39 GMT

Strange. I usually have never problems in the Open Studio following the described way. We have sometimes problems in the enterprise environment...

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

Anonymous — Thu, 19 May 2016 14:36:27 GMT

i find a way to resolve my problem i check "append existing file" , "append existing sheet" and "Is absolute Y pos" and now it works
thanks for your help!!!

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

Anonymous — Mon, 23 May 2016 09:51:03 GMT

Hi,
Great it is fixed. Thanks for posting your solution here.
Best regards
Sabrina