cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Anyone aware on how to insert the data into excel file from a specific line number (in excel sheet)?

srikotla
New Contributor

Anyone aware on how to insert the data into excel file from a specific line number? My requirement is to insert/create the data in excel file from line number 6. From lines 1-5 I will have the header information.

We designed all pipelines to read the excel files from line #6, these excels were manually created. Now we want to automate the process of excel files creation and need to simulate the excel that was created manually using snaplogic.

Any help is appreciated.

6 REPLIES 6

myuncle
New Contributor

Hi. Did you ever figure out how to do this?

dmiller
Admin Admin
Admin

Have you looked at the Head Snap?


Diane Miller
Community Manager

christwr
Contributor III

If youโ€™re wanting all records after the 5th (6+) you might be able to put a filter snap after your Excel parser snap, with a criteria like snap.in.totalCount > 5. Not sure, but might be worth exploring.

lingared
New Contributor

Add null rows for first 5 records and then from there on use original data.