Problem while loading JSP page in Excel

•

What is DaniWeb IT Discussion Community?

You're currently browsing the JSP section within the Web Development category of DaniWeb, a massive community of 456,512 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,694 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our JSP advertiser: Lunarpages JSP Web Hosting

Thread Tools Display Modes

Views: 1231 | Replies: 0

•

Join Date: Apr 2006

Posts: 2

Reputation: vijiruba is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

vijiruba

Offline

Newbie Poster

Problem while loading JSP page in Excel

Sep 24th, 2007

Hi,

I am trying to populate the JSP page content into Excel file. I am able to get this. But i have problem while trying to populate the string ("1/0") in Excel. This string is taken as date format in excel. But i want to display "1/0" as such.

Any suggestions !

I have copied my code below:

Help with Code Tags

(Toggle Plain Text)

<%@ page language="java" %>
<%@ page import= "com.ti.emktcommon.util.CommonUtil" %>
<%@ taglib uri="/WEB-INF/lib/struts-bean.tld" prefix="bean" %>
 <html>
<head>
	<title>Dummy Page</title>
</head>

<%	
	 response.setContentType("application/vnd.ms-excel; charset=utf-8");
	 response.setHeader ("Content-Disposition", "attachment;filename=dummyfile.xls");
	 String dummy = "1/0";
%>
 <body>
	 <table cellSpacing=1 cellPadding=2 width="100%" border=1>
		 <tbody>
			<tr>
				<td>dfgdfgdfg</td>
				<td><%= dummy  %>&nbsp;</td>
				<td>111111111</td>
			</tr>
			<tr>
				<td>trytyuu</td>
				<td><%= dummy %></td>
				<td>2222222</td>
			</tr>
			<tr>
				<td>dfgdfgdfg</td>
				<td><%= dummy %></td>
				<td>333333333</td>
			</tr>
		 </tbody>
	</table>
</body>
</html>

Regards,
Vijiruba