Excel preprocessing

Five Stars

Excel preprocessing

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


Accepted Solutions
Eleven Stars

Re: Excel preprocessing

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 !

Francois Denis

Tag as "solved" for others! Kudos to thanks!


All Replies
Eleven Stars

Re: Excel preprocessing

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 !

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Five Stars

Re: Excel preprocessing

Thanks fdenis