利用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();
			}
		}
	}

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




评论 5
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值