topic Re: Excel preprocessing in Talend Studio

Excel preprocessing

saivsr — Sat, 16 Nov 2024 08:02:21 GMT

Hi all,

I have one requirement..I have 3 excel files

All excel files sheets has same metadata

First excel has 3 sheets

Each sheet has Head position in 1 first row and data has some empty rows

Second excel has 5 sheets

Each sheet has Head position in 10th line , data has some empty line and up to 10th line empty rows

3 excel file has 10 sheets
Each sheet has head position in 20th line ,data has some empty line and up to 20th line empty rows

I want do some preprocess for removing empty rows and I need to save save files as it is without empty rows.

Pls suggest or give solution thanks

Re: Excel preprocessing

fdenis — Tue, 26 Jun 2018 14:21:34 GMT

first you cannot read and write an excel in the same time.
copy your file first clean data.
on talend open the original file for each sheet Use Append to keep header and fill data(select the pose of the first row) filter on empty row.
Done

! excel nead a lot of memory !

Re: Excel preprocessing

saivsr — Wed, 27 Jun 2018 08:38:44 GMT

Thanks fdenis