# Read and Import Excel Data

Read worksheets, ranges, tables, and typed rows from existing workbooks without requiring Microsoft Excel.

Use `Import-OfficeExcel` when the workbook is a data source. Use `Open-OfficeExcel` and the targeted inspection commands when workbook structure, formatting, formulas, validation, charts, or metadata matter.

## Import rows

```powershell
$rows = Import-OfficeExcel -Path '.\Input\Register.xlsx' `
    -Sheet 'Services' -Range 'A1:D500'
$atRisk = $rows | Where-Object Status -eq 'At risk'
```

A wildcard `-Sheet` reads several worksheets and adds sheet identity to each result. `-As Hashtable`, `-As DataTable`, `-As DataReader` and `-As Column` return other shapes for different downstream consumers. `-As DataReader` reads one worksheet at a time, so pick a single `-Sheet`, and the caller disposes the reader it returns. Range and row/column bounds keep large imports intentional.

## Inspect workbook structure

Use `Get-OfficeDocumentInfo -Detailed` for a workbook-level inventory, then query tables, named ranges, formulas, comments, validation, pivots, worksheet views, page breaks, links, queries, and rich text only when needed.

The [read-and-filter recipe](https://github.com/EvotecIT/OfficeIMO/blob/3b680b1b6fb15a268ff5525a4ca6cdd70b2f6613/PowerShell/PSWriteOffice/Examples/Excel/Recipe-Excel-ReadAndFilter.ps1) creates a table, imports typed rows, and filters the records that require attention.

For semicolon-delimited or other text data, continue with [delimited import and publishing](/docs/pswriteoffice/excel-export-publish/).

<!-- PowerForge markdown source sha256:A5662CBF2B930EE06DE7FBA8F3EC0446C4CCAE9224BC58C71B791539BF989430; title=True -->

<!-- PowerForge markdown artifact sha256:340ADB5B599B136D9B741931718AB782E51F2F2FBFD21AABEA6BDF4392A8B065 -->
