@RequestMapping("/excel")
public void excel(HttpServletResponse response) throws Exception {
final String path = "C:\\Users\\29374\\Desktop\\新建 XLS 工作表.xls";
InputStream input = new FileInputStream(path);
HSSFWorkbook workbook = new HSSFWorkbook(input);
int number = workbook.getNumberOfSheets();
StringBuilder sb = new StringBuilder();
for (int i = 0; i < number; i++) {
// 不显示sheet名字
workbook.setSheetName(i, sb.append(" ").toString());
}
ExcelToHtmlConverter excelToHtmlConverter = new ExcelToHtmlConverter(DocumentBuilderFactory.newInstance().newDocumentBuilder().newDocument());
excelToHtmlConverter.setOutputColumnHeaders(false); // 不显示列的表头
excelToHtmlConverter.setOutputRowNumbers(false); // 不显示行的表头
excelToHtmlConverter.processWorkbook(workbook);
StringWriter writer = new StringWriter();
Transformer serializer = TransformerFactory.newInstance().newTransformer();
serializer.setOutputProperty(OutputKeys.ENCODING, "UTF-8");
serializer.setOutputProperty(OutputKeys.INDENT, "yes");
serializer.setOutputProperty(OutputKeys.METHOD, "html");
serializer.transform(new DOMSource(excelToHtmlConverter.getDocument()), new StreamResult(writer));
String content = writer.toString();
ServletOutputStream outStream = response.getOutputStream();
outStream.write(content.getBytes());
outStream.flush();
outStream.close();
}
Java使用poi预览去掉excel的sheet名字
最新推荐文章于 2022-08-15 15:35:53 发布