Excel preprocessing

[saivsr]

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

[fdenis · Accepted solution]

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 !

[saivsr]

Thanks fdenis