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=Get-Workbook path/to/excel.xlsx
$worksheet.<tab>#Note there is full intellisense in vscode and excelSave-Workbook$worksheet#Export data$data|Export-Workbook path/to/newexcel.xlsx| Alias | Command |
|---|---|
| exwb | Export-Workbook |
| imwb | Import-Workbook |
| gwb | Get-Workbook |
| svwb | Save-Workbook |
Want to contribute? Check out the Development Documentation