Dreamweaver 8 - writing to excel

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tabbycat
    New Member
    • Nov 2006
    • 5

    Dreamweaver 8 - writing to excel

    HI!
    I am using Dreamweaver 8, creating a form that when run opens as excel table as follows:

    <head>
    <%
    Response.Conten tType = "applicatio n/vnd.ms-excel"
    %>

    I have outer 1-celled container table set to width=100%,
    Then inner table set to width=100% with table headers in top row.
    Problem is the width is ignored and the headers are displayed without wrapping, making the table very wide.
    I have tried unchecking the "nowrap" textbox in properties for each header cell. Have also tried setting the width of both tables to 620 pixels, but that is also ignored.

    Is there any way I can get this text to wrap without having to put breaks (<br>) in each header cell?

    NOTE: this is not an issue when running in IE as a regular site (iow - taking out the "response.conte nttype" line above).

    Let me know if you need more info.
    Thank you for any and all suggestions!
  • tabbycat
    New Member
    • Nov 2006
    • 5

    #2
    MY BAD - it's DREAMWEAVER MX 2004

    Comment

    • AricC
      Recognized Expert Top Contributor
      • Oct 2006
      • 1885

      #3
      Try giving it a fixed width and set the overflow to auto via CSS style="width: 200px;overflow: auto" here is an example that may help you out.

      Comment

      • tabbycat
        New Member
        • Nov 2006
        • 5

        #4
        Thanks for the input!

        That works, but only if not writing the output to excel.
        I ended up just sticking with putting breaks in each of those cells...it must just be some issue with excel not recognizing/liking that formatting or something - I had a similar issue with ignoring cellpadding. I had to specify row height in pixels to get around that.
        Not sure what else can be done about it.

        Thanks anyways!

        Comment

        Working...