Converts an Excel sheet from a workbook to JSON
Excel2JSON.ps1 [-InputFile] <Object> [[-OutputFileName] <String>] [[-SheetName] <String>] [[-$HeaderRow] <Int>] [[-$DetailRow] <Int>]
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.
Excel2JSON.ps1 -InputFile MyExcelWorkbook.xlsx
Get-Item MyExcelWorkbook.xlsx | Excel2JSON.ps1 -OutputFileName MyConvertedFile.json -SheetName Sheet2 -HeaderRow 2 -DetailRow 3
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: FalseThe 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: FalseThe 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: FalseSpecifies the row number containing the header in the Excel Workbook.
Type: Int
Parameter Sets: (All)
Aliases:
Required: False
Position: 3
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseSpecifies the row number containing the detail data in the Excel Workbook.
Type: Int
Parameter Sets: (All)
Aliases:
Required: False
Position: 3
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseThis code was based on the original written by: Chris Brown
Find me on: