Table of contents
TOC
Collapse the table of content
Expand the table of content

Excel.Workbook

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

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

About

Returns a table representing sheets in the given excel workbook.

Arguments

ArgumentDescription
workbookThe workbook to retrieve the sheets for.
optional useHeadersUse the first row of the excel sheets as table headers.

Example

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
© 2018 Microsoft