export from sqlserver in html format with .xls extension and enabling DisplayGridlines

Discussion in 'Microsoft Excel Misc' started by scirocco1@gmail.com, Jan 24, 2007.

  1. Guest

    hello, i do the following trick... writing html into a .xls file (from
    sql server, for an export - just to have the STUPID zeros not removed
    by STUPID .CSV format) . so, everything works smooth, just
    DisplayGridLines is set from some unknown reason to me to false :( ...
    any fix ? notice that i can't run vba from sql server ;)
     
    , Jan 24, 2007
    #1
    1. Advertisements

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. RussM

    xls file extension to wks "Works" extension

    RussM, Jul 11, 2004, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    456
    Llobid
    Jul 11, 2004
  2. imej-clavier
    Replies:
    1
    Views:
    696
    Maurice
    May 28, 2005
  3. Guest
    Replies:
    5
    Views:
    245
    Guest
    Aug 25, 2005
  4. Bud
    Replies:
    1
    Views:
    164
    Sheeloo
    Oct 2, 2008
  5. debby
    Replies:
    1
    Views:
    342
    Dave Peterson
    Feb 7, 2010
Loading...

Share This Page