ExcelFast is a PowerShell module designed to quickly import, export, and modify Excel and CSV workbooks.
This is an alpha work-in-progress!
#Import a worksheet
$data = Import-Workbook path/to/excel.xlsx
#Import only a few rows in a worksheet, note this is very fast expecially in a large workbook
$data = Import-Workbook path/to/excel.xlsx | Select -First 3
#Open a workbook for editing
$worksheet = Open-Workbook path/to/excel.xlsx
$worksheet.<tab> #Note there is full intellisense in vscode and excel
Save-Workbook $worksheet
#Export data
$data | Export-Workbook path/to/newexcel.xlsx| Alias | Command |
|---|---|
| exwb | Export-Workbook |
| imwb | Import-Workbook |
| owb | Open-Workbook |
| svwb | Save-Workbook |
Want to contribute? Check out the Development Documentation