WikiTaskTutorial/Excel97
Wolfgang Fahl
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}}
runtemplatetemplate[edit]
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}}
result[edit]
The Excel file: http://file-examples.com/wp-content/uploads/2017/02/file_example_XLS_50.xls can not be opened due to error Invalid header signature; read 0x505954434F44213C, expected 0xE11AB1A1E011CFD0 - Your file appears not to be a valid OLE2 document
WikiTaskTutorial/Excel97 Wolfgang Fahl