p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


Go Back   p2p.wrox.com Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Professional
I forgot my password Register Now
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 p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.

Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old August 13th, 2006, 07:41 AM
Friend of Wrox
Points: 5,604, Level: 31
Points: 5,604, Level: 31 Points: 5,604, Level: 31 Points: 5,604, Level: 31
Activity: 40%
Activity: 40% Activity: 40% Activity: 40%
 
Join Date: Jan 2004
Location: Sydney, NSW, Australia.
Posts: 1,666
Thanks: 6
Thanked 9 Times in 9 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

http://www.elitemarquees.com.au
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off
Forum Jump

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 12:25 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
© 2008 Wiley Publishing, Inc