Skip to main content
D
depth10
Known Participant
March 10, 2010
Question

Exporting to Excel, show lines

  • March 10, 2010
  • 1 reply
  • 772 views

Not sure if this is the right area to post this, so I apologize in advance.

I am exporting query data to excel using the <cfoutput>, <cfsavecontent>  and <cfheader> tags, but when it exports and opens in Excel, there are no gridlines.  It's just a white background.  Is there a way to add these back?

Thanks

    This topic has been closed for replies.

    1 reply

    Dileep_NR
    Dileep_NR
    Inspiring
    March 11, 2010

    place your data inside a table tag with border=1

    D
    depth10Author
    Known Participant
    March 11, 2010

    I already have it set to border=1. I get a border around the table, that is

    all find and good. The problem is, anywhere outside the table is blank

    white. Not even the faint Excel lines that are on by default. Guess it

    doesn't look like this is possible.

    A
    Adam Cameron.
    Inspiring
    March 11, 2010

    What about if you don't delivery the data as HTML, just delivery it as CVS data?

    Or, if you're using CF9, just deliver XLS data.

    --

    Adam

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices