I was working in a project where test code was available but there was no document available to get idea what tests are there. Analyzing if any feature area was missing was not feasible. So, I wrote below PowerShell script to generate nice excel test document. It will work on…