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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. RussM

    xls file extension to wks "Works" extension

    RussM, Jul 11, 2004, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    594
    Llobid
    Jul 11, 2004
  2. Alex
    Replies:
    0
    Views:
    346
  3. Alex
    Replies:
    1
    Views:
    283
    Dave Peterson
    Sep 8, 2004
  4. imej-clavier
    Replies:
    1
    Views:
    813
    Maurice
    May 28, 2005
  5. Guest
    Replies:
    5
    Views:
    302
    Guest
    Aug 25, 2005
  6. WD
    Replies:
    1
    Views:
    314
    macropod
    Jul 27, 2008
  7. Bud
    Replies:
    1
    Views:
    240
    Sheeloo
    Oct 2, 2008
  8. debby
    Replies:
    1
    Views:
    398
    Dave Peterson
    Feb 7, 2010
Loading...