Get the Version Number of the Application that Created the Excel Document

Contents
[ ]

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());