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

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Ten 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

Don't forget to tag when it's "solved"!

2 REPLIES
Ten 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

Don't forget to tag when it's "solved"!

Five Stars

Re: Excel preprocessing

Thanks fdenis