Files

 master

/

Examples

/

Copy path

Directory actions

More options

Directory actions

More options

Latest commit

RipFence

ChartDataSeparatePage.ps1

Mar 14, 2024

8ff1757 · Mar 14, 2024

History

History

/

Examples

/

Top

Folders and files

Name		Name	Last commit message	Last commit date
parent directory ..
AddImage		AddImage	@joshooaj added throw if not on Windows, pls review	Feb 3, 2022
AddWorkSheet		AddWorkSheet	Standardising examples	Jul 1, 2020
Charts		Charts	ChartDataSeparatePage.ps1	Mar 14, 2024
CommunityContributions		CommunityContributions	Move to /Examples/CommunityContributions Folder	Feb 18, 2020
ConditionalFormatting		ConditionalFormatting	Add -ShowOnlyIcon to New-ConditionalFormattingIconSet. Base on #1340	Dec 10, 2022
ConvertFrom		ConvertFrom	remove LoadPSD calls & 72 empty catch blocks from examples	Nov 17, 2019
CustomNumbers		CustomNumbers	Add sample - How to convert abbreviate or shorten long numbers in Excel	May 29, 2022
CustomReporting		CustomReporting	Standardising examples	Jul 1, 2020
CustomizeExportExcel		CustomizeExportExcel	fixes to casing, and some basic functions changed to advanced	Nov 25, 2019
ExcelBuiltIns		ExcelBuiltIns	Standardising examples	Jul 1, 2020
ExcelDataValidation		ExcelDataValidation	Standardising examples	Jul 1, 2020
ExcelToSQLInsert		ExcelToSQLInsert	remove LoadPSD calls & 72 empty catch blocks from examples	Nov 17, 2019
Experimental		Experimental	Standardising examples	Jul 1, 2020
Extra		Extra	New subtotals, tweak module stats example	Jun 21, 2022
Fibonacci		Fibonacci	Standardising examples	Jul 1, 2020
FormatCellStyles		FormatCellStyles	Standardising examples	Jul 1, 2020
FormatResults		FormatResults	Use EZOut to format data form Excel to Mardown tables and Yaml	Aug 24, 2022
Freeze		Freeze	Add FreezePane Example	Dec 30, 2021
GenerateData		GenerateData	aggressive linting	Nov 20, 2019
Grouping		Grouping	Add column to GroupNumeric/Date in PivotTables.	Jul 14, 2022
HyperLinks		HyperLinks	Standardising examples	Jul 1, 2020
Import-Excel		Import-Excel	Rename switch NotAsDictionary to Raw	May 4, 2022
ImportByColumns		ImportByColumns	fix spelling	Jun 17, 2022
ImportColumns		ImportColumns	Add example and automatic column arrangement	Nov 9, 2021
ImportHtml		ImportHtml	remove LoadPSD calls & 72 empty catch blocks from examples	Nov 17, 2019
InteractWithOtherModules		InteractWithOtherModules	Added Pivoting Pester Test Results	May 6, 2019
InvokeExcelQuery		InvokeExcelQuery	Minor tweak. Display query executed	Nov 12, 2021
JoinWorksheet		JoinWorksheet	Standardise file cleanup	Jul 1, 2020
JustCharts		JustCharts	aggressive linting	Nov 20, 2019
MergeWorkSheet		MergeWorkSheet	Standardising examples	Jul 1, 2020
MortgageCalculator		MortgageCalculator	Standardising examples	Jul 1, 2020
MoveSheets		MoveSheets	remove LoadPSD calls & 72 empty catch blocks from examples	Nov 17, 2019
MultiplierTable		MultiplierTable	update .gitignore	May 27, 2018
Nasa		Nasa	aggressive linting	Nov 20, 2019
NumberFormat		NumberFormat	remove LoadPSD calls & 72 empty catch blocks from examples	Nov 17, 2019
OpenExcelPackage		OpenExcelPackage	Add Enable-ExcelAutoFilter and Enable-ExcelAutofit example	Apr 30, 2022
OutTabulator		OutTabulator	aggressive linting	Nov 20, 2019
PassThru		PassThru	remove LoadPSD calls & 72 empty catch blocks from examples	Nov 17, 2019
PesterTestReport		PesterTestReport	Added example for exporting data to Excel for Pester 5.1	Feb 12, 2021
PivotTable		PivotTable	Standardise file cleanup	Jul 1, 2020
PivotTableFilters		PivotTableFilters	remove LoadPSD calls & 72 empty catch blocks from examples	Nov 17, 2019
Plot		Plot	remove LoadPSD calls & 72 empty catch blocks from examples	Nov 17, 2019
ReadAllSheets		ReadAllSheets	aggressive linting	Nov 20, 2019
SQL+FillColumns+Pivot		SQL+FillColumns+Pivot	remove more aliases from examples	Dec 8, 2019
SetColumnBackgroundColor		SetColumnBackgroundColor	remove LoadPSD calls & 72 empty catch blocks from examples	Nov 17, 2019
Sparklines		Sparklines	fix naming consitency (case mostly)	Nov 25, 2019
SpreadsheetCells		SpreadsheetCells	aggressive linting	Nov 20, 2019
Stocks		Stocks	aggressive linting	Nov 20, 2019
Styles		Styles	remove LoadPSD calls & 72 empty catch blocks from examples	Nov 17, 2019
Tables		Tables	Bugfix example script	Nov 11, 2022
TestRestAPI		TestRestAPI	Update Pester Syntax from V3 to V4 (V5 won't support the old version)	Dec 29, 2019
VBA		VBA	Added -Show	Jul 13, 2022
XlRangeToImage		XlRangeToImage	Remove 72 empty catch blocks and Loadpsd1	Nov 18, 2019
Index - Music.ps1		Index - Music.ps1	remove more aliases from examples	Dec 8, 2019
New-PSItem.ps1		New-PSItem.ps1	aggressive linting	Nov 20, 2019
Pester-To-XLSx.ps1		Pester-To-XLSx.ps1	Tweaked format	Mar 16, 2020
PsGallery.ps1		PsGallery.ps1	New examples incl. Pester to XLSx	Mar 16, 2020
Subtotals.ps1		Subtotals.ps1	New examples incl. Pester to XLSx	Mar 16, 2020
TryMultiplePivotTables.ps1		TryMultiplePivotTables.ps1	aggressive linting	Nov 20, 2019
TryMultiplePivotTablesFromOneSheet.ps1		TryMultiplePivotTablesFromOneSheet.ps1	remove LoadPSD calls & 72 empty catch blocks from examples	Nov 17, 2019
View all files