cancel
Showing results for 
Search instead for 
Did you mean: 

Can Excel Formatter Insert Data at an Offset (Column or Row)?

rgoerwit
New Contributor II

I have a requirement, that I insert data into a series of sheets in an Excel workbook - and the sheets are not blank.

Is there a way to tell the Excel formatters (would love to use the multi-sheet formatter for this) to start inserting at a particular row, or better yet, a cell?

I see some folks have asked for something similar, Anyone aware on how to insert the data into excel file from a specific line number (in excel sheet)?...

If this is not possible, I am new, and I wonder: What is the best way to request this feature? It seems to come up periodically in various forms.

4 REPLIES 4

dmiller
Former Employee

This functionality is currently not available.
Please submit an enhancement request through you CSM or Support.


Diane Miller

rgoerwit
New Contributor II

My institution has submitted the enhancement request. Crossing fingers.

vgautam64
New Contributor III

Did you happen to find a way to offset specific number of rows?

If you know the exact row number where the Excel should start, than you can simply use a filter with the following expression:

snap.in.totalCount > (rowNumber)