package cn.edu.cumt.print;
import java.io.File;
import
java.io.IOException;
import
java.sql.SQLException;
import java.util.List;
import cn.edu.cumt.print.ExcelService;
import cn.edu.cumt.UserDao.StuDetailedInfoDao;
import cn.edu.cumt.realclass.simpleInfoBean;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class ExcelService {
public static boolean writeExcel() throws
SQLException,
IOException,BiffException {
try {
File file = new File("result.xls");
if(file.exists())
{
return false;
}
else
{
WritableWorkbook wb = Workbook.createWorkbook(new File("D:/result.xls"));
WritableSheet ws = wb.createSheet("sheet1", 0);
StuDetailedInfoDao sdid = new StuDetailedInfoDao();
List<simpleInfoBean> list = sdid.selectAll();
Label la = new Label(0, 0, "序号");
Label lb = new Label(1, 0, "学生姓名");
Label lc = new Label(2, 0, "性别");
Label ld = new Label(3, 0, "考试级别");
Label le = new Label(4, 0, "考试代码");
Label lee = new Label(5,0, "联系电话");
Label lf = new Label(6, 0, "身份证号");
Label lg = new Label(7, 0, "民族代码");
Label lh = new Label(8, 0, "是否补考");
Label li = new Label(8, 0, "远准考证号");
ws.addCell(la); ws.addCell(lb);
ws.addCell(lc); ws.addCell(ld);
ws.addCell(le); ws.addCell(lee);
ws.addCell(lf);ws.addCell(lg);
ws.addCell(lh); ws.addCell(li);
if (null != list)
{
for (int i = 0; i < list.size(); i++)
{
simpleInfoBean ub = list.get(i);
la = new Label(0, i + 1, ub.getStuName());
lb = new Label(1, i + 1, ub.getSex());
lc = new Label(2, i + 1, ub.getExamGrade());
ld = new Label(3, i + 1, ub.getCode());
le = new Label(4, i + 1, ub.getConNum());
lee = new Label(5, i + 1,ub.getIDcard());
lf = new Label(6, i + 1, ub.getNationalityCode());
lg = new Label(7, i + 1, ub.getNationalityCode());
lh = new Label(8, i + 1, ub.getMakeUpJob());
li = new Label(9, i + 1, ub.getAdmissionCardNum());
ws.addCell(la); ws.addCell(lb);
ws.addCell(lc); ws.addCell(ld);
ws.addCell(le); ws.addCell(lee);
ws.addCell(lf); ws.addCell(lg);
ws.addCell(lh); ws.addCell(li);
}
}
wb.write();
wb.close();
return true;
}
} catch (Exception e) {
e.printStackTrace();
return false;
// TODO: handle exception }
}
}
}
//exportXLS.jsp
<body>
<%
if(ExcelService.writeExcel())
{
%>
<p>成功生成终表，现在<a href="D:/result.xls">下载</a></p>
<%
}
else
{
%>
<p>插入失败，请去E盘查看文件“result.xls”是否已经存在</p>
<%
}
%>
</body>
报错了：
An error occurred at line: 12 in the jsp file: /exportXLS.jsp
The type jxl.read.biff.BiffException
cannot be resolved. It is indirectly referenced from required .class files
9: </head>
10: <body>
11: <%
12: if(ExcelService.writeExcel())
13: {
14:
15:
Stacktrace:
at org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:92) -->
导出excel表问题
Java code
package cn.edu.cumt.print;
import java.io.File;
import java.io.IOException;
import java.sql.SQLException;
import java.util.List;
import cn.edu.cumt.print.ExcelService;
import cn.edu.cumt.UserDao.StuDetailedInfoDao;
import cn.edu.cumt.realclass.simpleInfoBean;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class ExcelService {
public static boolean writeExcel() throws SQLException, IOException,BiffException {
try {
File file = new File("result.xls");
if(file.exists())
{
return false;
}
else
{
WritableWorkbook wb = Workbook.createWorkbook(new File("D:/result.xls"));
WritableSheet ws = wb.createSheet("sheet1", 0);
StuDetailedInfoDao sdid = new StuDetailedInfoDao();
List<simpleInfoBean> list = sdid.selectAll();
Label la = new Label(0, 0, "序号");
Label lb = new Label(1, 0, "学生姓名");
Label lc = new Label(2, 0, "性别");
Label ld = new Label(3, 0, "考试级别");
Label le = new Label(4, 0, "考试代码");
Label lee = new Label(5,0, "联系电话");
Label lf = new Label(6, 0, "身份证号");
Label lg = new Label(7, 0, "民族代码");
Label lh = new Label(8, 0, "是否补考");
Label li = new Label(8, 0, "远准考证号");
ws.addCell(la); ws.addCell(lb);
ws.addCell(lc); ws.addCell(ld);
ws.addCell(le); ws.addCell(lee);
ws.addCell(lf);ws.addCell(lg);
ws.addCell(lh); ws.addCell(li);
if (null != list)
{
for (int i = 0; i < list.size(); i++)
{
simpleInfoBean ub = list.get(i);
la = new Label(0, i + 1, ub.getStuName());
lb = new Label(1, i + 1, ub.getSex());
lc = new Label(2, i + 1, ub.getExamGrade());
ld = new Label(3, i + 1, ub.getCode());
le = new Label(4, i + 1, ub.getConNum());
lee = new Label(5, i + 1,ub.getIDcard());
lf = new Label(6, i + 1, ub.getNationalityCode());
lg = new Label(7, i + 1, ub.getNationalityCode());
lh = new Label(8, i + 1, ub.getMakeUpJob());
li = new Label(9, i + 1, ub.getAdmissionCardNum());
ws.addCell(la); ws.addCell(lb);
ws.addCell(lc); ws.addCell(ld);
ws.addCell(le); ws.addCell(lee);
ws.addCell(lf); ws.addCell(lg);
ws.addCell(lh); ws.addCell(li);
}
}
wb.write();
wb.close();
return true;
}
} catch (Exception e) {
e.printStackTrace();
return false;
// TODO: handle exception }
}
}
}
//exportXLS.jsp
<body>
<%
if(ExcelService.writeExcel())
{
%>
<p>成功生成终表，现在<a href="D:/result.xls">下载</a></p>
<%
}
else
{
%>
<p>插入失败，请去E盘查看文件“result.xls”是否已经存在</p>
<%
}
%>
</body>
报错了：
An error occurred at line: 12 in the jsp file: /exportXLS.jsp
The type jxl.read.biff.BiffException
cannot be resolved. It is indirectly referenced from required .class files
9: </head>
10: <body>
11: <%
12: if(ExcelService.writeExcel())
13: {
14:
15:
Stacktrace:
at org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:92)