Converts an Excel sheet from a workbook to JSON
Convert-ExcelSheetToJson.ps1 [-InputFile] <Object> [[-OutputFileName] <String>] [[-SheetName] <String>]
To allow for parsing of Excel Workbooks suitably in PowerShell, this script converts a sheet from a spreadsheet into a JSON file of the same structure as the sheet.
Convert-ExcelSheetToJson -InputFile MyExcelWorkbook.xlsx
Get-Item MyExcelWorkbook.xlsx | Convert-ExcelSheetToJson -OutputFileName MyConvertedFile.json -SheetName Sheet2
The Excel Workbook to be converted. Can be FileInfo or a String.
Type: Object
Parameter Sets: (All)
Aliases:
Required: True
Position: 1
Default value: None
Accept pipeline input: True (ByValue)
Accept wildcard characters: False
The path to a JSON file to be created.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 2
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
The name of the sheet from the Excel Workbook to convert. If only one sheet exists, it will convert that one.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 3
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
Written by: Chris Brown
Find me on:
- My blog: https://flamingkeys.com/
- Github: https://github.com/chrisbrownie