v7.7.0

What's Changed

• Set up gha ci/cd by @dfinke in #1198
• Update to Get-HTMLTable by @jhoneill in #1200
• Compare cells by @kkazala in #1202
• Fix -UnderLineType parameter is ignored in Set-ExcelColumn #1204 by @dfinke in #1206

New Contributors

• @kkazala made their first contribution in #1202

Full Changelog: v7.6.0...v7.7.0

v7.6.0

What's Changed

• [Under investigation] Fix -StartRow and -StartColumn being ignored.
• James O'Neill:
  • Update Get-HtmlTable to support to use PowerHTML (maintained by Justin Grote).
  • Added example to including a new function Import-ByColumn. Works like Import-Excel but with data in columns instead of the conventional rows.
• Update Import-HTML with better defaults
• Fixed example Get-ModuleStats.ps1 which reads the PowerShell Gallery page and extracts the stats table

Full Changelog: v7.5.3...v7.6.0

Readme updates. Exclude images and more when publishing

What's Changed

• Update read me by @dfinke in #1181

Full Changelog: v7.5.2...v7.5.3

Rename switch on ImportExcel

Changed the switch -NotAsDictionary to -Raw. Works with -Worksheetname * reads all the sheets in the xlsx file and returns an array.

v7.5.1

• Fixed Import-Excel - Reset EndRow and EndColumn in the correct place.

Full Changelog: v7.5.0...v7.5.1

v7.5.0

What's Changed

• Fix bug #1172 by @dfinke in #1173
• Update and improve Import-Excel for reading sheets by @dfinke in #1161
• Add helper functions by @dfinke in #1171

Read the changelog

https://github.com/dfinke/ImportExcel/blob/master/changelog.md

Full Changelog: v7.4.2...v7.5.0

v7.4.2

What's Changed

• Add FreezePane Example by @dfinke in #1118
• Add Add-ExcelImage example by @joshooaj in #1133
• Adding VBA examples for worksheets by @caosborn in #1149
• Allow for escaping of single quote in data. by @jamesmmueller in #1145

New Contributors

• @joshooaj made their first contribution in #1133
• @caosborn made their first contribution in #1149
• @jamesmmueller made their first contribution in #1145

Full Changelog: v7.4.1...v7.4.2

v7.4.1

What's Changed

• Faq docs by @DavisHenckel in #1110
• Refactor-rezip by @dfinke in #1112

New Contributors

• @DavisHenckel made their first contribution in #1110

Full Changelog: v7.4.0...v7.4.1

ImportColumns parameter added to ImportExcel

It is used to define which columns of the ExcelPackage should be imported.

Added query Excel spreadsheets, with SQL queries

• Uses System.Data OleDb to enable SQL like queries against spreadsheets [source]