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();
}
}
}
如上方法有个缺点就是无法显示图片。