{"repo":"dfinke/ImportExcel","free":true,"listed":false,"github":"https://github.com/dfinke/ImportExcel","clone":"git clone https://github.com/dfinke/ImportExcel.git","description":"PowerShell module to import/export Excel spreadsheets, without Excel","language":"PowerShell","stars":2732,"topics":["powershell","excel"],"license":"Apache-2.0","category":"workflow-automation","readme_excerpt":"PowerShell and Excel Has the ImportExcel module helped you? - Made you look good to the boss? - Saved you time? - Made you more productive? Consider donating. Thank you! Overview Automate Excel with PowerShell without having Excel installed. Works on Windows, Linux and Mac. Creating Tables, Pivot Tables, Charts and much more just got a lot easier. Examples ✨ Check out the more than 100 examples on ways to create amazing reports as well as make you more productive with PowerShell and Excel. Basic Usage Installation Create a spreadsheet Here is a quick example that will create spreadsheet file from CSV data. Works with JSON, Databases, and more. Read a spreadsheet Quickly read a spreadsheet document into a PowerShell array. Add a chart to spreadsheet Chart generation is as easy as 123. Building charts based on data in your worksheet doesn't get any easier. Plus, it is automated and repeatable. Add a pivot table to spreadsheet Categorize, sort, filter, and summarize any amount data with pivot tables. Then add charts. Convert Excel data to other formats Create a separate CSV file for each Excel sheet Do you have an Excel file with multiple sheets and you need to convert each sheet to CSV file? Problem Solved The yearlyRetailSales.xlsx has 12 sheets of retail data for the year. This single line of PowerShell converts any number of sheets in an Excel workbook to separate CSV files. Additional Resources Videos - Export-Excel Hello World - Make Excel Data Pop - Slice And Dice Data - ","default_branch":null,"files":null,"tree":[],"storefront":"/r/dfinke","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/dfinke/ImportExcel/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}