In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Import data from specific position from excel file

Dave
8 - Asteroid

Hi all

 

Trying to import data from an Excel file into Alteryx. The range of data I want to import starts in Cell B15 (first header) and can finish in any cell after it (the file can be of varying size)

 

I've tried changing the input conditions as follows:

 

Dave_0-1644571282230.png

 

Ive tried adjusting like this

 

Dave_1-1644571336555.png

 

No matter what way I try it I get the following error:

 

Dave_2-1644571380341.png

 

There's no dynamic input at play, just a straight input from a defined single file.

 

When I amend the file by deleting the first 14 rows and the blank column, the data uploads fine, but I want to build a tool that will mean I wont need to do this prep

 

Any help would be appreciated

 

Dave

10 REPLIES 10
Dave
8 - Asteroid

I figured it out - I needed to enable editing on the target Excel sheet :)

 

Thank you so much for your help. Sounding it out got ne there 

Labels
Top Solution Authors