How to export chart(graph) generated by jsp into a excel?

How to export chart(graph) generated by jsp into a excel?

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

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:
How to export chart(graph) generated by jsp into a excel?
Export chart to JPEG file
Advertisements
How to show database values into graph using jsp?
How to show database values into graph using jsp?
How to export data from jsp to excel sheet by using java
make chart or graph from database - Java Beginners
Generated java file - JSP-Servlet
how to create bar chart in jsp using msaccess database
line chart from database in jsp
hybrid graph (jfree chart) - Swing AWT
how to create a bar chart in jsp by fetching value from oracle databse?
Bar Chart using JSP and tooltip to be implemented
Bar Chart in JSP - JSP-Servlet
Generated java file - JSP-Servlet
How to export web page to excel using java or jsp or servlets
Pie chart on jsp
How to create bar chart using database values
Dynamin Jfree chart in jsp---error
export jsp page - JSP-Servlet
statistical graph in jsp - JSP-Servlet
how to write the coding for converting the database data for example population into any type of graph using jsp and servlets?//
export to excel - JSP-Servlet
create chart - JSP-Servlet
export value in csv from jsp
Clearing the output on the web page generated by a jsp
export
draw the running or moving graph using database in jsp
draw the running or moving graph using database in jsp
Draw graph using jsp without database connection
Create a Pie Chart in jsp Page using JFree Chart
how to generate a bar chart on a JSP PAGE using the arraylist object passed form the servlet.(using jfreechart)
design chart takes data from database and through jsp page
Is ExcelR good for data science?
how to fetch data from mysql database table and draw a bar chart on that data using in jsp
create bar chart in jsp using msaccess database
Create a pie chart in jsp page using JFreeChart
JFree 3D Bar Chart not displaying in JSP - Java3D
How to export grid into excel
How to draw pie chart in J2ME
JFreechart multi line chart help in JSP
Create area chart in JSP page using JFreeChart
Insert value of dynamic generated text box in jsp using javascript
create bar chart in jsp using msaccess database
export data to excel sheet - JSP-Servlet
Create a bar chart in JSP page using JFreeChart
Draw Statistical chart in jsp
How to show database values in Graph.(Like Cricket score board Graph)
display combination of a stacked area chart and line chart in one iframe using jfree - JSP-Servlet
How to export the table content from an webpage to excel using java?
How to export the table content from an webpage to excel using java?

Ads