• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 176
  • Last Modified:

Show Data on browser using Excel component

Here is the flow I do:
Using a .xls file to get data from database (using xsql:query).
Fill that data in a .xsl Style Sheet file.
Show that .xls file on the web.

Please tell me how to config the web server .My web server is Weblogic 6.1 or 7.0 to run that.

Thank you very much
1 Solution
You need not configure web server. The page writing to an excel file should have content type set as. Assuming u are working in jsp/weblogic
<% response.setContentType("application/vnd.ms-excel");%>

Now run the query and process the resultset. Print the required field from resultset into excel columns.
This question has been classified abandoned. I will make a recommendation to the
moderators on its resolution in a week or two. I appreciate any comments
that would help me to make a recommendation.

Unless it is clear to me that the question has been answered I will recommend delete.  It is possible that a Grade less than A will be given if no expert makes a case for an A grade. It is assumed that any participant not responding to this request is no longer interested in its final disposition.

If the user does not know how to close the question, the options are here:



Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now