Forum Discussion

Sab's avatar
Sab
Helper V
7 years ago
Solved

Get data from multiple Excel file having multiple Worksheets

Hello, I know how to get data from multiple workbooks and also from multiple worksheets WITHIN ONE workbook. But I cannot do that when there are multiple excel files with multiple worksheets...   ...
Need Help
  • Sab's avatar
    Sab
    7 years ago

    Thank you for your replies. 

     

    The problem is a bit more complicated than in the example from the video because sheets contain Pivoted data with dates in column headers, and every file/sheet has different Dates (cloumn headers), therefore I cannot use the first row of any of the sheets as header. 

     

    Still trying to figure out a solution with Functions and parameters...

     

    :( :( :(

  • Sab's avatar
    Sab
    7 years ago

    Hi,

     

    I solved this problem by creating two parameters, one that holds file name and the other one that holds sheetname. Lots of effort on this one but it was worth because I learned some interesting stuff.

     

    thanks again

    Sab

ImkeF's avatar
ImkeF
Community Champion
7 years ago

Could it be that the parameter in your function is ignored?

Sab's avatar
Sab
Helper V
7 years ago

Thank you for your replies. 

 

The problem is a bit more complicated than in the example from the video because sheets contain Pivoted data with dates in column headers, and every file/sheet has different Dates (cloumn headers), therefore I cannot use the first row of any of the sheets as header. 

 

Still trying to figure out a solution with Functions and parameters...

 

:( :( :(

  • Sab's avatar
    Sab
    Helper V
    7 years ago

    Hi,

     

    I solved this problem by creating two parameters, one that holds file name and the other one that holds sheetname. Lots of effort on this one but it was worth because I learned some interesting stuff.

     

    thanks again

    Sab