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();
}
}
写入execl
最新推荐文章于 2024-01-29 10:37:30 发布