Export to Excel using Jsp

[Raghu Kalyan]

Hi , i have a jsp which has data and needs to be exported to excel sheet. I included the below two lines in my jsp, <%response.setContentType("application/vnd.ms-excel;charset=windows-1251");%> <%response.setHeader("Content-Disposition", "attachment; filename=downloadOrders.xls" );%> i have one column which stores data like 1.1,2.1,3.1,... But in english it is printing correctly when i switch to russian language through regional settings in my PC. It is printing like below, 01月01日 (for 1.1) 02月01日 (for 2.1) Can you please help to resolve this issue wheather i need to change the charset or need to modify the code. Thanks in advance

[Eric Pascarello]

Kalyan, Please check your private messages.

Eric

[Eric Pascarello]

Did you try to change the encoding and see what happens?

Eric

[Elie Hirschman]

Resurrecting this to share:
I combined simple techniques found here: http://rgagnon.com/javadetails/java-0586.html
and here: http://www.theserverside.com/discussions/thread.tss?thread_id=36310

1. Table data
Table data gets dynamically generated, and I surround it with a div tag:

    <div id="tableData">
  <table border="1"><tr>
  <th>SKU </th>
  <th>Highest total</th>
  <th>Second Highest total</th></tr>
<tr><td>Data 1</td><td>Data 2</td><td>Data 3</td></tr>
<tr><td>Data 121</td><td>Data 22</td><td>Data 33</td></tr>
</table>
  

2. Export button
on the page with my TABLE data, I add the following HTML:

    <form action="excel.jsp">
      <input type="hidden" id="tableHTML" name="tableHTML" value="" />
      <input type="hidden" id="fileName" name="fileName" value="<%= exportFileName%>" />
      <input type="submit" onclick="gotoExcel('tableData', 'tableHTML');" value="Export these results" />
  </form>  

3. Export Script
add this JS on top:

    <script type="text/javascript">
      function gotoExcel(elemId, frmFldId)
      {
          var obj = document.getElementById(elemId);
          var oFld = document.getElementById(frmFldId);
          oFld.value = obj.innerHTML;

      }
  </script>  

3. The JSP Export page
This new page excel.jsp does all the work:

  <%@ page import="java.io.PrintWriter" %>
<%@ page contentType="application/excel" language="java" %>

<%
   
    response.reset();
    response.setHeader("Content-type","application/xls");

    
    String fileName =  request.getParameter("fileName");
    response.setHeader("Content-disposition","inline; filename=" + fileName);

    PrintWriter op = response.getWriter();
    String CSV = request.getParameter("tableHTML");
    if (CSV == null)
    {
        CSV="NO DATA";
    }
    if (fileName == null)
{
    CSV="NO FILE NAME SPECIFIED";
}

op.write(CSV);
%>