467,925 Members | 1,931 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

ASP export excel

Accurary, I just change the contenttype of the asp to
"application/vnd.ms-excel"

but my question is that, how to default the cell font to Arial?

Now, it is defaulted to "Time News Roman", and I have tried using
<font face="Arial">
and stylesheet

but sees cannot, please advise~

thanks~
Jul 22 '05 #1
  • viewed: 1723
Share:
2 Replies

Utada P.W. SIU wrote:
Accurary, I just change the contenttype of the asp to
"application/vnd.ms-excel"

but my question is that, how to default the cell font to Arial?

Now, it is defaulted to "Time News Roman", and I have tried using
<font face="Arial">
and stylesheet

but sees cannot, please advise~


See the following

http://msdn.microsoft.com/library/de...ml/ofxml2k.asp

You can do LOTS of cool stuff moving from ASP to Excel. We now use
Excel as our report writer tool. Once you know what's going on with
OFHTML it's a snap.

I often will open an Excel doc, enter my data into a cell, format it
the way I want it to work, Save As HTML and look at the source to see
what the hell is going on.

The way I develop reports is to get it working in HTML, then execute an
ASP I created which "converts" (i.e. sets up the mime type, sets the
style sheets, etc) the file to Excel. Then I go in and add my formulas
such as subtotals and sums.

Jul 22 '05 #2
<<
Accurary, I just change the contenttype of the asp to
"application/vnd.ms-excel"

but my question is that, how to default the cell font to Arial?

Now, it is defaulted to "Time News Roman", and I have tried using
<font face="Arial">
and stylesheet

but sees cannot, please advise~


This interesting resource can help with formating but I don't know if it
actually can go as far as you want (to set a particular font):

Creating a Dynamic Report using ASP and Excel by Jeff Anderson -
1/9/2003
http://www.codetoad.com/asp_excel.asp

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 22 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Matt | last post: by
6 posts views Thread by Elena | last post: by
13 posts views Thread by Hemant Sipahimalani | last post: by
5 posts views Thread by Simon | last post: by
3 posts views Thread by =?Utf-8?B?YzY3NjIyOA==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.