java利用poi写入Excel
来源:互联网 发布:js confirm返回值 编辑:程序博客网 时间:2024/05/20 18:03
public void writeExcel(String url)
{
List<Synsetcn> list = sc.groupBySynsetId();
Set<String> chineseList = sc.getAllSynsetcn().getChineseList();
XSSFWorkbook workbook = new XSSFWorkbook();
XSSFSheet sheet = workbook.createSheet();
OutputStream os = null;
XSSFCellStyle style = workbook.createCellStyle();
XSSFFont font = workbook.createFont();
font.setColor(HSSFColor.RED.index);
style.setFont(font);
try {
os = new FileOutputStream(new File(url));
XSSFRow row1 = sheet.createRow(0);
XSSFCell cell1 = row1.createCell(0);
XSSFCell cell2 = row1.createCell(1);
cell1.setCellValue("词语");
cell2.setCellValue("同义词");
for (int rowIndex = 1; rowIndex <= list.size(); rowIndex++) {
XSSFRow row = sheet.createRow(rowIndex);
Synsetcn synsetcn = list.get(rowIndex-1);
for (int cellNum = 0; cellNum < 3; cellNum++) {
XSSFCell cell = row.createCell(cellNum);
switch (cellNum) {
case 0:
cell.setCellValue(synsetcn.getSynset_id());
break;
case 1:
cell.setCellValue(synsetcn.getChinese());
break;
case 2:
String sb = null;
for(String s : chineseList){
String chinese = s;
if(synsetcn.getChinese().contains(chinese)){
if(sb != null){
sb = sb + "||" + chinese;
}else{
sb = chinese;
}
}
}
cell.setCellValue(sb);
cell.setCellStyle(style);
}
}
}
workbook.write(os);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
{
List<Synsetcn> list = sc.groupBySynsetId();
Set<String> chineseList = sc.getAllSynsetcn().getChineseList();
XSSFWorkbook workbook = new XSSFWorkbook();
XSSFSheet sheet = workbook.createSheet();
OutputStream os = null;
XSSFCellStyle style = workbook.createCellStyle();
XSSFFont font = workbook.createFont();
font.setColor(HSSFColor.RED.index);
style.setFont(font);
try {
os = new FileOutputStream(new File(url));
XSSFRow row1 = sheet.createRow(0);
XSSFCell cell1 = row1.createCell(0);
XSSFCell cell2 = row1.createCell(1);
cell1.setCellValue("词语");
cell2.setCellValue("同义词");
for (int rowIndex = 1; rowIndex <= list.size(); rowIndex++) {
XSSFRow row = sheet.createRow(rowIndex);
Synsetcn synsetcn = list.get(rowIndex-1);
for (int cellNum = 0; cellNum < 3; cellNum++) {
XSSFCell cell = row.createCell(cellNum);
switch (cellNum) {
case 0:
cell.setCellValue(synsetcn.getSynset_id());
break;
case 1:
cell.setCellValue(synsetcn.getChinese());
break;
case 2:
String sb = null;
for(String s : chineseList){
String chinese = s;
if(synsetcn.getChinese().contains(chinese)){
if(sb != null){
sb = sb + "||" + chinese;
}else{
sb = chinese;
}
}
}
cell.setCellValue(sb);
cell.setCellStyle(style);
}
}
}
workbook.write(os);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
- java利用poi写入Excel
- Java POI 写入Excel
- Java POI 写入Excel
- Java POI 写入Excel
- Java POI 写入Excel
- 利用poi组件写入excel
- java利用poi创建excel文件并写入数据
- 利用poi将数据写入到excel
- java利用poi读取excel
- java利用poi读取excel
- java利用poi读取excel
- Java 利用poi 导出Excel
- java利用POI操作excel
- java利用poi操作excel
- java利用POI向Excel(xls)写入图片,并对图片引用超链接
- Java POI 写入Excel 完整代码
- 【Apache POI】Java写入Excel文件
- java使用poi来写入excel
- 将一个库里的一张表中的数据复制到另一个库的一张表中
- ArcGIS Server 学习启程求助
- Java中用内存映射处理大文件
- XP设置远程桌面
- MyEclipse里编辑的项目名的红叉,解决方法
- java利用poi写入Excel
- The run destination My Mac 64-bit is not valid for Running the scheme 'MultiTouchDemo'
- Lambda表达式
- 使用ant自动化编译、签名、代码混淆Android项目
- 指针懂了吗?
- android 中使用socket使native和framework通信
- 【珍藏】 2012Android开发热门资料(110个)
- 软件管理方案模版
- GBin1在线实例帮助你更好的了解jQuery功能特性(一)