Получить номер версии приложения, создавшего документ Excel

Contents
[ ]

Следующий образец кода демонстрирует использование свойства Workbook.getBuiltInDocumentProperties().getVersion(). Он загружает файлы Excel, созданные в Microsoft Excel 2003, 2007, 2010 и 2013, и выводит номер версии приложения, создавшего эти документы Excel.

Для вашего ориентира ниже приведен вывод консоли образца кода.

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