/poi

Java POI 导入 导出 EXCEL

Primary LanguageJavaMIT LicenseMIT

Java POI 导入 导出 EXCEL


Runtime Environment

  • Java version: 1.6.0_33
  • Eclipse Java EE IDE for Web Developers Version: Luna Service Release 1 (4.4.1)
  • Text file encoding: UTF-8
  • Server version: Apache Tomcat/6.0.41
  • Git version: 1.7.9.5

Java Web

  • 将源代码导入eclipse中
  • 部署项目,启动tomcat服务器
  • web页面具体路径:http://localhost:8080/poi
  • 点击Read excel 2003 or 2007,可以读取2003或2007版Excel
  • 点击Export excel 2003,可以导出Excel 2003版
  • 点击Export excel 2007,可以导出Excel 2007版
  • 点击Export excel by templates,replace a cell,读取模版replaceTemplate.xls,替换单元格内容后导出Excel
  • 点击Export excel by templates,insert a table,读取模版template.xls,插入表格后导出Excel

Java Application

以下java类可直接运行使用

  • Read excel 2003 or 2007,对应ReadExcel.java
  • Export excel 2003,对应TestExportExcel.java
  • Export excel 2007,对应TestExportExcel2007.java
  • Export excel by templates,replace a cell,对应TestExcelReplace.java
  • Export excel by templates,insert a table,对应TestTemplate.java

Remarks

例子代码比较简单,仅供参考……

Links

Copyright

Copyright 2014-2015 evangel_z.