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.

[mkoperni]

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]

Hi,

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

Thanks

Sandhya