java分组写入Excel
来源:互联网 发布:linux vim 复制 编辑:程序博客网 时间:2024/06/11 03:23
public void writeExcel(String url)
{
List<List<Synsetcn>> dataList = sc.getGroupList();
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));
int rowIndex = 1;
for (List<Synsetcn> list : dataList) {
for (Synsetcn synsetcn :list){
XSSFRow row = sheet.createRow(rowIndex);
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.getSynset_id().startsWith("7"))
{
if(synsetcn.getChinese().contains(chinese))
{
if(sb != null)
{
sb = sb + "||" + chinese;
}
else
{
sb = chinese;
}
}
}
}
cell.setCellValue(sb);
cell.setCellStyle(style);
}
}
rowIndex++;
}
rowIndex++;
}
workbook.write(os);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
{
List<List<Synsetcn>> dataList = sc.getGroupList();
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));
int rowIndex = 1;
for (List<Synsetcn> list : dataList) {
for (Synsetcn synsetcn :list){
XSSFRow row = sheet.createRow(rowIndex);
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.getSynset_id().startsWith("7"))
{
if(synsetcn.getChinese().contains(chinese))
{
if(sb != null)
{
sb = sb + "||" + chinese;
}
else
{
sb = chinese;
}
}
}
}
cell.setCellValue(sb);
cell.setCellStyle(style);
}
}
rowIndex++;
}
rowIndex++;
}
workbook.write(os);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
- java分组写入Excel
- Java写入Excel文件
- Java写入Excel文件
- Java写入Excel
- Java写入Excel
- Java-------写入excel
- Java POI 写入Excel
- Java POI 写入Excel
- Java POI 写入Excel
- Java写入Excel
- Java写入Excel
- Java写入Excel文件
- Java POI 写入Excel
- java读取和写入EXCEL
- java写入excel表格模板
- java利用poi写入Excel
- java写入Excel文本换行
- Java读取和写入Excel
- java在集合中对集合进行分组
- 在MFC控件中显示opencv库中的图像或者视频用的CvvImage
- latex 笔记1
- uploadify一个好用的jquery上传插件
- 我现在用C语言实现了YUV420到RGB的转换,现在要根据这个C写verilog,怎么写?
- java分组写入Excel
- 重视基础,做个有远见的人
- 一个关于响应CPropertySheet “OK”按钮(确认)按钮的方法试验
- 常见UI设计模式
- 价格奥秘-在超市遇见亚当斯密--第一章地震时趁机涨价的超市才最公平?
- 转的
- C#反射 与 枚举类型
- Android的BUG,一个频繁重启问题
- 关于在c#中嵌入sql代码的问题