Difference between revisions of "WikiTaskTutorial/Excel97"
Jump to navigation
Jump to search
(pushed from https://partner.bitplan.com) |
|||
| Line 1: | Line 1: | ||
{{PageSequence|prev=WikiTaskTutorial/Excel|next=WikiTaskTutorial/Powerpoint|category=Wikitask Tutorial|categoryIcon=document}}<br> | {{PageSequence|prev=WikiTaskTutorial/Excel|next=WikiTaskTutorial/Powerpoint|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 | + | The example file is https://file-examples.com/wp-content/uploads/2017/02/file_example_XLS_50.xls. |
=== template === | === template === | ||
This template includes {{Link|target=Office#Excel97}} | This template includes {{Link|target=Office#Excel97}} | ||
| Line 25: | Line 25: | ||
</source> | </source> | ||
<pre> | <pre> | ||
| − | {{wikitask|cmd=runtemplate|input= | + | {{wikitask|cmd=runtemplate|input=https://file-examples.com/wp-content/uploads/2017/02/file_example_XLS_50.xls|engine=Rythm|template={{FULLPAGENAMEE}}#template|targetpage={{FULLPAGENAMEE}}#result}} |
</pre> | </pre> | ||
| − | {{wikitask|cmd=runtemplate|input= | + | {{wikitask|cmd=runtemplate|input=https://file-examples.com/wp-content/uploads/2017/02/file_example_XLS_50.xls|engine=Rythm|template={{FULLPAGENAMEE}}#template|targetpage={{FULLPAGENAMEE}}#result}} |
== result == | == result == | ||
The Excel file: http://mdcune.psych.ucla.edu/modules/bioinformatics/extras/QTL_Sample_data.xls | The Excel file: http://mdcune.psych.ucla.edu/modules/bioinformatics/extras/QTL_Sample_data.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 | can not be opened due to error Invalid header signature; read 0x505954434F44213C, expected 0xE11AB1A1E011CFD0 - Your file appears not to be a valid OLE2 document | ||
Revision as of 09:54, 27 April 2020
This is an Example for accessing an Excel97 
xls document from a WikiTask.
The example file is https://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=https://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://mdcune.psych.ucla.edu/modules/bioinformatics/extras/QTL_Sample_data.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