java excel to html,利用POI将Excel文档转换为Html

excel文档转换为html其实和word转html相类似，优点也很明显。请参考 word转html

作一新求抖直微圈

public static void convertExcel2Html(String excelFilePath,String htmlFilePath)

throws IOException,ParserConfigurationException,TransformerException

{

File excelFile = new File(excelFilePath);

File htmlFile = new File(htmlFilePath);

File htmlFileParent = new File(htmlFile.getParent());

InputStream is = null;

OutputStream out = null;

StringWriter writer = null;

try{

if(excelFile.exists()){

if(!htmlFileParent.exists()){

htmlFileParent.mkdirs();

}

is = new FileInputStream(excelFile);

HSSFWorkbook workBook = new HSSFWorkbook(is);

ExcelToHtmlConverter converter = new ExcelToHtmlConverter(DocumentBuilderFactory.newInstance().newDocumentBuilder().newDocument());

converter.processWorkbook(workBook);

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(converter.getDocument()),

new StreamResult(writer) );

out = new FileOutputStream(htmlFile);

out.write(writer.toString().getBytes("UTF-8"));

out.flush();

out.close();

writer.close();

}

}finally{

try{

if(is != null){

is.close();

}

if(out != null){

out.close();

}

if(writer != null){

writer.close();

}

}catch(IOException e){

e.printStackTrace();

}

}

}

享器哈班其础件事是架考发求关通互面待需了 如上方法有个缺点就是无法显示是能览调不页新代些事几求事都时学下是事功过图片。

本文来源于网络：查看 >https://blog.csdn.net/jsudavid/article/details/10381555