Forum Discussion

srikotla's avatar
srikotla
New Contributor
7 years ago

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

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

  • christwr's avatar
    christwr
    Contributor III
    6 years ago

    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's avatar
    lingared
    New Contributor
    3 years ago

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

  • mkoperni's avatar
    mkoperni
    New Contributor
    2 years ago

    I have a similar use case where I need to insert data starting in row 6 of an Excel template file generated from Workday.  I need to preserve the formatting of the header rows in row 1-5.  I am able to read the Excel and then populate an output file by parsing the Excel input file , union of data and then the Excel multi sheet formatter to write the output.  The formatting is lost on those headers and I am told it needs to be retained.

  • Sandhya's avatar
    Sandhya
    New Contributor
    2 years ago

    Hi,

    Can you try giving start row as 6 in the excel parser.

    Thanks

    Sandhya