Import Data from Specific Excel Cell

Question

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 Answer

Hi @kgordish

You can specify the range with your Input Data Tool.

Ex:

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

Cheers,

kgordish · Accepted Answer

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.