java如何识别excle合并的单元格，如何实现word的自动换行
利用POI处理，自动换行的话，如果是表格外面直接'\n'就行，如果是表格里面，必须用(char)11，下面是一段读取Excel生成word的代码，你可以参考下
读取Excel
public ArrayList
ArrayList<Table> list = null;
String suffix = excelPath.substring(excelPath.lastIndexOf(".")+1);
if(suffix.equals("xls")){
HSSFWorkbook workbook = null;
workbook = new HSSFWorkbook(is);
if(workbook != null){
HSSFSheet sheet = workbook.getSheetAt(1);//获取第二张表
if(sheet == null){
System.out.println();
return null;
}
list = new ArrayList<Table>();
int combineLines = 1;
int number = 1;
//读取行
for (int rowNum = 3; rowNum < sheet.getLastRowNum(); rowNum+=combineLines) {
HSSFRow row = sheet.getRow(rowNum);
if (row == null) continue;
Table tb = new Table();
tb.setNumber("3.1." + number);
tb.setTestData(row.getCell(0).toString());
tb.setTitle(row.getCell(1).toString());
//Word换行主要有两大类，一类是表格单元格文本的换行，另一类是表格之外的文本的换行。对于表格外的文本我们可以使用“\r”或者“(char)11”来换行，然而对于表格内的文本我们只能使用“(char)11”来进行换行操作。
tb.setFunctionPoint(row.getCell(2).toString().replace('\n', (char)11));
combineLines = isMergedRegion(sheet, rowNum, 1);
String process = "";
String conclusion = "";
Set<String> s = new HashSet<String>();
for (int i = rowNum; i< rowNum + combineLines; i++) {
//步骤
HSSFRow r1 = sheet.getRow(i);
process += r1.getCell(5).toString() + (char)11;
//结果
String result = r1.getCell(7).toString();
s.add(result);
}
if(s.contains("未通过")){
conclusion = "未通过";
}else if(s.contains("无法测试")){
conclusion = "无法测试";
}else if(s.contains("不涉及")){
conclusion = "不涉及";
}else{
conclusion = "通过";
}
tb.setProcess(process);
tb.setConclusion(conclusion);
number++;
list.add(tb);
}
}
}
if(suffix.equals("xlsx")){
XSSFWorkbook workbook = null;
workbook = new XSSFWorkbook(is);
if(workbook != null){
XSSFSheet sheet = workbook.getSheetAt(1);
if(sheet == null){
System.out.println();
return null;
}
list = new ArrayList<Table>();
int combineLines = 1;
//读取行
for (int rowNum = 3; rowNum < sheet.getLastRowNum(); rowNum+=combineLines) {
XSSFRow row = sheet.getRow(rowNum);
if (row == null) continue;
Table tb = new Table();
tb.setTestData(row.getCell(0).toString());
tb.setTitle(row.getCell(1).toString());
//Word换行主要有两大类，一类是表格单元格文本的换行，另一类是表格之外的文本的换行。对于表格外的文本我们可以使用“\r”或者“(char)11”来换行，然而对于表格内的文本我们只能使用“(char)11”来进行换行操作。
tb.setFunctionPoint(row.getCell(2).toString().replace('\n', (char)11));
combineLines = isMergedRegion(sheet, rowNum, 1);
String process = "";
String conclusion = "通过";
for (int i = rowNum; i< rowNum + combineLines; i++) {
//步骤
XSSFRow r1 = sheet.getRow(i);
process += r1.getCell(5).toString() + (char)11;
//结果
String result = r1.getCell(7).toString();
if(result.equals("不涉及")){
conclusion = "不涉及";
}
if(result.equals("无法测试")){
conclusion = "无法测试";
}
if(result.equals("未通过")){
conclusion = "未通过";
}
}
tb.setProcess(process);
tb.setConclusion(conclusion);
list.add(tb);
}
}
}
return list;
}
填充word模板，并合并多个word文档，合并文档POI好像没有，我用的Aspose，，也蛮强大的
public String generateWord(List<Table> list, String wordTemplatePath, String outputPath) throws Exception{
ArrayList<String> tempList = new ArrayList<String>();
for(int i=0; i < list.size(); i++){
FileInputStream in = new FileInputStream(wordTemplatePath);
HWPFDocument document = new HWPFDocument(in);
Table tb = list.get(i);
Map<String,String> params = new HashMap();
params.put("${title}", tb.getTitle());
params.put("${functionPoint}", tb.getFunctionPoint());
params.put("${conclusion}", tb.getConclusion());
params.put("${testData}", tb.getTestData());
params.put("${process }", tb.getProcess());
params.put("${number}", tb.getNumber());
Range range = document.getRange();
// 替换读取到的 word 模板内容的指定字段
for(Map.Entry<String,String> entry:params.entrySet()){
range.replaceText(entry.getKey(),entry.getValue());
}
String savePath = outputPath +UUID.randomUUID() + ".doc";
document.write(new File(savePath));
document.close();
tempList.add(savePath);
}
return mergeDoc(tempList, outputPath);
}
public String mergeDoc(ArrayList<String> list, String outputPath) throws Exception{
// License lic = new License();
// lic.setLicense((InputStream)null);//设置license，非试用
String uuid = UUID.randomUUID() + ".doc";
String savePath = outputPath + uuid;
Document doc = new Document();
doc.removeAllChildren();
for (int i = 0; i < list.size(); i++) {
Document srcDoc = new Document(list.get(i));
doc.appendDocument(srcDoc, ImportFormatMode.KEEP_SOURCE_FORMATTING);
File f = new File(list.get(i));
f.delete();
}
doc.save(savePath);
return uuid;
}
参考下这个https://blog.csdn.net/a919423654/article/details/68946507