You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Graphical Excel problem, append excel files with data
#1 2008-08-06 11:56:39
- fwalle
- Member
- Registered: 2008-08-01
- Posts: 50
Graphical Excel problem, append excel files with data
Hi,
I have an excel files with a header with COLORS (excel1.jpg) i want too keep and below this header i want to put my data.
The data is generated in a CSV one (out.jpg).
To keep the header I put ";" and " " in the first column.
But when run my job(job.jpg) i lost all my header and have the excel2.jpg
I think i haven't got the good way 
Thanks for your response.
(I'm using TOS: 2.4.0)
Offline
#2 2008-08-06 12:11:58
- fwalle
- Member
- Registered: 2008-08-01
- Posts: 50
Re: Graphical Excel problem, append excel files with data
I have also an error:
Starting job CDA_table at 12:06 06/08/2008.
[statistics] connecting to socket on port 3858
[statistics] connected
Exception in component tFileOutputExcel_2
java.lang.NullPointerException
at jxl.write.biff.File.write(File.java:130)
at jxl.biff.ConditionalFormat.write(ConditionalFormat.java:106)
at jxl.write.biff.SheetWriter.write(SheetWriter.java:566)
at jxl.write.biff.WritableSheetImpl.write(WritableSheetImpl.java:1408)
at jxl.write.biff.WritableWorkbookImpl.write(WritableWorkbookImpl.java:856)
at reprise_eiffel.cda_table_0_1.CDA_table.tFileInputDelimited_2Process(CDA_table.java:2286)
at reprise_eiffel.cda_table_0_1.CDA_table.runJobInTOS(CDA_table.java:2435)
at reprise_eiffel.cda_table_0_1.CDA_table.main(CDA_table.java:2323)
531 milliseconds
[statistics] disconnected
when my header excel file is empty every thing is ok ...
I have this erro when i copy past the 9 first line, I mean when I past the 8 first line all is ok but with the 9th the error come
Last edited by fwalle (2008-08-06 12:22:42)
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Graphical Excel problem, append excel files with data