POI设置EXCEL单元格格式为文本Word文档下载推荐.docx
- 文档编号:20934547
- 上传时间:2023-01-26
- 格式:DOCX
- 页数:16
- 大小:60.53KB
POI设置EXCEL单元格格式为文本Word文档下载推荐.docx
《POI设置EXCEL单元格格式为文本Word文档下载推荐.docx》由会员分享,可在线阅读,更多相关《POI设置EXCEL单元格格式为文本Word文档下载推荐.docx(16页珍藏版)》请在冰豆网上搜索。
*/
19.public
Cachetable()
{
20.}
21./**
full
22.public
Cachetable(int
recnum,
devIp,
srcaddr,
dstaddr,
nexthop,
input,
output,
dpkts,
doctets,
sstart,
dstport,
prot,
tos,
srcas,
dstas,String
pduversion)
23.
this.recnum
=
24.
this.devIp
25.
this.srcaddr
26.
this.dstaddr
27.
this.nexthop
28.
this.input
29.
this.output
30.
this.dpkts
31.
this.doctets
32.
this.sstart
33.
this.dstport
34.
this.prot
35.
this.tos
36.
this.srcas
37.
this.dstas
38.
this.pduversion
39.}
40.public
getRecnum()
41.
return
this.recnum;
42.}
43.public
void
setRecnum(int
recnum)
44.
this.recnum=
45.}
46.public
getDevIp()
47.
this.devIp;
48.}
49.public
setDevIp(String
devIp)
50.
51.}
52.public
getSrcaddr()
53.
this.srcaddr;
54.}
55.public
setSrcaddr(String
srcaddr)
56.
57.}
58.public
getDstaddr()
59.
this.dstaddr;
60.}
61.public
setDstaddr(String
dstaddr)
62.
63.}
64.public
getNexthop()
65.
this.nexthop;
66.}
67.public
setNexthop(String
nexthop)
68.
69.}
70.public
getInput()
71.
this.input;
72.}
73.public
setInput(String
input)
74.
75.}
76.public
getOutput()
77.
this.output;
78.}
79.public
setOutput(String
output)
80.
81.}
82.public
getDpkts()
83.
this.dpkts;
84.}
85.public
setDpkts(String
dpkts)
86.
87.}
88.public
getDoctets()
89.
this.doctets;
90.}
91.public
setDoctets(String
doctets)
92.
93.}
94.public
getSstart()
95.
this.sstart;
96.}
97.public
setSstart(String
sstart)
98.
99.}
100.public
getDstport()
101.
this.dstport;
102.}
103.public
setDstport(String
dstport)
104.
105.}
106.public
getProt()
107.
this.prot;
108.}
109.public
setProt(String
prot)
110.
111.}
112.public
getTos()
113.
this.tos;
114.}
115.public
setTos(String
tos)
116.
117.}
118.public
getSrcas()
119.
this.srcas;
120.}
121.public
setSrcas(String
srcas)
122.
123.}
124.public
getDstas()
125.
this.dstas;
126.}
127.public
setDstas(String
dstas)
128.
129.}
130.public
getPduversion()
131.
this.pduversion;
132.}
133.public
setPduversion(String
134.
135.}
第二部分:
具体的POI操作生成EXCEL类
【我这里只是个示例,没连数据库,直接运行即可,如果想连,稍微变动一点即可】
1.package
;
2.import
3.import
4.import
5.import
6.import
7.import
8.import
9.import
10.import
11.import
12.import
13.import
14.import
15.import
16.import
17.import
18.public
class
ExcelOut
{
19.
//表头
20.
public
static
final
String[]
tableHeader
{"
序号"
"
版本"
接收时刻"
设备"
入接口"
出接口"
21.
"
源IP"
目的IP"
下一跳"
协议"
端口"
对端端口"
TOS"
源AS"
目的AS"
TCP_FLAG"
pad1"
pad2"
};
22.
//创建工作本
TOS
HSSFWorkbook
demoWorkBook
new
HSSFWorkbook();
//创建表
HSSFSheet
demoSheet
demoWorkBook.createSheet("
The
World'
s
500
Enterprises"
);
//表头的单元格个数目
short
cellNumber
(short)tableHeader.length;
//数据库表的列数
columNumber
1;
/**
*
创建表头
@return
createTableHeader()
HSSFHeader
header
demoSheet.getHeader();
header.setCenter("
世界五百强企业名次表"
HSSFRow
headerRow
demoSheet.createRow((short)
0);
39.
for(int
i
0;
<
cellNumber;
i++)
40.
HSSFCell
headerCell
headerRow.createCell((short)
i);
42.
headerCell.setCellType(HSSFCell.CELL_TYPE_STRING);
43.
headerCell.setCellValue(tableHeader[i]);
}
45.
46.
创建行
48.
@param
cells
49.
rowIndex
51.
createTableRow(List<
String>
cells,short
rowIndex)
52.
//创建第rowIndex行
54.
row
rowIndex);
55.
cells.size();
57.
//创建第i个单元格
58.
cell
row.createCell(i);
if(cell.getCellType()!
=1){
60.
cell.setCellType(HSSFCell.CELL_TYPE_STRING);
61.
}
//新增的四句话,设置CELL格式为文本格式
63.
HSSFCellStyle
cellStyle2
demoWorkBook.createCellStyle();
64.
HSSFDataFormat
format
demoWorkBook.createDataFormat();
cellStyle2.setDataFormat(format.getFormat("
@"
));
66.
cell.setCellStyle(cellStyle2);
67.
cell.setCellValue(cells.get(i));
69.
70.
/**
72.
USE:
用于获取Cachetable的数据。
。
假数据。
到时候:
你连接数据库的到List<
Cachetable>
的数据就行了。
共生成
73.
100条数据.相当于100行
75.
@return
76.
List<
getDate()
78.
cacheList
ArrayList<
();
79.
for
(int
j
300;
j++)
Cachetable
tb
Cachetable();
81.
tb.setRecnum(j
+
1);
82.
tb.setDevIp("
JavaCrazyer"
tb.setSrcaddr("
北京"
84.
tb.setDstaddr("
xxx"
85.
tb.setNexthop("
yy"
tb.setInput("
123"
87.
tb.setOutput("
88.
tb.setDpkts("
what
are
you
doing?
tb.setDoctets("
who
you?
90.
tb.setSstart("
Oh
sure!
91.
tb.setProt("
One"
tb.setTos("
two"
93.
tb.setSrcas("
three"
94.
tb.setDstas("
four"
tb.setPduversion("
不知道"
96.
cacheList.add(tb);
97.
cacheList;
99.
100.
创建整个Excel表
102.
@throws
SQLException
103.
105.
createExcelSheet()
throws
SQLException{
106.
createTableHeader();
rowIndex=1;
108.
list=getDate();
109.
j=0;
j<
list.size();
j++){
listRead=new
111.
i=1;
i<
=columNumber;
i++){
112.
listRead.add(list.get(i).getDevIp());
listRead.add(list.get(i).getSrcaddr());
114.
listRead.add(list.get(i).getDstaddr());
115.
listRead.add(list.get(i).getNexthop());
listRead.add(list.get(i).getInput());
117.
listRead.add(list.get(i).getOutput());
118.
listRead.add(list.get(i).getDpkts());
listRead.add(list.get(i).getDoctets());
120.
listRead.add(list.get(i).getSstart());
121.
listRead.add(list.get(i).getProt());
listRead.add(list.get(i).getTos());
123.
listRead.add(list.get(i).getSrcas());
124.
listRead.add(list.get(i).getDstas());
listRead.add(list.get(i).getPduversion());
126.
listRead.add(rowIndex+"
127.
createTableRow(listRead,(short)rowIndex);
129.
r
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- POI 设置 EXCEL 单元格 格式 文本
![提示](https://static.bdocx.com/images/bang_tan.gif)