Excel template output error

[SKRJALA1]

Hi!

I am trying to output my data into an existing excel template but keep getting the error " Encountered existing data beyond the specified range"

It works perfectly when I output it to a blank sheet, but it does not seem to work when there's other data in the sheet. I tried without skipping field names as well.

Help please?

range Y5-AM5

[chuckleswk]

This looks to be because you are trying to output a column name called "Full amount" that doesn't appear to be a column in your sheet that you are attempting to append to. Try putting a select before your output and de-selecting the Field titled "Full amount" and see if that works.

[SKRJALA1]

I renamed it to "Debit Amount," I also tried deselecting it, but am still getting the error:

[Robin_McIntosh]

If you have 15 columns in the named range of the Excel file, then you can only output 15 or fewer columns.  If you try to output 16 or more, you get the out of range error.  Same goes for rows if your range is a table in Excel.

[SKRJALA1]

I have exactly 15 columns, which is exactly the range specified Y5-AM5

[Tyro_abc]

Hi 

Try the following option, and please let me know if it works or not.

Regards

Tyro_abc 

[Robin_McIntosh]

@SKRJALA1 Are you able to upload the workflow and/or Excel file with just sample data?  I recreated the s/s based on your screenshot and exported to it with no issues.