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.
@samisyed80,have you ticked Include Header in Basic settings of tFileOutputExcel?
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
@samisyed80,Did you ticked Append existing file in Basic settings of tFileOutputExcel?
@samisyed80,if you want to append data into the existing sheet means you have to follow below setting and working fine.
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?
@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.
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.
@samisyed80,please find the attached export. and i have used below allocation.
@samisyed80,please find the out file too.
When i tested with new excel (xlsx) then transmission is getting completed successfully. But, when i use the macro-ed xlsx file its throwing an error. Looks like there's some issue with the output file. What do you think?
Oops the new xlsx is throwing some error.
"The maximum number of Cell Styles was exceeded. You can define up to 64000 style in a .xlsx Workbook"
what could be this issue?
@samisyed80,mybe output having issue.
@samisyed80,what is existing output file extention?
existing output file extn is xlsx.... the test data output is also in xlsx.
It ran once without any issue, now its throwing error
if i click the "Append Existing file" or "Keep existing cell format" option in tfileoutputexcel then the graph run is getting hanged. May i know the reason? I am going to load a data to excel file which has more sheets. Please help me resolve this.
@samisyed80,is it possiable to share the excel file,which was not appending to you?
Thanks for your prompt response. Please find the attached file in which i am trying to load data from database.
When i opened this file for the first time, it shown me some error. Then i removed the first sheet which is problematic. Then i tried to upload the "Demographics" data from database. Though i got successful couple of time, but i am losing the other sheets and the top row information in "Demographics" sheet. Please help in this regard.
@samisyed80,yes i have recived but i am getting below error. i know that for this error java heap size need to be increase.
Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded
at org.openxmlformats.schemas.spreadsheetml.x2006.main.WorksheetDocument$Factory.parse(Unknown Source)
there was another communication i have created for this java heap size error. DId you deleted the first sheet which contains only story? if not then delete it and then try. It will run. I just want to know, these issues are due to excel or any other reason?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema