Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   ASP General (http://www.velocityreviews.com/forums/f65-asp-general.html)
-   -   ASP export excel (http://www.velocityreviews.com/forums/t797689-asp-export-excel.html)

Utada P.W. SIU 01-21-2005 10:20 AM

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~



larrybud2002@yahoo.com 01-25-2005 07:45 PM

Re: ASP export excel
 

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.


Bullschmidt 01-26-2005 04:38 AM

Re: 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~
>>


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!


All times are GMT. The time now is 09:56 AM.

Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.