用java在IE中開啟Excel

xuehongliang發表於2007-06-29
JavaExcel

閒來無事做的一個小例子:

java 程式碼
  1. public class TestOpenExcel extends HttpServlet {
  3. private static final String url = "D:/test.xls";
  5. protected void doGet(HttpServletRequest request,
  6. HttpServletResponse response) throws ServletException, IOException {
  8. /**
  9. * setContentType設定MIME型別，Acrobat
  10. * PDF檔案為"application/pdf"，WORD檔案為："application/msword"，
  11. * EXCEL檔案為："application/vnd.ms-excel"。
  12. */
  13. response.setContentType("application/vnd.ms-excel");
  14. /**
  15. * setHeader設定開啟方式，具體為：inline為在瀏覽器中開啟，attachment單獨開啟。
  16. */
  17. response.setHeader("Content-disposition", "inline;filename="" + "test.xls"+ "";");
  19. ServletOutputStream sos = response.getOutputStream();
  20. FileInputStream fis = new FileInputStream(url);
  22. BufferedOutputStream bos = new BufferedOutputStream(sos);
  23. byte[] bytes = new byte[8192];
  24. bos.write(bytes, 0, fis.read(bytes));
  25. fis.close();
  26. sos.close();
  27. bos.close();
  30. }
  33. protected void doPost(HttpServletRequest request,
  34. HttpServletResponse response) throws ServletException, IOException {
  35. doGet(request, response);
  36. }
  38. }
[@more@]

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/800861/viewspace-922103/，如需轉載，請註明出處，否則將追究法律責任。

相關文章