Hämta versionsnumret för programmet som skapade Excel-dokumentet

Ofta behöver du veta versionsnumret för programmet som skapade ett Microsoft Excel-dokument. Aspose.Cells tillhandahållerWorkbook.getBuiltInDocumentProperties().getVersion() egendom för detta ändamål.

Följande exempelkod visar användningen avWorkbook.getBuiltInDocumentProperties().getVersion()fast egendom. Den laddar Excel-filer skapade med Microsoft Excel 2003, 2007, 2010 och 2013 och skriver ut versionsnumret för programmet som skapade dessa Excel-dokument.

För din referens, nedan är konsolutgången som exempelkoden skapar.

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