469,281 Members | 2,486 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,281 developers. It's quick & easy.

Gridline missed in ASP generated Excel

Dear All,

I have writing a ASP that export an Excel file by using response.contentType
= "application/vnd.ms-excel"
I can export an Excel

However, the grey color gridline is missed, how can I display it again?
I won't draw table and set it's border = 1 since there have up to 65536 row
in Excel....

Thanks~
Jul 19 '05 #1
3 1734
Since you are simulating a Excel file, and not writing a real Excel file,
you can not control any properties that you would control with traditional
Excel files. However, if you are writing the file as a table, try changing
border colors, that usually makes a difference

<table bordercolor="#000000">
</table<

--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"Utada P.W. SIU" <wi******@hotmail.com> wrote in message
news:Oc**************@TK2MSFTNGP09.phx.gbl...
Dear All,

I have writing a ASP that export an Excel file by using response.contentType = "application/vnd.ms-excel"
I can export an Excel

However, the grey color gridline is missed, how can I display it again?
I won't draw table and set it's border = 1 since there have up to 65536 row in Excel....

Thanks~

Jul 19 '05 #2
From what I know about the topic -- no. Since Excel supports many rows (I
think 65,000+) and your table is limited, the only way to color beyond the
data is to actually have that many table rows.

--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"Utada P.W. SIU" <wi******@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...
Hi Kamath,

Thanks for your help. I know using bordercolor property can control the
border color of table
However, can I control the border outside the table, please refer to
attachment. Thanks

Jul 19 '05 #3
o....thanks~ i just want to verify it cannot
Thanks
^.^
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Ken Ingram | last post: by
2 posts views Thread by Tracey | last post: by
1 post views Thread by Lonewolf | last post: by
6 posts views Thread by gerry.brennan | last post: by
4 posts views Thread by MangroveRoot | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.