PowerShell module to import/export Excel spreadsheets, without Excel. Check out the How To Videos https://www.youtube.com/watch?v=U3Ne_yX4tYo&list=PL5uoqS92stXioZw-u-ze_NtvSo0k0K0kq

Work with Excel without installing Excel

A single lightweight powershell module with cmdlets to query/update databases with any .net provider: SQL/OLEDB/ODBC/...

Support for querying SQL Server, SQlite and ODBC sources.

Little project to create Excel files without Microsoft Excel being installed.

Simple project generating Active Directory, AWS, Office 365 (Exchange, Azure AD) documentation to Microsoft Word, Microsoft Excel and Microsoft SQL. More things to follow...

CData Cmdlets for Microsoft Excel

CData Cmdlets for Microsoft SharePoint Excel

CData Cmdlets for Microsoft Excel Online

Powershell Module for Excel Automation

Sorlov PowerShell Utilities

Simple project generating Excel Workbooks/Worksheets

Use Excel file as BDD feature file, get example list and testcase list from excel file

PowerShell module to import Excel spreadsheets, without Excel. Creates a PowerShell Object from an imported Excel spreadsheet.

Compare two excel files. and support git diff, for example: git diff theChangedExcelFile. The git diff config is needed, which is described in the below online version link. It provides great supports to ExcelBDD to check changes in excel file.

Module takes all excel files in given directory and push the content to database.

ConvertTo-DataRange converts tables in all sheets of an Excel workbook to data ranges, and then saves the changes. The path to the workbook to convert is supplied to the Path parameter. Workbooks with tables cannot be shared, so this command is useful in preparing a workbook to be shared.

Write to Excel daily tasks

A module of functions for Ado, OleDb, Dbase and FoxPro

Reading an Excel Xlsx file and convert a csv file to Excel Xlsx format