community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!

Excel import Multiple sheets with a range

Meteoroid

Hi!!

How can I import 1 Excelfile with multiple sheets?
From every sheet I will import the range A7:W1000.

Thank a lot!

Cheers!

Gert-Jan

Meteoroid
I tried it with the help of this Blog (http://www.alteryx.com/community/blogs/engine-works/alteryx-reading-xlsx-directly) from Ned Harding, but I can still import 1 sheet!

Is there anyone you can help me with this??

Thanks!!

Gert-Jan Neeft
Alteryx Alumni (Retired)

Hi!

We actually have a Knowledgebase Article that does address your issue to a certain degree.  Essentially, this will work if you know the names of each of the tabs in your sheet.  The method, via the Dynamic Input tool, will bring in each sheet togehter as a single table.

Input multiple Excel Sheets or tabs at once

Hope that helps!

Thanks,
Paul

 

 
Labels