Import Data from Specific Excel Cell

[kgordish]

Hello,

Almost feel silly asking this question.

Currently, working with an Excel sheet with multiple sheets. 

I want to bring the date and project name into the workflow from a "summary" sheet. 
The Excel file is a template and always the same. 

Thus, I want to bring in data specifically from B2 and B10 from the "Summary" sheet.

Can someone advise on a best practice to accomplish this?

Thanks

Kevin 

[Thableaus · Accepted solution]

Hi @kgordish 

You can specify the range with your Input Data Tool.

Ex:

C:\Users\folder\file.xlsx|||'Sheet1$B2:B10'

Cheers,

[BrianR]

I think one of the easiest ways to do this is to use Excel Named Ranges...take a look at this article on how to call the Named Range, which you will define as your Date and Project Name cells - 

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets-or-a-Spe...

Brian

[kgordish]

The "How to input from a specific excel range" looks like it addresses my situation.

Currently working with files with different schemas and have a macro set up to bring files in one at a time.

But since the summary slide is fixed, looks like that might work.

Thank you.

[kgordish · Accepted solution]

I ended coming up with an alternative solution.

1. Imported sheet

2. Filtered out non-necessary columns

3. Assigned ID numbers

4. Filtered by ID Numbers

5. Assigned Second ID Number afterwards (since I had only one row of data)

6. Multi-Join using Secondary ID

This allowed me to capture data from 4 distinct cells in a template form, not conducive to easy data importation.