Sonam Rastogi

Convert specific table of excel sheet to JSON using PowerShell

There is an excellent script on GitHub that helps to convert a full Excel sheet to JSON format using PowerShell. The script expects the table to be at the start of the sheet; that is, to have the first header in the A1 cell. I had a little different requirement. I had to convert a […]

Convert specific table of excel sheet to JSON using PowerShell Continue Reading

Update XML files using PowerShell

There are many available blog posts on internet explaining how to update XML files in PowerShell. But I felt need of one consolidated blog where complex XML files can be updated using PowerShell. These complex xml files can have long complex hierarchy of XML nodes and attributes. Let us try to update below XML sample

Update XML files using PowerShell Continue Reading