|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
|
1.创建excel文件<br>//这里的jxl不是java的标准jar包，需要在项目中另外加载
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class ExcelDownload extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// 生成xls
try {
Date d = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd_kkmmss ");
String random = sdf.format(d);
String targetFile = random + ".excel";
response.setContentType("application/vnd.ms-excel");
response.addHeader("Content-Disposition",
"attachment; filename=\"" + targetFile + "\"");
OutputStream os = response.getOutputStream();
WritableWorkbook wwb = Workbook.createWorkbook(os);
// 新建一张表
WritableSheet wsheet = wwb.createSheet("record", 0);
// 设置表头
Label label = new Label(0, 0, "");
wsheet.addCell(label);
label = new Label(0, 0, "会员姓名");
wsheet.addCell(label);
label = new Label(1, 0, "卡号");
wsheet.addCell(label);
label = new Label(2, 0, "联系地址");
wsheet.addCell(label);
label = new Label(3, 0, "邮编");
wsheet.addCell(label);
label = new Label(4, 0, "联系电话");
wsheet.addCell(label);
label = new Label(5, 0, "手机");
wsheet.addCell(label);
label = new Label(6, 0, "Email");
wsheet.addCell(label);
label = new Label(7, 0, "性别");
wsheet.addCell(label);
wwb.write();
wwb.close();
os.close();
response.flushBuffer();
} catch (Exception e) {
System.out.println("生成信息表(Excel格式)时出错：");
e.printStackTrace();
}
}
} |
2.读取excel文件
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
import java.io.*;
import jxl.*;
public class ReadExcel
{public static void main(String[] args)
{try{
Workbook book=Workbook.getWorkbook(new File("c:\test.xls"));
//获得第一个工作表对象Sheet sheet=book.getSheet(0);
//得到第2行第1列的单元格Cell cell1=sheet.getCell(0,1);
String result=cell1.getContents();System.out.println(result);book.close();}catch(Exception e){
System.out.println(e);}}} |
3.修改excel文件，执行结果是在原有文件中加入了一个新的工作表
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
import java.io.*;
import jxl.*;
import jxl.write.*;
public class UpdateExcel
{ public static void main(String[] args)
{ try {
//获得Excel文件
Workbook wb=Workbook.getWorkbook(new File("c://test.xls"));
//打开一个文件的副本，并且指定数据写回到原文件
WritableWorkbook book=
Workbook.createWorkbook(new File("c://test.xls"),wb);
//添加一个工作表eet,在第一行第一列填写内容
WritableSheet sheet=book.createSheet("第二页",1);
sheet.addCell(new Label(0,0,"http://www.sunleap.com"));
book.write();
book.close();
}catch(Exception e){
System.out.println(e);
}
System.out.println("操作结束！");
}
} |
详细使用，请参考jxl的api文档
本文转自二郎三郎博客园博客，原文链接：http://www.cnblogs.com/haore147/p/3617973.html，如需转载请自行联系原作者