poi将xls转为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();

}

}

}

如上方法有个缺点就是无法显示图片。