我们爱分享----Excel POI3.6

softroad 2011-08-30 11:03:44

加精

由于每次发送代码量有限，所以一次只能发一点，希望大家先别回复，谢谢。

一共有这么些信息：
BaseBean.java
TitleBean.java
EntityBean.java
ExcelConstant.java
ExcelEditor.java
PropertyUtil.java
UserInfoBean.java
ExcelDemo.java

userinfo.xls
UserInfoBean_ch.properties
UserInfoBean.properties

...全文

6913 102 打赏收藏转发到动态举报

写回复

用AI写文章

102 条回复

切换为时间正序

请发表友善的回复…

发表回复

Keep-My-Word 2013-12-12

打赏
举报

虽然过了很久但是依旧膜拜啊

softroad 2013-12-05

打赏
举报

SELECT * FROM (SELECT qsc.id AS id, qsc.surveyId AS pid, qsc.qcName AS caption, '' AS para, '' AS format, '' AS action, qsc.`value` AS type, '' AS jump, qsc.createdBy AS createdBy, qsc.createdDate AS createdDate, st.type AS ttype FROM survey_tree st, questionsclass qsc WHERE st.surveyId=#surveyId# AND st.`type`=2 AND st.id=qsc.id ORDER BY st.`order`) AS rqsc UNION SELECT * FROM (SELECT qs.id AS id, qs.classId AS pid, qs.qsName AS caption, qs.desc AS para, '' AS format, '' AS action, CAST(qs.type AS CHAR) AS type, '' AS jump, qs.createdBy AS createdBy, qs.createdDate AS createdDate, st.type AS ttype FROM survey_tree st, questions qs WHERE st.surveyId=#surveyId# AND st.`type`=3 AND st.id=qs.id ORDER BY st.`order`) AS rqs UNION SELECT * FROM (SELECT q.id AS id, q.questionsId AS pid, q.qName AS caption, CAST(q.para AS CHAR) AS para, '' AS format, '' AS action, CAST(q.type AS CHAR) AS type, '' AS jump, q.createdBy AS createdBy, q.createdDate AS createdDate, st.type AS ttype FROM survey_tree st, question q WHERE st.surveyId=#surveyId# AND st.`type`=4 AND st.id=q.id ORDER BY st.`order`) AS rq UNION SELECT * FROM (SELECT a.id AS id, a.questionId AS pid, a.caption AS caption, '' AS para, CAST(a.format AS CHAR) AS format, CAST(a.action AS CHAR) AS action, CAST(a.type AS CHAR) AS type, a.jump AS jump, a.createdBy AS createdBy, a.createdDate AS createdDate, 5 AS ttype FROM survey_tree st, question q, answer a WHERE st.surveyId=#surveyId# AND st.`type`=4 AND st.id=q.id AND q.id=a.questionId ORDER BY a.id) ra

深沉我喜欢 2013-03-27

打赏
举报

有没有servlet的例子，先是读取，然后再从jsp中获取的表单数据添加到读取的那个excel表，然后依次获取以后就会依次添加到表里的下一行，没获取一次数据就添加到同一个表中，也不会覆盖数据的那种，LZ不知道有没有这个例子；

yzcan 2012-12-25

打赏
举报

楼主打包上传吧。

jeason_boen 2012-12-13

打赏
举报

非常好！记下备用

fhqlpgk1218 2012-11-12

打赏
举报

很好很强大~~~

Αμπάι. 2012-10-18

打赏
举报

要是要导出一千万行数据，会不会把虚拟机干死啊...?

Johnny__Tang 2012-10-01

打赏
举报

做业务系统，导出excel是很常用的。谢谢楼主分享。。。

nc_yongyou 2012-09-15

打赏
举报

[Quote=引用 25 楼的回复:]
好啦，给大家讲个写Excel例子的思路

看一下这张图。。如果是这种结构的Excel（写出去），如果处理？

首先，定义一个Bean,包含：部门，姓名，职位，住址也就是所有的表头

二、查出数据，将所有部门加入Set<String)中。这样可以获得不重复的部门

三、定义一个Map<String,List<Bean>>的结构，来保存管理数据。 string……
[/Quote]

这张处理思路蛮好的哈

softroad 2012-08-07

打赏
举报

[Quote=引用 92 楼的回复:]
引用 91 楼的回复:
class ExcelEditor method readExcel

InputStream in = new FileInputStream(excel);
Workbook book = null;

try {
book = new HSSFWorkbook(in);} catch (OutOfMemoryError e) {
String msg……
[/Quote]

会不会是包引用错了，看看HSSFWorkbook的父类Workbook的包名。

joyce1011 2012-08-03

打赏
举报

[Quote=引用 91 楼的回复:]
class ExcelEditor method readExcel

InputStream in = new FileInputStream(excel);
Workbook book = null;

try {
book = new HSSFWorkbook(in);} catch (OutOfMemoryError e) {
String msg = "The file "……
[/Quote]

如果把book = new HSSFWorkbook(in); 改为 book = （Workbook）new HSSFWorkbook(in);
又报错 org.apache.poi.hssf.usermodel.HSSFWorkbook cannot be cast to org.apache.poi.ss.usermodel.Workbook

joyce1011 2012-08-03

打赏
举报

class ExcelEditor method readExcel

InputStream in = new FileInputStream(excel);
Workbook book = null;

try {
book = new HSSFWorkbook(in);} catch (OutOfMemoryError e) {
String msg = "The file " + excel.getName()
+ " data is error, please delete invalid data!";

throw new Exception(msg);
} catch (OfficeXmlFileException e) {
in = new FileInputStream(excel);
book = new XSSFWorkbook(in);
}

报错 Type mismatch: cannot convert from HSSFWorkbook to Workbook是怎么回事呢？要怎么修改呢？