Ermitteln Sie die Versionsnummer der Anwendung, die das Excel Dokument erstellt hat
Der folgende Beispielcode zeigt die Verwendung der Workbook.getBuiltInDocumentProperties().getVersion()-Eigenschaft. Er lädt Excel-Dateien, die mit Microsoft Excel 2003, 2007, 2010 und 2013 erstellt wurden, und gibt die Versionsnummer der Anwendung aus, die diese Excel-Dokumente erstellt hat.
Nachfolgend finden Sie die Konsolenausgabe des Beispielcodes.
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()); |