Pull the data from MSSQL database and load it in Excel file

[Anonymous]

Hello,

My task is to pull the data from MSSQL database and load it in a particular sheet of Excel file. This Excel file is having more than 10 sheets. When i tried to load the data using tfileoutputexcel, i am able to do it but the header in the existing sheet of a excel file and other sheets are getting lost. I have posted many queries regarding this in Talend community but no proper answer from anyone. Is it possible to reach Talend Admin thru Call? I want to know whether its possible in Talend or not.

[manodwhb]

@samisyed80,have you ticked Include Header in Basic settings of tFileOutputExcel?

[Anonymous]

Thanks Manohar for replying back. I have tried this, but its pulling only that input tables header but I want the header which is there in the excel file. Also, other sheets are getting lost. Its a xlsx file with some macro codings in it. Yes, i have used tFileOutputExcel

[manodwhb]

@samisyed80,Did you ticked Append existing file in Basic settings of tFileOutputExcel?

[Anonymous]

Yes, i have tried append existing file option too. Still, the same erroneous result 

[manodwhb]

@samisyed80,if you want to append data into the existing sheet means you have to follow below setting and working fine.

[Anonymous]

Before going to the main question. I am facing an issue when i select "Write excel2007 file format (xlsx)" option. The entire system gets hanged. Please help me with this.

Secondly, i have given the settings like you gave. Other sheets are gone missing. Did you faced the similar issue when you did a test run?

[manodwhb]

@samisyed80,i am not at all faciing the issue wih when i select "Write excel2007 file format (xlsx)" option. it could your hardware issue.

I have not faced any issue and the data was appending to the existing sheet and not removing Headers also.

if you need job export please let me know.

[Anonymous]

Yes please , i need job export. 

Also, can you tell me the size you are using in Xmx and Xms

I have also used tMap in between as i need to shrink the column names in the output excel.

[manodwhb]

@samisyed80,please find the attached export. and i have used below allocation.

-Xms512m
-Xmx1536m

testJamal.zip