The server does not have MS office(Excel) installed on it. If I try to set the content type as ms-excel, it does not recognises it and what i get is junk code. Is there any way to read the excel without having MS office(Excel) installed on the server ?
I have a JSP page which gets data from the DB. I need to display the returned data displayed in an Excel sheet. Have put the following code at the start of the JSP page. <%@ page contentType = "application/vnd.ms-excel" %> <% response.setContentType("application/vnd.ms-excel"); %>
It does open the excel sheet , but the sheet is empty. There is no data.