Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Professional
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old August 13th, 2006, 07:41 AM
Friend of Wrox
Points: 6,664, Level: 34
Points: 6,664, Level: 34 Points: 6,664, Level: 34 Points: 6,664, Level: 34
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2004
Location: Sydney, NSW, Australia.
Posts: 1,870
Thanks: 12
Thanked 20 Times in 20 Posts
Send a message via AIM to mat41
Default ASP to Excel - excel output formatting issue

Good Day

I have a performance management system. The objective is to get it into excel, this has been achieved however I have two formatting issues which are troubling me:

1.How to force an HTML(is there another option) line break within a cell Here is a link to the file:
http://www.framegroup.com.au/frameNe...oExcelNoBR.xls
My issue is the Oucomes and Outputs row, its to wide especially the first.
So Im thinking a br within my HTML will solve this, here is the result:
http://www.framegroup.com.au/frameNe...celUsingBR.xls
Far to much space between the items. Is there another way? I have tried:
vbCr,VbCrLf,vbNewLine,Chr(13),Chr(10) - None of these work.

2.Getting the score image centered. I have tried the following:
  Excel completley ignores:
  Table tag - cellspacing and cellpadding (strangley enough allows the border and borderColor)
  img tag - hSpace, vSpace and align=center
  td tag - STYLE="PADDING:6" or align=center
  If I remove the image from the HTML code and sent text to the .xls it centers. Can I not control an images
  positioning using HTML within a cell?

TYIA

Wind is your friend
Matt
__________________
Wind is your friend
Matt
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP to Excel BUT show Excel grid lines mat41 Classic ASP Basics 8 May 31st, 2009 06:56 PM
Help with formatting an excel spreadsheet lushh Access 0 October 1st, 2006 11:48 PM
Excel 2000 vs Excel 2002 Macro Issue williadn Excel VBA 1 July 14th, 2005 10:09 AM
Displaying output in Excel via ASP Sach Classic ASP Components 4 May 3rd, 2004 08:37 AM
Formatting Excel through VBA John Anthony Access VBA 0 July 31st, 2003 06:15 PM



All times are GMT -4. The time now is 04:22 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.