Look smarter: deliver your work in Excel
summary
A PowerShell module wraps the EPPlus DLL wrapper to read and write .xlsx files without needing Excel, and it records about 200,000+ downloads. Version 6 gains roughly a 10x export speed improvement by reducing per-cell function overhead. It creates pivot tables and charts, applies conditional formatting, diffs and merges spreadsheets, runs in Cloud Shell/PowerShell Core with a small casing hiccup, and is used to audit DSC/Pester results and drive VM builds from spreadsheets.
AI-written summary · about
chapters (11)
- 0:00ImportExcel module intro
- 3:58Why ImportExcel was created
- 11:06Goals behind ImportExcel
- 21:51Basic Export-Excel usage
- 25:07Data types and formatting
- 30:31SQL data with Export-Excel
- 35:03Performance tips and pivot tables
- 43:41Code quality analysis
- 46:28Comparing spreadsheets
- 50:08Merging network spreadsheets
- 52:03Final tips and closing
related talks
58mProductivity Revolution in Excel
01h 01mHow to Create Value and Present Data to Business Executives in SharePoint
40mSource Control and Continuous Deployment... for a Spreadsheet?!
16mEXCELsioR!
43mPowerShell Tooling
55mOffice as Your BI Platform
48mCombine Power BI with External Tools
08mOffice Extensibility Overview