ExcelUtils README
==========================
http://excelutils.sourceforge.net
rainsoft: http://www.try2it.com/blog
jokeway: http://spaces.msn.com/members/jokeway
We're headache on making web report all long.
ExcelUtils is a helper to export excel report in java web project.
It's like velocity, has own tags, but these tags is written in excel file.
By these tags, you can custom your excel report format freely,
not edit any your source, just ExcelUtils parses your excel template and fills
values to export your report.
It is based POI project and beanutils project.
It uses excel and template language's profit to make web reports easily.
After my hardwork, the parser is finished finally, in which report is exported by Excel Template.
It's funtions include:
1¡¢${model.name} means getting property of the name from the model object.
2¡¢${!model.name} means that last cell and this cell merge if model.name value equals last cell value.
3¡¢#foreach model in ${list}£¬means that iterate list£¬modelId is implied index of the list.
4¡¢#each ${model} ${width1},${width2}£¬model can be a Map,JavaBean,Collection or Array object, #each key
will show all property of the model.${width?} means merge ${width?} cells. If only one
width, all property use the same width. If more than one, use the witdh in order, not set will use "1".
5¡¢${list[0].name} means get the first object from list, then read the property of name.
6¡¢${map(key)} get the value from the map by the key name.
7¡¢${list[${index}].name} [] can be a variable.
8¡¢${map(${key})} () can be a vriable.
9¡¢#sum qty on ${list} where name like/=str sum qty on ${list} collection by where condition.
10¡¢In net.sf.excelutils.tags Package, you can implement ITag to exentd Tag key. eg, FooTag will parse #foo.
11¡¢ExcelResult for webwork.
12¡¢${model${index}} support.
13¡¢#call service.method("str", ${name}) call a method
14¡¢#formual SUM(C${currentRowNo}:F${currentRowNo}) means output excel formula SUM(C?:F?) ? means currentRowNo.
dependency library:
poi-2.5.1.jar (required)
commons-beanutils.jar (required)
commons-digester.jar (required)
commons-logging.jar (required)
ognl.jar (build required, webwork demo required)
xwork.jar (build required, webwork demo required)
webwork-2.1.7.jar (build required, webwork demo required)
oscore.jar (webwork deom required)
struts.jar (struts demo required)
poi ExcelUtils demo下载 （137个子文件） 
ExcelParser.class 11KB WorkbookUtils.class 9KB ExcelUtils.class 7KB TestReportAction.class 6KB EachTag.class 6KB ExcelReportAction.class 5KB ExcelResultAction.class 5KB CallTag.class 5KB ForeachTag.class 5KB IfTag.class 4KB ExcelManager.class 4KB SumTag.class 3KB ExcelResult.class 3KB Model.class 2KB OgnlDynaBean.class 2KB FormulaTag.class 2KB PageTag.class 1KB OgnlDynaClass.class 1KB MutiExcelLoader.class 854B WebappExcelLoader.class 740B ExcelException.class 509B ITag.class 346B ExcelLoader.class 192B stylesheet.css 1KB
inherit.gif 57B
index-all.html 50KB WorkbookUtils.html 36KB ExcelUtils.html 35KB ExcelParser.html 25KB OgnlDynaBean.html 23KB OgnlDynaClass.html 22KB ExcelResult.html 19KB ExcelException.html 17KB IfTag.html 17KB ForeachTag.html 16KB FormulaTag.html 16KB PageTag.html 16KB EachTag.html 16KB CallTag.html 15KB SumTag.html 15KB ExcelManager.html 14KB constant-values.html 12KB overview-tree.html 12KB ITag.html 11KB ITag.html 11KB MutiExcelLoader.html 11KB WebappExcelLoader.html 11KB ExcelLoader.html 11KB ExcelException.html 10KB package-tree.html 9KB serialized-form.html 9KB help-doc.html 9KB ExcelLoader.html 8KB package-summary.html 8KB package-tree.html 8KB package-summary.html 8KB ExcelManager.html 8KB package-use.html 7KB package-summary.html 7KB package-use.html 7KB package-use.html 6KB package-tree.html 6KB WebappExcelLoader.html 6KB MutiExcelLoader.html 6KB overview-summary.html 6KB OgnlDynaClass.html 6KB OgnlDynaBean.html 6KB ExcelResult.html 6KB FormulaTag.html 6KB ForeachTag.html 6KB PageTag.html 6KB CallTag.html 6KB EachTag.html 6KB SumTag.html 6KB IfTag.html 6KB WorkbookUtils.html 6KB ExcelParser.html 6KB ExcelUtils.html 6KB deprecated-list.html 5KB allclasses-frame.html 3KB allclasses-noframe.html 3KB package-frame.html 2KB package-frame.html 2KB package-frame.html 1KB overview-frame.html 1KB index.html 898B packages.html 851B
poi-2.5.1.jar 784KB struts.jar 514KB webwork-2.1.7.jar 319KB commons-beanutils.jar 184KB ognl.jar 164KB xwork.jar 160KB bsh-core-2.0b4.jar 141KB commons-digester.jar 107KB servlet-api.jar 95KB oscore.jar 89KB commons-logging.jar 37KB excelutils.jar 35KB ExcelParser.java 14KB共 137 条
- 1
- 2
资源评论
