I have a request from my client that they need to export data to an excel using BCP command and the excel file is with format:
Row 1: title of report = bold and place at column 3
Row 2: report date = dd/mm/yyyy and place at column 1
Row 3: header of columns = bold and background color is green
From the row 4, data will be display.
However, I am not sure about using XML format file which can handle that. Please any suggestions :-)