Excel Cell Formatting From ASP

[BettyM]

Trying to generate an Excel spreadsheet with formatted cell background colors, borders and sizes plus font calls via ASP on my web server.

I can get the Excel spreadsheet to generate and display but I am having a hard time with formatting the Excel spreadsheet. Any good articles, software tools or "how to" suggestions?

 

[mtarby]

I'm sorry I can't answer your question, but could you tell me how you generated the spreadsheet? I just started browsing around looking for how to accomplish that very thing.

Thanks.

 

[mtarby]

I found my answer. In my travels I came across this, but didn't know if it would help:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnasdj01/html/asp0193.asp

 

[BettyM]

Here is another great article on the subject:

http://www.4guysfromrolla.com/webtech/051502-1.shtml

From what I read, I might need to get the add on they suggest to easily and quickly format cells.

Just seeing if anyone knows a better way. This article is the best I found so far but it doesn't talk about controlling the look of the Excel spreadsheet.

My clients have Excel so I could dump my data and issue a macro to make it pretty but still trying to find a good way with ASP.