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.
| Argument | Description |
|---|---|
| workbook | The workbook to retrieve the sheets for. |
| optional useHeaders | Use 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
| CustomerID | Name | Phone |
|---|---|---|
| 1 | Bob | 123-4567 |
| 2 | Jim | 987-6543 |
| 3 | Paul | 543-7890 |
| 4 | Ringo | 232-1550 |
Show: