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

[srikotla]

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.

[myuncle]

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

[dmiller]

Have you looked at the Head Snap?

[christwr]

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]

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