topic Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave in Talend Studio

tFileExcelSheetOutput and tFileExcelWorrkBookSave

Anonymous — Mon, 13 Jul 2015 18:46:04 GMT

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

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

Anonymous — Tue, 14 Jul 2015 03:18:44 GMT

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

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

Anonymous — Tue, 14 Jul 2015 15:59:53 GMT

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

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

_AnonymousUser — Wed, 15 Jul 2015 11:25:24 GMT

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

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

Anonymous — Wed, 15 Jul 2015 15:16:52 GMT

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

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

Anonymous — Wed, 15 Jul 2015 15:29:55 GMT

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

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

Anonymous — Wed, 15 Jul 2015 17:04:43 GMT

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.

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

Anonymous — Thu, 16 Jul 2015 04:46:20 GMT

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

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

_AnonymousUser — Tue, 21 Jul 2015 11:05:44 GMT

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

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

_AnonymousUser — Tue, 11 Aug 2015 13:22:49 GMT

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

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

Anonymous — Wed, 09 Sep 2015 13:04:06 GMT

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

Hi - did you look at the documentation??? It is described there: http://jan-lolling.de/talend/components/help/tFileExcelSheetOutput.pdf
Gábor

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

_AnonymousUser — Mon, 19 Oct 2015 12:15:02 GMT

Hi,
I am not able to put dynamic schema with tFileExcelSheetOutput/tFileOutputExcel.
Is there any way to do this?
Please suggest on this.
Thanks,
Jayanta

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

Anonymous — Thu, 22 Oct 2015 22:34:58 GMT

Dynamic schemas are only allowed to dedicated components especially enabled by Talend because the component must be on a list of components stored in a plugin in the studio. Thats why it is not an easy task to allow this.