Convert an excelfile to json with PowerShell

In my blog I've been showing you how easily you can import excel files.
Of course, not everyone works with PowerShell.  Some might rather work with a language where excel is less easy or JSON would be a better fit.  And everyone probably has a windows machine running somewhere, right ? Well, with this script, you can convert your "simple" excel files to JSON. Once you have your JSON-file, the sky should be the limit. 

Dependencies

To read the excel file, you will need the PSExcel module.
https://github.com/RamblingCookieMonster/PSExcel

Note 

This is meant for simple excel files.  Single Table of data in each worksheet.

The code

(ps : save this as Convert-ExcelToJson.ps1)

<#
.Synopsis
   Converts excel files to json files
.DESCRIPTION
   Converts excel files to json files
   The json file is created in the same path as the excel file
   NOTE : This is meant for simple excel files, each sheet, a simple table of data
.EXAMPLE
   .\convert-exceltojson.ps1 -Name "c:\temp\myexcel.xlsx"
.EXAMPLE
   dir *.xlsx | .\convert-exceltojson.ps1
#>

[CmdletBinding()]
Param
(
    # Name of the file, can be absolute path or relative
    [Parameter(Mandatory=$true,
                ValueFromPipelineByPropertyName=$true,
                Position=0)]
    [Alias("FullName")]
    [string[]]$Name
)

Begin
{
    Import-Module PSExcel
    function getExcelData($path){
        $excel = New-Excel -Path $path
        $worksheets = $excel | Get-Worksheet | %{$_.Name}
        foreach($w in $worksheets){
            $data = Import-XLSX -Path $path -Sheet $w
            $ws = @{
                worksheet = $w;
                data = $data
            }
            write-output (New-Object -TypeName PSObject -Property $ws)
        }
    }
}
Process
{
        
    foreach($n in $Name){
        $path = (resolve-path $n).Path
        Write-Verbose "Converting $path"
        getExcelData -path $path | ConvertTo-Json -Depth 5 | Out-File ($path -replace ".xlsx",".json") -Force
    }
}
End
{
}