写入execl

package utils.excel;

import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;
import org.apache.flink.api.java.tuple.Tuple5;

import java.io.*;
import java.util.List;

public class ExcelUtil {
  /**
     * 向Excel写入数据
     * @throws Exception
     */
    public static void writeExcel(String path, List<Tuple5<String,String,String,String,String>> tuple5s) throws IOException, RowsExceededException, WriteException {
        File f=new File(path);
        WritableWorkbook workbook= Workbook.createWorkbook(f);
        WritableSheet sheet=workbook.createSheet("Diction",0);
        Label lab = null;
        for (int i = 0; i < tuple5s.size(); i++) {
            Tuple5<String,String,String,String,String> tuple5Tmp = tuple5s.get(i);
            lab = new Label(0, i + 1, tuple5Tmp.f0);
            sheet.addCell(lab);
            lab = new Label(1, i + 1, tuple5Tmp.f1);
            sheet.addCell(lab);
            lab = new Label(2, i + 1, tuple5Tmp.f2);
            sheet.addCell(lab);
            lab = new Label(3, i + 1, tuple5Tmp.f3);
            sheet.addCell(lab);
            lab = new Label(4, i + 1, tuple5Tmp.f4);
            sheet.addCell(lab);
        }
        workbook.write();
        workbook.close();
    }
}
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值