Formatting of Excel in browser

IanS1 · Apr 17, 2002

I have a page that I'm displaying in Excel, using
<%response.ContentType = "application/vnd.ms-excel" %>.
I need to know how to format the spreadsheet, to show gridlines, specify word-wrap on columns and the like.

Rather than post a lot of code, I'll use this example from W3schools (

http://www.w3schools.com/asp/prop_contenttype.asp):

<%response.ContentType="application/vnd.ms-excel"%>
<html>
<body>
<table>
<tr>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
</tr>
<tr>
<td>5</td>
<td>6</td>
<td>7</td>
<td>8</td>
</tr>
</table>
</body>
</html>

Go gentle on me - this is my first post (and I don't claim to be anything other than a beginner in ASP !).
Many thanks in anticipation.

RushiShroff · Apr 17, 2002

well i can not give you exact directions but still

http://www.codeave.com

has good example for this. Rushi Shroff Rushi@emqube.com
"Life is beautiful."

IanS1 · Apr 18, 2002

Thanks for your help, RushiShroff.
On the supplied site is there is an index of helpful code. On that index, the reference to "Output to MSExcel" (

http://www.codeave.com/asp/code.asp?u_log=40)

contains a Response.ContentType and is similar to other examples on this forum. The reference "ASP to MSWord" (

http://www.codeave.com/asp/code.asp?u_log=129)

is similar again, but doesn't appear to do any formatting. The one I think you're pointing me to is "Create XL from Form Input" (

http://www.codeave.com/asp/code.asp?u_log=148),

which mentions the gridlines, but I don't get the gridlines displayed when I try the example. Is there something I'm doing wrong with that example, or am I even looking in the right place?
Any further guidance greatly welcome!!

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Formatting of Excel in browser

IanS1

Programmer

RushiShroff

Programmer

IanS1

Programmer

Similar threads

Part and Inventory Search

Sponsor