You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » Read excel by column
Post a reply
Topic review (newest first)
- avdbrink
- 2012-03-08 14:36:53
Hi,
Sorry for that 
About my custom component: I haven't uploaded it, because it is still work in progress. I hope it will be finished soon, but no guarantee whatsoever 
Regards,
Arno
- pellegrino
- 2012-03-08 12:30:36
avdbrink wrote:
Hi,
No perfect solution (yet), maybe the Dynamic schema functions in the commercial version of DI are able to do the job here?
I'm currently working on another solution that can read an excel file with an unknown number of rows/columns but this component reads values cell by cell, converting them into key/value pairs, I don't think this meets your requirements.
Regards,
Arno
maybe.. but i'm poor
did you uploaded that component in talend forge? maybe can help me..
- avdbrink
- 2012-03-07 10:44:18
Hi,
No perfect solution (yet), maybe the Dynamic schema functions in the commercial version of DI are able to do the job here?
I'm currently working on another solution that can read an excel file with an unknown number of rows/columns but this component reads values cell by cell, converting them into key/value pairs, I don't think this meets your requirements.
Regards,
Arno
- pedro
- 2012-03-07 10:20:27
Hi
I come up with one workaround...
I want to get A column row by row and add each row into a string variable.
But as you say, you don't want to turn column to row for performance...
Does anyone have perfect solution?
Regards,
Pedro
- pellegrino
- 2012-03-06 12:01:37
Hi all!
i have to process an excel with multiple sheet and indefinite number of rows/columns (so, with a dynamic schema)
my informations are written by column
|A |B |C |...|n
1 |a1|b1|c1|...|n1
2 |a2|b2|c2|...|n2
3 |a3|b3|c3|...|n3
4 |a4|b4|c4|...|n4
... |...|... |...|...|...
n |an|bn|cn|...|nn
i wish to have the output flow a1 a2 a3 a4 an | b1 b2 b3 b4 bn| c1 c2 c3 c4 cn.......
is there a simple way to READ an EXCEL BY COLUMN? 
i just tryed to use Tturnrow (but is incompatiblewith TOS5.2) tnormalize and tPivotToColumnDelimited (but needs static schema)
furthermore, for my big files would be better directly read it by cloumn instead of processing the whole file for turn column to row..
is there some component able to do this job?
Thank you !