Identify Excel files sans extensions
A new client handed me a removable hard drive with several gigabytes of files that were recovered from a server that crashed/failed years ago. The files have generic/random names and no extensions. The client wants any/all Excel files from the device copied onto a different device and wants to know the authors of each Excel file. I would like to put together a PS script that opens each file on this device to see if it is an Excel file, and if so, copy it to another location and append an extension to the filename, either XLS or XLSX. I would also like the script to output a CSV with the results of each file checked (i.e. full path of file checked, yes/no for Excel validation, and if Excel validated then last modified by person, etc.). I suspect there are also Word files, PowerPoint files, and PDFs, but the client doesn't care about any of those (yet?). So, I'm thinking it would be a bonus if the PS script also identified and handled these in the same manner. Thoughts on best way to handle this would be appreciated.