Swing Tips(二)

10、Table的Excel导出功能

表格上的Excel导出功能还是比较实用的功能，企业应用一般都会用到，这里提供相关代码

01

try {

02	WritableCellFormat titleFormat = new WritableCellFormat(

03	new WritableFont(WritableFont.createFont("黑体"), 16,

04	WritableFont.NO_BOLD));

05	titleFormat.setVerticalAlignment(VerticalAlignment.CENTRE); // 垂直对齐

06	titleFormat.setAlignment(Alignment.CENTRE); // 水平对齐

07	titleFormat.setWrap(true); // 是否换行

08

09	WritableCellFormat headerFormat = new WritableCellFormat();

10	headerFormat.setBorder(Border.ALL, BorderLineStyle.THIN); // 线条

11	headerFormat.setVerticalAlignment(VerticalAlignment.CENTRE); // 垂直对齐

12	headerFormat.setAlignment(Alignment.CENTRE); // 水平对齐

13	headerFormat.setWrap(true); // 是否换行

14

15	WritableCellFormat countFormat = new WritableCellFormat(

16	new NumberFormat("0.000"));

17	countFormat.setBorder(Border.ALL, BorderLineStyle.THIN); // 线条

18	countFormat.setVerticalAlignment(VerticalAlignment.CENTRE); // 垂直对齐

19	countFormat.setAlignment(Alignment.RIGHT); // 水平对齐

20	countFormat.setWrap(true); // 是否换行

21

22	WritableCellFormat moneyFormat = new WritableCellFormat(

23	new NumberFormat("0.00"));

24	moneyFormat.setBorder(Border.ALL, BorderLineStyle.THIN); // 线条

25	moneyFormat.setVerticalAlignment(VerticalAlignment.CENTRE); // 垂直对齐

26	moneyFormat.setAlignment(Alignment.RIGHT); // 水平对齐

27	moneyFormat.setWrap(true); // 是否换行

28

29	WritableCellFormat intFormat = new WritableCellFormat(

30	new NumberFormat("0"));

31	intFormat.setBorder(Border.ALL, BorderLineStyle.THIN); // 线条

32	intFormat.setVerticalAlignment(VerticalAlignment.CENTRE); // 垂直对齐

33	intFormat.setAlignment(Alignment.RIGHT); // 水平对齐

34	intFormat.setWrap(true); // 是否换行

35

36	WritableWorkbook book = Workbook.createWorkbook(exportFile);

37	WritableSheet sheet = book.createSheet("综合统计报表", 0);

38	int titleRow = 0;

39	int headerRow = 3;

40	int dataRow = 5;

41	sheet.mergeCells(0, titleRow, model.getColumnCount() - 1,

42	titleRow);

43	Label titleLab = new Label(0, titleRow, tableTitleTxfd.getText(), titleFormat);

44	sheet.addCell(titleLab);

45

46

//生成表头

47	for (int j = 0; j < model.getColumnCount(); j++) {

48	sheet.mergeCells(j, headerRow, j, headerRow + 1);

49	Label lab = new Label(j, headerRow, model.getColumnName(

50	j), headerFormat);

51	sheet.addCell(lab);

52

}

53

54	for (int row = 0; row < model.getRowCount(); row++) {

55	for (int col = 0; col < model.getColumnCount(); col++) {

56	Object obj = model.getValueAt(row, col);

57	if (obj instanceof String) {

58	Label lab = new Label(col, dataRow + row,

59	(String) obj, headerFormat);

60	sheet.addCell(lab);

61	} else if (obj instanceof Integer) {

62	Number labelN = new Number(col, dataRow

63	+ row, (Integer) obj, intFormat);

64	sheet.addCell(labelN);

65

} else {

66	Label lab =

67	new Label(col, dataRow + row, "",

68	headerFormat);

69	sheet.addCell(lab);

70

}

71

}

72

}

73

74

//生成表尾

75	int footerRow = dataRow + model.getRowCount() + 1;

76	int step =

77	(int) (((double) (model.getColumnCount() - 2) / 3)

78

+ 1);

79	Label footerLab = new Label(0, footerRow, "部门负责人：");

80	sheet.addCell(footerLab);

81	footerLab = new Label(step, footerRow, "制表：" + creatorTxfd.getText());

82	sheet.addCell(footerLab);

83	footerLab = new Label(model.getColumnCount() - 2, footerRow,

84	NazcaFormater.getSimpleDateString(new Date()));

85	sheet.addCell(footerLab);

86

87	sheet.setColumnView(0, 16);

88	sheet.setRowView(titleRow, 600);

89

90	book.write();

91	book.close();

92

//导出成功

93	} catch (Throwable ex) {

94

//导出报表失败

95	ex.printStackTrace();

96

}

11、Table的打印功能

打印这块，之前已经提过，可以参考之前的文章 JTable Print

12、在Table上选择多行

1	int rowcounts=table.getSelectedRows().length;

2	if(rowcounts>1)

3	int[] rows=table.getSelectedRows();

4	for(int i=0;i<rows.length;i++){

5	String value=(String) tableModel.getValueAt(i, 1);

6

}

7

}