Excel.Workbook

 

Excel.Workbook(workbook as binary, optional useHeaders as nullable logical, optional delayTypes as nullable logical) as table

Returns a table representing sheets in the given excel workbook.

ArgumentDescription
workbookThe workbook to retrieve the sheets for.
optional useHeadersUse the first row of the excel sheets as table headers.
Excel.Workbook(File.Contents("localExcelFile.xlsx"))  
  
      let  
  
    Source = Excel.Workbook(File.Contents("C:\Projects\Examples\Customers and Orders.xlsx"), true),  
  
    Customers_Sheet = Source{[Item="Customers",Kind="Sheet"]}[Data]  
  
in  
  
    Customers_Sheet  

CustomerIDNamePhone
1Bob123-4567
2Jim987-6543
3Paul543-7890
4Ringo232-1550
Show: