tFileExcelSheetOutput and tFileExcelWorrkBookSave

One Star

tFileExcelSheetOutput and tFileExcelWorrkBookSave

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

Moderator

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

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

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

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
Moderator

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Moderator

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

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




--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

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.
Moderator

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

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
One Star

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

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

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

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
One Star

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

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
Seventeen Stars

Re: tFileExcelSheetOutput and tFileExcelWorrkBookSave

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. 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog