Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Importing excel file with multiple sheets from Sharepoing

  Hello everyone,   Senario: There is an excel file in sharepoint contanting some test results. Everyday test data gets changed and a new file is saved in the sharepoint folder with the date. (Fil...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi , Anonymous 

    I know it's stupid but it works (I'm actually not good at this issue)

    Here is the method I try if I understand your question correctly:

    step1. copy the query first

     

    step2. click the buttom "combine  files" in query 1

     

    （If there is an error, please ignore it,  click "close & apply" to close "Edit Queries" and enter again.)

     

    It will show as below:

     

    step3.Do the similar steps as the step2 ( click the buttom "combine  files" in query 2)

     

    it will show as below:

     

     

     

    Hope others can come up with better suggestions.

     

    Best Regards,
    Community Support Team _ Eason

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I tried it but it is combining both the sheets in one table. So instead of getting two separate tables I am getting one merged table

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi , Anonymous 

I know it's stupid but it works (I'm actually not good at this issue)

Here is the method I try if I understand your question correctly:

step1. copy the query first

 

step2. click the buttom "combine  files" in query 1

 

（If there is an error, please ignore it,  click "close & apply" to close "Edit Queries" and enter again.)

 

It will show as below:

 

step3.Do the similar steps as the step2 ( click the buttom "combine  files" in query 2)

 

it will show as below:

 

 

 

Hope others can come up with better suggestions.

 

Best Regards,
Community Support Team _ Eason