ImportExcel is a PowerShell module that enables you to import, export, read, write, and manipulate Excel spreadsheets (including creating charts, pivot tables, styling, etc.) without needing Microsoft Excel to be installed. It uses .NET libraries to handle Excel file formats (e.g. XLSX), allowing automation and reporting workflows in PowerShell across platforms.
Features
- Read Excel files into PowerShell objects (arrays etc.) for further manipulation
- Export data to Excel files (.xlsx), creating tables automatically from PowerShell data sources (CSV, JSON, databases etc.)
- Create charts and pivot tables inside Excel spreadsheets automatically
- Cross-platform support: works on Windows, macOS, Linux under PowerShell Core/7+
- Styling and formatting: can specify column widths, cell formatting, conditional formatting etc.
- Large example collection, good documentation and frequently updated module with versions etc.
Categories
SpreadsheetLicense
Apache License V2.0Follow ImportExcel
nel_h2
Enterprise-grade ITSM, for every business
Freshservice is an intuitive, AI-powered platform that helps IT, operations, and business teams deliver exceptional service without the usual complexity. Automate repetitive tasks, resolve issues faster, and provide seamless support across the organization. From managing incidents and assets to driving smarter decisions, Freshservice makes it easy to stay efficient and scale with confidence.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of ImportExcel!