Automate Excel with only powershell?

This page summarizes the projects mentioned and recommended in the original post on /r/PowerShell

Our great sponsors
  • Onboard AI - Learn any GitHub repo in 59 seconds
  • InfluxDB - Collect and Analyze Billions of Data Points in Real Time
  • SaaSHub - Software Alternatives and Reviews
  • ImportExcel

    PowerShell module to import/export Excel spreadsheets, without Excel

  • EPPlus

    Like others, I recommend using the ImportExcel module. It uses and wraps EPPlus Software (EPPlus - Create advanced Excel spreadsheets using .NET (GitHub Project Old / New)) which is a DLL that is included with the ImportExcel PowerShell Module.

  • Onboard AI

    Learn any GitHub repo in 59 seconds. Onboard AI learns any GitHub repo in minutes and lets you chat with it to locate functionality, understand different parts, and generate new code. Use it for free at www.getonboard.dev.

  • EPPlus

    EPPlus-Excel spreadsheets for .NET (by EPPlusSoftware)

    Like others, I recommend using the ImportExcel module. It uses and wraps EPPlus Software (EPPlus - Create advanced Excel spreadsheets using .NET (GitHub Project Old / New)) which is a DLL that is included with the ImportExcel PowerShell Module.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts