Response.ContentType = "application/vnd.ms-excel" Help Please...

[steve02a]

I'm using the Response.ContentType = "application/vnd.ms-excel" in my web
application to export data into a spreadsheet. That works fine and all.

My question is: When I export the data and go and view the spreadsheet -
there are no grid lines. They all disappeared so it's like my data is on one
giant white slab of nothing. I can read the data and see how each piece is
in it's own cell - but no gridlines. Is there anything else I can add in the
Response.ContentType = "application/vnd.ms-excel" section to get the
gridlines to show?

Thanks (and I apologize if this isn't the correct newsgroup to ask this).

[Andrew Robinson]

Steve,

I have struggled with this for years. About the only solution that I have
found is to add borders to your <table> elements (rows and cells).

Now, I am sure that someone will proove me wrong.

I certainly don't think there is anything that you can change related to
your ContentType.

--

Andrew Robinson
www.binaryocean.com
www.bellinghamdotnet.org
"steve02a" <st******@discussions.microsoft.com> wrote in message
news:03**********************************@microsof t.com...

I'm using the Response.ContentType = "application/vnd.ms-excel" in my web
application to export data into a spreadsheet. That works fine and all.

My question is: When I export the data and go and view the spreadsheet -
there are no grid lines. They all disappeared so it's like my data is on
one
giant white slab of nothing. I can read the data and see how each piece
is
in it's own cell - but no gridlines. Is there anything else I can add in
the
Response.ContentType = "application/vnd.ms-excel" section to get the
gridlines to show?

Thanks (and I apologize if this isn't the correct newsgroup to ask this).

[steve02a]

I'll play around w/borders on my <table> stuff and see if I can get it nicer
looking than it is now (or I could stop bashing myself in the head and live
w/no gridlines)
"Andrew Robinson" wrote:

Steve,

I have struggled with this for years. About the only solution that I have
found is to add borders to your <table> elements (rows and cells).

Now, I am sure that someone will proove me wrong.

I certainly don't think there is anything that you can change related to
your ContentType.

--

Andrew Robinson
www.binaryocean.com
www.bellinghamdotnet.org
"steve02a" <st******@discussions.microsoft.com> wrote in message
news:03**********************************@microsof t.com...

I'm using the Response.ContentType = "application/vnd.ms-excel" in my web
application to export data into a spreadsheet. That works fine and all.

My question is: When I export the data and go and view the spreadsheet -
there are no grid lines. They all disappeared so it's like my data is on
one
giant white slab of nothing. I can read the data and see how each piece
is
in it's own cell - but no gridlines. Is there anything else I can add in
the
Response.ContentType = "application/vnd.ms-excel" section to get the
gridlines to show?

Thanks (and I apologize if this isn't the correct newsgroup to ask this).