GridView -> Excel = no gridlines

Discussion in 'ASP .Net Datagrid Control' started by Magnus Blomberg, Oct 21, 2005.

  1. Hi! I use the following client script but get no gridlines in Excel.
    function Excel_onclick()
    dim sHTML
    sHTML = document.getElementById("GridView1").outerHTML
    dim oXL, oBook, oSheet
    set oXL = CreateObject("Excel.Application")
    Set oBook = oXL.Workbooks.Add
    oBook.HTMLProject.HTMLProjectItems(1).Text = sHTML
    oBook.HTMLProject.RefreshDocument
    oXL.Visible = true
    oXL.UserControl = true
    end function

    I am using a bad way?
    How to solve it?

    Regards Magnus
    Magnus Blomberg, Oct 21, 2005
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. LouV
    Replies:
    0
    Views:
    1,098
  2. Mike P

    GridView Gridlines

    Mike P, Apr 26, 2006, in forum: ASP .Net
    Replies:
    2
    Views:
    918
    Mike P
    Apr 26, 2006
  3. =?Utf-8?B?Vmlua2k=?=

    disapearing gridlines in gridview

    =?Utf-8?B?Vmlua2k=?=, Apr 26, 2007, in forum: ASP .Net
    Replies:
    4
    Views:
    675
    Ray Costanzo
    Apr 27, 2007
  4. tshad

    Gridview Gridlines color

    tshad, Jan 19, 2010, in forum: ASP .Net
    Replies:
    2
    Views:
    3,324
    tshad
    Jan 20, 2010
  5. middletree

    Excel gridlines

    middletree, Jul 6, 2005, in forum: ASP General
    Replies:
    5
    Views:
    130
    middletree
    Jul 7, 2005
Loading...

Share This Page