Get the Version Number of the Application that Created the Excel Document
The following sample code demonstrates the use of the Workbook.getBuiltInDocumentProperties().getVersion() property. It loads Excel files created with Microsoft Excel 2003, 2007, 2010 and 2013 and prints the version number of the application that created these Excel documents.
For your reference, below is the console output the sample code creates.
Excel 2003 XLS Version: 726502
Excel 2007 XLS Version: 786432
Excel 2010 XLS Version: 917504
Excel 2013 XLS Version: 983040
Excel 2007 XLSX Version: 12.0000
Excel 2010 XLSX Version: 14.0300
Excel 2013 XLSX Version: 15.0300
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java | |
// The path to the documents directory. | |
String dataDir = Utils.getDataDir(GetVersionNumberofApplication.class); | |
// Create a workbook reference | |
Workbook workbook = null; | |
// Print the version number of Excel 2003 XLS file | |
workbook = new Workbook(dataDir + "Excel2003.xls"); | |
System.out.println("Excel 2003 XLS Version: " + workbook.getBuiltInDocumentProperties().getVersion()); | |
// Print the version number of Excel 2007 XLS file | |
workbook = new Workbook(dataDir + "Excel2007.xls"); | |
System.out.println("Excel 2007 XLS Version: " + workbook.getBuiltInDocumentProperties().getVersion()); | |
// Print the version number of Excel 2010 XLS file | |
workbook = new Workbook(dataDir + "Excel2010.xls"); | |
System.out.println("Excel 2010 XLS Version: " + workbook.getBuiltInDocumentProperties().getVersion()); | |
// Print the version number of Excel 2013 XLS file | |
workbook = new Workbook(dataDir + "Excel2013.xls"); | |
System.out.println("Excel 2013 XLS Version: " + workbook.getBuiltInDocumentProperties().getVersion()); | |
// Print the version number of Excel 2007 XLSX file | |
workbook = new Workbook(dataDir + "Excel2007.xlsx"); | |
System.out.println("Excel 2007 XLSX Version: " + workbook.getBuiltInDocumentProperties().getVersion()); | |
// Print the version number of Excel 2010 XLSX file | |
workbook = new Workbook(dataDir + "Excel2010.xlsx"); | |
System.out.println("Excel 2010 XLSX Version: " + workbook.getBuiltInDocumentProperties().getVersion()); | |
// Print the version number of Excel 2013 XLSX file | |
workbook = new Workbook(dataDir + "Excel2013.xlsx"); | |
System.out.println("Excel 2013 XLSX Version: " + workbook.getBuiltInDocumentProperties().getVersion()); |