tFileExcelSheetOutput and tFileExcelWorrkBookSave

[Anonymous]

When I download tFileExcelSheetOutput and tFileExcelWorrkBookSave, they are not available as a zip file but just some 11KB file. What am I missing ?

[Anonymous]

Hi,

Did you download custom component  tFileExcelSheetOutput from  TalendExchange:tFileExcelSheetOutput and  tFileExcelWorrkBookSave from  TalendExchange:tFileExcelWorkbookSave?
They are available as a zip file. Could you please check it again?
Best regards
Sabrina

[Anonymous]

Would you be able to email me those zip at chandreshmistry@yahoo.com

[_AnonymousUser]

Hi,
we are writing a customized header to excel file using tFileOutputExcel and after that appending rows getting transferred from a csv.
after 10,000 odd rows only we are getting heap space error(our requirement to append millions of rows), whereas without adding header if we transfer only the  rows its much more faster and no memory issue.
Is it a bug in talend, the way it is handling excel files using tFileOutputExcel?
our requirement here is to add a customized header against rows.
Is there any solution to this? pls suggest.


Thanks

[Anonymous]

Hi phansu,
I can send an email to you with those.zip files. Can you login Talend Exchange successfully? Is there any problem for your to access Talend Exchange?
Best regards
Sabrina

[Anonymous]

Hi jayanta,

Did you use some cache component, such as, tMap, tUniqRow and tSortRow in your work flow?
Have you already checked documents about :TalendHelpCenter:Could not reserve enough space for object heap and TalendHelpCenter:ExceptionoutOfMemory to increase your -Xmx Java VM parameter in run view?


Best regards
Sabrina

[Anonymous]

Yes, I am able to login to the exchange correctly, but I cannot re-download and downloaded components to see if they are a .zip file. Only tFileExcelWorBookOpen was showing up as a zip and I have that downloaded.

[Anonymous]

Hi  phansu,
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif] We have send an email to your [/font][/color] chandreshmistry@yahoo.com  with [color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif] tFileExcelSheetOutput and tFileExcelWorrkBookSave [/font][/color] zip files.
Could you please check it? Let us know if it is OK with you.


Best regards
Sabrina

[_AnonymousUser]

Hi,
We got the components implemented in our Job and running fine in window, but after exporting the job to Unix its getting error out with below error.
What could be the root cause for this. We have all supporting jars in lib folder available.
Please suggest on this.
Exception in thread "Thread-5" java.lang.Error: java.lang.Error: java.lang.Error: java.lang.Error: java.lang.Error: java.lang.Error: java.lang.Error: java.lang.NoSuchMethodError: javax/xml/stream/XMLEventFactory.newFactory()Ljavax/xml/stream/XMLEventFactory;
@at erecon_talend_svn.download_gn_nongn_job_0_1.Download_GN_NonGN_Job.tOracleConnection_1Process(Download_GN_NonGN_Job.java:4379)
@at erecon_talend_svn.download_gn_nongn_job_0_1.Download_GN_NonGN_Job.runJobInTOS(Download_GN_NonGN_Job.java:8197)
@at erecon_talend_svn.download_gn_nongn_job_0_1.Download_GN_NonGN_Job.runJob(Download_GN_NonGN_Job.java:7754)
@at erecon_talend_svn.download_gn_nongn_listner_0_1.Download_GN_NonGN_Listner$1tFixedFlowInput_1Thread.run(Download_GN_NonGN_Listner.java:4129)
@at routines.system.ThreadPoolWorker.runIt(TalendThreadPool.java:159)
@at routines.system.ThreadPoolWorker.runWork(TalendThreadPool.java:150)
@at routines.system.ThreadPoolWorker.access$0(TalendThreadPool.java:145)
@at routines.system.ThreadPoolWorker$1.run(TalendThreadPool.java:122)
@at java.lang.Thread.run(Thread.java:772)
Caused by: java.lang.Error: java.lang.Error: java.lang.Error: java.lang.Error: java.lang.Error: java.lang.Error: java.lang.NoSuchMethodError: javax/xml/stream/XMLEventFactory.newFactory()Ljavax/xml/stream/XMLEventFactory;
@at erecon_talend_svn.download_gn_nongn_job_0_1.Download_GN_NonGN_Job.tOracleConnection_2Process(Download_GN_NonGN_Job.java:4510)
@at erecon_talend_svn.download_gn_nongn_job_0_1.Download_GN_NonGN_Job.tOracleConnection_1Process(Download_GN_NonGN_Job.java:4365)
@... 8 more
Caused by: java.lang.Error: java.lang.Error: java.lang.Error: java.lang.Error: java.lang.Error: java.lang.NoSuchMethodError: javax/xml/stream/XMLEventFactory.newFactory()Ljavax/xml/stream/XMLEventFactory;
@at erecon_talend_svn.download_gn_nongn_job_0_1.Download_GN_NonGN_Job.tFixedFlowInput_1Process(Download_GN_NonGN_Job.java:6122)
@at erecon_talend_svn.download_gn_nongn_job_0_1.Download_GN_NonGN_Job.tOracleConnection_2Process(Download_GN_NonGN_Job.java:4502)
@... 9 more
Caused by: java.lang.Error: java.lang.Error: java.lang.Error: java.lang.Error: java.lang.NoSuchMethodError: javax/xml/stream/XMLEventFactory.newFactory()Ljavax/xml/stream/XMLEventFactory;
@at erecon_talend_svn.download_gn_nongn_job_0_1.Download_GN_NonGN_Job.tOracleInput_1Process(Download_GN_NonGN_Job.java:6810)
@at erecon_talend_svn.download_gn_nongn_job_0_1.Download_GN_NonGN_Job.tFixedFlowInput_1Process(Download_GN_NonGN_Job.java:6114)
@... 10 more
Caused by: java.lang.Error: java.lang.Error: java.lang.Error: java.lang.NoSuchMethodError: javax/xml/stream/XMLEventFactory.newFactory()Ljavax/xml/stream/XMLEventFactory;
@at erecon_talend_svn.download_gn_nongn_job_0_1.Download_GN_NonGN_Job.tJava_1Process(Download_GN_NonGN_Job.java:7064)
@at erecon_talend_svn.download_gn_nongn_job_0_1.Download_GN_NonGN_Job.tOracleInput_1Process(Download_GN_NonGN_Job.java:6802)
@... 11 more
Caused by: java.lang.Error: java.lang.Error: java.lang.NoSuchMethodError: javax/xml/stream/XMLEventFactory.newFactory()Ljavax/xml/stream/XMLEventFactory;
@at erecon_talend_svn.download_gn_nongn_job_0_1.Download_GN_NonGN_Job.tJava_2Process(Download_GN_NonGN_Job.java:7330)
@at erecon_talend_svn.download_gn_nongn_job_0_1.Download_GN_NonGN_Job.tJava_1Process(Download_GN_NonGN_Job.java:7056)
@... 12 more
Caused by: java.lang.Error: java.lang.NoSuchMethodError: javax/xml/stream/XMLEventFactory.newFactory()Ljavax/xml/stream/XMLEventFactory;
@at erecon_talend_svn.download_gn_nongn_job_0_1.Download_GN_NonGN_Job.tFileExcelWorkbookOpen_1Process(Download_GN_NonGN_Job.java:55461)
@at erecon_talend_svn.download_gn_nongn_job_0_1.Download_GN_NonGN_Job.tJava_2Process(Download_GN_NonGN_Job.java:7301)
@... 13 more
Caused by: java.lang.NoSuchMethodError: javax/xml/stream/XMLEventFactory.newFactory()Ljavax/xml/stream/XMLEventFactory;
@at org.apache.poi.openxml4j.opc.internal.marshallers.PackagePropertiesMarshaller.<clinit>(PackagePropertiesMarshaller.java:45)
@at java.lang.J9VMInternals.initializeImpl(Native Method)
@at java.lang.J9VMInternals.initialize(J9VMInternals.java:228)
@at java.lang.J9VMInternals.initialize(J9VMInternals.java:195)
@at org.apache.poi.openxml4j.opc.OPCPackage.init(OPCPackage.java:161)
@at org.apache.poi.openxml4j.opc.OPCPackage.<init>(OPCPackage.java:141)
@at org.apache.poi.openxml4j.opc.Package.<init>(Package.java:37)
@at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:87)
@at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:272)
@at org.apache.poi.util.PackageHelper.open(PackageHelper.java:37)
@at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:266)
@at de.cimt.talendcomp.tfileexcelpoi.SpreadsheetFile.initializeWorkbook(SpreadsheetFile.java:262)
@at erecon_talend_svn.download_gn_nongn_job_0_1.Download_GN_NonGN_Job.tFileExcelWorkbookOpen_1Process(Download_GN_NonGN_Job.java:55401)
@... 14 more


Thanks,
Jayanta

[_AnonymousUser]

Hi,
Can you suggest how to apply color formatting to cells in tFileExcelSheetOutput.
Thanks,
Jayanta