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:
    612
    Llobid
    Jul 11, 2004
  2. Alex
    Replies:
    0
    Views:
    380
  3. Alex
    Replies:
    1
    Views:
    323
    Dave Peterson
    Sep 8, 2004
  4. imej-clavier
    Replies:
    1
    Views:
    844
    Maurice
    May 28, 2005
  5. Guest
    Replies:
    5
    Views:
    339
    Guest
    Aug 25, 2005
  6. WD
    Replies:
    1
    Views:
    352
    macropod
    Jul 27, 2008
  7. Bud
    Replies:
    1
    Views:
    256
    Sheeloo
    Oct 2, 2008
  8. debby
    Replies:
    1
    Views:
    407
    Dave Peterson
    Feb 7, 2010
Loading...