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]

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.

 

[Utada P.W. SIU]

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