format excel spreadsheet exported from SQL

• K Currie

  SSCommitted

  Points: 1662

  More actions

  June 16, 2010 at 9:27 pm

  #233913

  I created an excel spreadsheet via xp_cmdshell. I would now like to format this into a more user friendly file. Is it possible to use xp_cmdshell to open the file, run a macro that will format it and save it? I'm looking to expand my columns and add some colors. Is there a better way to do this?

• Gosta Munktell

  SSCertifiable

  Points: 6004

  More actions

  June 18, 2010 at 12:36 am

  #1181939

  Is there a better way to do this?

  YES I think so. If you are to do extensive work in Excel like running macros etc

  use VBA ADO and remote DB in Excel.

  /Gosta