Saving Text in Excel

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • romcab
    New Member
    • Sep 2007
    • 108

    Saving Text in Excel

    Hi guys,
    I created an application in vb.net which creates a csv file and write some text. In the .csv file, it should have a column header. I would like to ask how can I add column in the .csv file. I try adding tab after writing some text but it did'nt work. I used the StreamWriter object in my application, do I need to use binaryStreamWri ter for this to work? Hope you can share me your idea on how to do this..

    Thanks guys..
  • Shashi Sadasivan
    Recognized Expert Top Contributor
    • Aug 2007
    • 1435

    #2
    the first row of your csv file can contain the column names

    so before writing data into the csv file,
    create the first row (comma delimited) of all the column names

    Comment

    • romcab
      New Member
      • Sep 2007
      • 108

      #3
      Originally posted by Shashi Sadasivan
      the first row of your csv file can contain the column names

      so before writing data into the csv file,
      create the first row (comma delimited) of all the column names
      thanks...I thought what I need to add is tab character in order for excel to put the next text on the next column. I replaced it with comma and works fine.

      Comment

      Working...