Obtener el número de versión de la aplicación que creó el documento de Excel
El siguiente código de ejemplo demuestra el uso de la propiedad Workbook.getBuiltInDocumentProperties().getVersion(). Carga archivos de Excel creados con Microsoft Excel 2003, 2007, 2010 y 2013 e imprime el número de versión de la aplicación que creó estos documentos de Excel..
Para tu referencia, a continuación se muestra la salida de la consola que crea el código de ejemplo.
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()); |