HI All,
I have write program which can convert
jsp to excel format & i use MIME type is <%@ page contentType="application/vnd.ms-excel" %>.
Now a days my company use open office 2.4. So my program is failed to convert open office(spreadsheet) format.
Can anybody help me to tell which
MIME type i can use to solve this.
Following is my program.
<%@ page contentType="application/vnd.ms-excel" %>
<%@ page language="java" %>
<%@ page import="java.sql.*" %>
........................
.......................
<% PreparedStatement ps=null;
Connection con=null;
ResultSet rs=null;
int m=0;
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@172.16.90.139:1531:PROD","apps","apps");
String f_date=request.getParameter("f_date");
String t_date=request.getParameter("t_date");
ps=con.prepareStatement("SELECT PV.VENDOR_NAME VNAME,FV.DESCRIPTION STATE,to_char(AIA.GL_DATE,'dd-mon-yyyy') GL_DATE,to_char
......................
.......................
ps.setString(1,f_date);
ps.setString(2,t_date);
rs=ps.executeQuery();
%>
</table>
</body>
</html