Wrox Programmer Forums
| 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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old August 13th, 2006, 06: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


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 05:56 PM
Help with formatting an excel spreadsheet lushh Access 0 October 1st, 2006 10:48 PM
Excel 2000 vs Excel 2002 Macro Issue williadn Excel VBA 1 July 14th, 2005 09:09 AM
Displaying output in Excel via ASP Sach Classic ASP Components 4 May 3rd, 2004 07:37 AM
Formatting Excel through VBA John Anthony Access VBA 0 July 31st, 2003 05:15 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.