Talend community forum / Read excel by column

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 !

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

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

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

Announcement

Unanswered posts

#1 2012-03-06 12:01:37

Read excel by column

#2 2012-03-07 10:20:27

Re: Read excel by column

#3 2012-03-07 10:44:18

Re: Read excel by column

#4 2012-03-08 12:30:36

Re: Read excel by column

avdbrink wrote:

#5 2012-03-08 14:36:53

Re: Read excel by column

Board footer