package springboot;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.xwpf.usermodel.*;
import org.openxmlformats.schemas.wordprocessingml.x2006.main.CTTblWidth;
import org.openxmlformats.schemas.wordprocessingml.x2006.main.STMerge;
import org.openxmlformats.schemas.wordprocessingml.x2006.main.STTblWidth;
import java.io.*;
import java.math.BigInteger;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
public class exportWord {
public static void main(String[] args) {
File file = new File("D:\\chrom\\1.xlsx");
List<List<String>> l = importExcel(file);
List<List<String>> rows = new ArrayList<>();
int total = 0;
for (List<String> list:l) {
total+=Integer.parseInt(list.get(4));
}
int count = 0;
for (List<String> list:l) {
count++;
List<String> row = new ArrayList<>();
row.add(list.get(8));
row.add(count+"."+list.get(3)+"("+list.get(4)+"h,一般)");
row.add(total+"h");
rows.add(row);
}
exportWord(rows, "2018年10月工作总结");
}
//导出word
public static void exportWord(List<List<String>> list,String name) {
try {
XWPFDocument doc= new XWPFDocument();
//添加标题
读取excel内容,写入word表格
最新推荐文章于 2021-03-05 17:31:59 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)