Gridline missed in ASP generated Excel

[Utada P.W. SIU]

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~

[Manohar Kamath]

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~

[Manohar Kamath]

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

[Utada P.W. SIU]

o....thanks~ i just want to verify it cannot
Thanks
^.^