WikiTaskTutorial/Excel97

This is an Example for accessing an Excel97 xls document from a WikiTask. The example file is http://file-examples.com/wp-content/uploads/2017/02/file_example_XLS_50.xls.

template

This template includes Office#Excel97

@include(wiki.Office.Excel97)
The Excel file: @(wikiTask.getInput())
@if(excel.error) {  
can not be opened due to error @(excel.error.getMessage())
} else {has the following sheets:
@for (int i=0;i<excel.workbook.getNumberOfSheets();i++) { @{HSSFSheet sheet = excel.workbook.getSheetAt(i);List<List<String>> sheetContent=excel.getSheetContent(sheet);String delim="!"} 
=== @(sheet.getSheetName()) ===
@("{")|class="wikitable sortable"
@for (List<String> row:sheetContent) { @for (col:row) {
@(delim)<nowiki>@col</nowiki>
}
|-
@{ delim="|" }
}
@("|}")
}
}
@{ try { excel.workbook.close(); }  catch (Throwable th) { }}

{{wikitask|cmd=runtemplate|input=http://file-examples.com/wp-content/uploads/2017/02/file_example_XLS_50.xls|engine=Rythm|template={{FULLPAGENAMEE}}#template|targetpage={{FULLPAGENAMEE}}#result}}

runtemplate -> WikiTaskTutorial/Excel97#result

result

The Excel file: https://file-examples.com/wp-content/uploads/2017/02/file_example_XLS_50.xls can not be opened due to error sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target