package com.walmart.aloha.productmanage.util; import org.apache.commons.lang.StringUtils; import org.apache.poi.hssf.usermodel.*; import org.apache.poi.ss.usermodel.Font; import org.apache.poi.ss.usermodel.HorizontalAlignment; import org.apache.poi.ss.usermodel.VerticalAlignment; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.xssf.usermodel.*; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.web.multipart.MultipartFile; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.BufferedOutputStream; import java.io.IOException; import java.io.InputStream; import java.io.OutputStream; import java.net.URLEncoder; public class ExcleUtils { private static final Logger logger = LoggerFactory.getLogger(ExcleUtils.class); public static void setCellValue(int index, String strValue, XSSFRow row) { XSSFCell cell; cell = row.createCell(index); cell.setCellValue( strValue ); } public static void setTitle(int[] colwidth1, String[] title, XSSFWorkbook wb, XSSFSheet sheet) { for (int i = 0; i < colwidth1.length; i++) { sheet.setColumnWidth(i, colwidth1[i]); } // 第三步,在sheet中添加表头第0行,注意老版本poi对Excel的行数列数有限制 XSSFRow row = sheet.createRow(0); // 第四步,创建单元格,并设置值表头 设置表头居中 XSSFC
poi导出 xlsx格式
最新推荐文章于 2022-08-11 16:45:26 发布