Use powershell to gather information from an xml source and output to an excel spreadsheet
I have a few XML files that will be generated and dumped to a directory, the information then needs to be parsed from the xml source files and then inserted in to an excel spreadsheet. The out put will need to be over a few tabs, this will then need to be emailed to someone.
The key skills here are understanding XML, powershell, excel and how to display the information in a useful way. I would also like to have the code to be modular to allow for further expansion, if additional information is required to be displayed, or to be displayed to a different output (i.e. web based rather than excel)