Difference between revisions of "WikiTaskTutorial/Excel97"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | {{PageSequence|prev=WikiTaskTutorial/Excel|next=WikiTaskTutorial/ | + | {{PageSequence|prev=WikiTaskTutorial/Excel|next=WikiTaskTutorial/Word|category=Wikitask Tutorial|categoryIcon=document}}<br> |
This is an Example for accessing an Excel97 <img src='http://img3.wikia.nocookie.net/__cb20120507131818/logopedia/images/thumb/1/1c/Excel.gif/80px-Excel.gif'/> xls document from a WikiTask. | This is an Example for accessing an Excel97 <img src='http://img3.wikia.nocookie.net/__cb20120507131818/logopedia/images/thumb/1/1c/Excel.gif/80px-Excel.gif'/> xls document from a WikiTask. | ||
The example file is http://file-examples.com/wp-content/uploads/2017/02/file_example_XLS_50.xls. | The example file is http://file-examples.com/wp-content/uploads/2017/02/file_example_XLS_50.xls. | ||
| Line 30: | Line 30: | ||
== result == | == result == | ||
| − | The Excel file: | + | The Excel file: http://file-examples.com/wp-content/uploads/2017/02/file_example_XLS_50.xls |
| − | can not be opened due to error | + | can not be opened due to error Invalid header signature; read 0x505954434F44213C, expected 0xE11AB1A1E011CFD0 - Your file appears not to be a valid OLE2 document |
Latest revision as of 09:01, 27 April 2020
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: 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