• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » tfileInputExcel with excel2007 format read issue

#1 2012-03-19 18:05:19

srividya
New member
Registered: 2011-06-20
Posts: 5

tfileInputExcel with excel2007 format read issue

hi there,

Is there a limit on tfileinputexcel on number records to be read?
i have 170000 records to be read from xlsx and even after increasing memory job is failing with - OutofMemoryError.

tfileinputexcel is the first component of my job. Any help?

Memory specified - 5gb

Thanks,
Srividya

Last edited by srividya (2012-03-20 11:06:24)

Offline

#2 2012-03-21 07:25:17

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: tfileInputExcel with excel2007 format read issue

Hi

You can increase the values in the following image.

Regards,
Pedro


Uploaded Images


Only Paranoid Survive.

Offline

#3 2012-03-27 11:02:07

slenk
Member
Registered: 2010-09-03
Posts: 70
Website

Re: tfileInputExcel with excel2007 format read issue

Hi.
I would rather save the *.xls/-x as *.csv and process it with tFileInputDelimited. Why? Have a look at the number of rows processed - you will be 4+ times faster.
HTH


Talend - simply great!!!

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » tfileInputExcel with excel2007 format read issue

Board footer

Powered by FluxBB