Get-ExcelFileVersion

The script Get-ExcelFileVersion.ps1 retrieves the version of an Excel file. The Microsoft Office applications were using binary file formats for a long time until Microsoft replaced them in Office 2007 with XML-based file formats. The Excel Binary File Formats are using in most cases the .XLS file extension but differ between versions despite the common file extension. For instance, the format of an Excel 2003 .xls file is different from the format of an Excel 95 .xls file. So it is not easy to make an inventory of the Excel files and the exact version in case you want to disable certain old file formats. Fortunately, the Excel object model provides the XlFileFormat enumeration that can be used to determine the exact file version. The script Get-ExcelFileVersion.ps1 takes advantage of this enumeration and displays the version for a specified Excel file.