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
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
| package javaapplication120;
import java.io.*;
import javax.swing.table.TableModel;
import javax.swing.*;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.CellRangeAddress;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.util.RegionUtil;
public class ExcelExporter {
ExcelExporter() {
}
public void exportTable(JTable jTable1, File file) throws IOException {
FileOutputStream out = null;
Workbook wb = new HSSFWorkbook();
Sheet sheet = wb.createSheet("new sheet");
int colCount = jTable1.getColumnCount();
int colRow = jTable1.getRowCount();
Row row = null;
Cell cell = null;
TableModel model = jTable1.getModel();
out = new FileOutputStream(file);
String a[] = {"Наименование", "ед.изм"};
//экспорт заголовка таблицы
sheet.shiftRows(0, jTable1.getColumnCount(), 1);
sheet.addMergedRegion(new CellRangeAddress(0, 1, 0, 0));
sheet.addMergedRegion(new CellRangeAddress(0, 1, 1, 1));
for (int j = 0; j <= jTable1.getRowCount(); j++) {
row = sheet.createRow(j);
for (int i = 0; i < model.getColumnCount(); i++) {
cell = row.createCell(i);
cell.setCellValue(model.getColumnName(i).toString());
}
}
sheet.addMergedRegion(new CellRangeAddress(0, 0, 2, 3));
sheet.addMergedRegion(new CellRangeAddress(0, 0, 4, 5));
sheet.addMergedRegion(new CellRangeAddress(0, 0, 6, 7));
sheet.addMergedRegion(new CellRangeAddress(0, 0, 8, 9));
//экспорт данных из таблицы в ексель
for (int i = 0; i < jTable1.getRowCount(); i++) {
row = sheet.createRow(i + 2);
int f = jTable1.getColumnCount();
for (int j = 0; j < jTable1.getColumnCount(); j++) {
cell = row.createCell(j);
cell.setCellValue(jTable1.getValueAt(i, j).toString());
}
}
for (int k = 0; k < 1; k++) {
row = sheet.createRow(k);
for (int j = 0; j < 12; j++) {
if (j < 2) {
cell = row.createCell(j);
cell.setCellValue(a[j].toString());
} else {
cell = row.createCell(j);
switch (j) {
case 2:
cell.setCellValue("Остаток");
break;
case 4:
cell.setCellValue("Приход(ДТ)");
break;
case 6:
cell.setCellValue("Расход(КТ)");
break;
case 8:
cell.setCellValue("Остаток");
break;
default:
break;
}
}
}
}
//прорисовка границ в ексель
for (int y = 0; y <= colRow + 1; y++) {
for (int x = 0; x < colCount; x++) {
CellRangeAddress range = new CellRangeAddress(y, y, x, x);
RegionUtil.setBorderTop(CellStyle.BORDER_THIN, range, sheet, wb);
RegionUtil.setBorderRight(CellStyle.BORDER_THIN, range, sheet, wb);
RegionUtil.setBorderBottom(CellStyle.BORDER_THIN, range, sheet, wb);
RegionUtil.setBorderLeft(CellStyle.BORDER_THIN, range, sheet, wb);
}
}
for (int i = 0; i < colCount - 1; i++) {
setBorder(colRow, colCount);
sheet.autoSizeColumn(i);
}
sheet.setColumnWidth(0, 4000);
sheet.setVerticallyCenter(Boolean.TRUE);
wb.write(out);
out.close();
}
private void setBorder(int i, int j) {
Workbook wb = new HSSFWorkbook();
Sheet sheet = wb.createSheet("new sheet");
for (int y = 0; y <= i; y++) {
for (int x = 0; x < j; x++) {
CellRangeAddress range = new CellRangeAddress(y, y, x, x);
RegionUtil.setBorderTop(CellStyle.BORDER_THIN, range, sheet,
wb);
RegionUtil.setBorderRight(CellStyle.BORDER_THIN, range, sheet,
wb);
RegionUtil.setBorderBottom(CellStyle.BORDER_THIN, range, sheet,
wb);
RegionUtil.setBorderLeft(CellStyle.BORDER_THIN, range, sheet,
wb);
}
}
}
} |
(
