Error: "Data found beyond specified range"

Been having some trouble with writing to specific cells lately, so I created a super simple workflow with just an input and an output to test it.

I'm attaching below the workflow along with the output that it's writing to. I have defined 2 named ranges in the excel sheet

Title1 which is A1:D1 and Title2 which is A2:D2. For whatever erason, title2 range works whereas title1 range1 doesn't, says there's "data beyond the specified range", when there isn't. Can someone help me understand why this happens?

Additionally, when configuring the output tool to "skip field names" (which is very useful) it always breaks the excel file and shifts data down and also misses the last record of data. Any help with that?

Alteryx.zip

Workflow

Accepted answers

fmvizcaino

@AkisM ,

If you want to skip names and also preserve formatting, that is a known bug.

But you can preserve your formatted excel without breaking it if you keep your field names as well.

Then I suggest you to use a excel macro triggered by excel opening to format only the header while the bug is not fixed.

https://support.office.com/en-us/article/automatically-run-a-macro-when-opening-a-workbook-1e55959b-e077-4c88-a696-c3017600db44

New Alteryx Workflow.yxmd

All comments

fmvizcaino

Hi @AkisM ,

For that to work, you need to be careful with your range, meaning that you have to specify a row size that contains all data from your dataset. Since you have 5 rows, you need to use A2:D6.

Also, if you want to skip the header, you will need to modify your range to start one line below, A3:D6

Best,

Fernando Vizcaino

New Alteryx Workflow.yxmd

AkisM

Hi @fmvizcaino , thanks for the help. However have you tried replicating the solution you are suggesting? The excel still breaks if I try to skip field name and output to A3:D6 as you suggested

fmvizcaino

Hi @AkisM ,

Yes, I've replicated the solution. I just forgot to talk a little about the breakage.

That is something that happens to me frequently but not always and I'm almost sure it is a bug, but it is not present in the known issues in release notes, so maybe I'm mistaken.

https://help.alteryx.com/release-notes/designer/designer-20201-release-notes

Best,

Fernando Vizcaino

Doug_B

Thank you for asking your question. I have had nothing but trouble trying to preserve Excel formatting. I have never gotten it to work. Generally all I want to do is skip the header, and dump my results into the lines following the header, regardless of range.

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235