您应该可以使用Cell样式实现此目的,我尝试将一个示例组合起来显示:
public class SO{ public static void main(String[] args) { try { FileInputStream is = new FileInputStream(new File("D:\Users\user2777005\Desktop\bob.xlsx")); XSSFWorkbook wb = new XSSFWorkbook(is); String header = "123456789123456789123456789123456789123456789123456789123456789123456789123456789123456789123456789"; Sheet sheet = wb.getSheet("Sheet1"); sheet.setColumnWidth(0, 18000); Row row = sheet.createRow(0); Cell cell = row.createCell(0); if(header.length() > 50){ //Length of String for my test sheet.setColumnWidth(0, 18000); //Set column width, you'll probably want to tweak the second int CellStyle style = wb.createCellStyle(); //Create new style style.setWrapText(true); //Set wordwrap cell.setCellStyle(style); //Apply style to cell cell.setCellValue(header); //Write header } wb.write(new FileOutputStream(new File("D:\Users\user2777005\Desktop\bob.xlsx"))); } catch (IOException e) { e.printStackTrace(); } }}
祝好运!
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)