Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa JSP-Servlet How to export chart(graph) generated by jsp into a excel?
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Abinesh
How to export chart(graph) generated by jsp into a excel?
1 Answer(s)      a year and 7 months ago
Posted in : JSP-Servlet


How to export chart(graph) generated by jsp into a excel? I have a jsp page which generates charts . Now I need those charts to be exported into an excel.please help


Advertisement
View Answers

May 24, 2013 at 5:48 PM


hi friend,

you may use apache poi for exporting the chart into excel generated at JSP. You can try the following code which exports the chart data value into the excel sheet, may this will be helpful for you.

 <%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">

<%@ page  import="java.awt.*" %>
<%@ page import = "java.util.* "%>
<%@ page  import="java.io.*" %>
<%@ page  import="org.jfree.chart.*" %>
<%@ page  import="org.jfree.chart.entity.*" %>
<%@ page  import ="org.jfree.data.general.*"%>
<html>
  <head>
  <meta http-equiv="Content-Type" 
  content="text/html; charset=UTF-8">
  <title>JSP Page</title>
  </head>
  <body>
<%
  final DefaultPieDataset data = new DefaultPieDataset();
  data.setValue("One", new Double(43.2));
  data.setValue("Two", new Double(10.0));
  data.setValue("Three", new Double(27.5));
  data.setValue("Four", new Double(17.5));
  data.setValue("Five", new Double(11.0));
  data.setValue("Six", new Double(19.4));

  JFreeChart chart = ChartFactory.createPieChart
  ("Pie Chart ", data, true, true, false);  
 try {
 final ChartRenderingInfo info = new 
  ChartRenderingInfo(new StandardEntityCollection());

 ServletContext context = this.getServletContext();
 String path = context.getRealPath("chartExample/web");
  final File file1 = new File(path+"/piechart.png"); 
  if(!file1.exists())
  {
      file1.createNewFile();
  }  
  ChartUtilities.saveChartAsPNG(
   file1, chart, 600, 400, info);
  } catch (Exception e) {
  out.println(e);
  }  
%>
<%
%>
  <IMG SRC="/jspExample/chartExample/web/piechart.png" WIDTH="600" HEIGHT="400" 
   BORDER="0">
   <%
   int i = data.getItemCount();  
   %>
   <table border="1">
   <tr>
   <td>Chart Slice</td><td>Slice Data</td>
   </tr>
   <%   
   for(int j = 0; j<i; j++)
   {
       %>
      <tr>
      <td><%=data.getKey(j)%></td>
      <td><%=data.getValue(j)%></td>
      </tr>       
      <%
   }
   %>
    </table>
   <%       
        String excel = request.getParameter("excel");       
        if (excel != null
                && excel.toString().equalsIgnoreCase("YES")) {
            response.setContentType("application/vnd.ms-excel");
            response.setHeader("Content-Disposition", "inline; filename="
                    + "chartData.xls"); 
        }
    %>
    <%
        if (excel == null) {            
    %>
    <a href="jspPieChart.jsp?excel=YES">Export Data To Excel Sheet</a>
    <%
        }
    %>  
  </body>
</html>


Related Tutorials/Questions & Answers:
Advertisements
 

 

 

DMCA.com