Writing csv files from C

Question

I m trying to output some data to a  csv file and it is outputting it to the file but it isn t separating the data into different columns and seems to be outputting the data incorrectly        ofstream Morison File   linear wave loading csv              Opening file to print info to     Morison File  lt  lt   Time Force N m    lt  lt  endl             Headings for file     for  t   0  t  lt   20  t            u   sin omega   t         du   cos omega   t          F    0 5   rho   C d   D   u   fabs u     rho   Area   C m   du          cout  lt  lt   t      lt  lt  t  lt  lt    t tF      lt  lt  F  lt  lt  endl        Morison File  lt  lt  t                                    Printing to file       Morison File  lt  lt  F               Morison File close      Time and Force N m  are in columns A and B respectively but the t and F values are both printing the first row    What is the syntax to separate them to print t into column A and F into column B

User · Answer

If you wirte to a  csv file in C   - you should use the syntax of    myfile  lt  lt    s   s   d   string1  string2  double1  lt  lt endl    This will write the three variables  string 1 amp 2 and double1  into separate columns and leave an empty row below them  In excel the   means the new row  so if you want to just take a new row - you can alos write a simple     before writing your new data into the file  If you don t want to have an empty row below - you should delete the endl and use the   myfile open  result csv   std  ios  out   std  ios  app     syntax when opening the  csv file  example the result csv   In this way next time you write something into your result csv file - it will write it into a new row directly below the last one - so you can easily manage a for cycle if you would like to

User · Answer

There is nothing special about a CSV file  You can create them using a text editor by simply following the basic rules  The RFC 4180  tools ietf org html rfc4180  accepted separator is the comma     not the semi-colon      Programs like MS Excel expect a comma as a separator    There are some programs that treat the comma as a decimal and the semi-colon as a separator  but these are technically outside of the  accepted  standard for CSV formatted files   So  when creating a CSV you create your filestream and add your lines like so    include  lt iostream gt   include  lt fstream gt  int main  int argc  char  argv             std  ofstream myfile        myfile open   example csv          myfile  lt  lt   This is the first cell in the first column  n         myfile  lt  lt   a b c  n         myfile  lt  lt   c s v  n         myfile  lt  lt   1 2 3 456 n         myfile  lt  lt   semi colon         myfile close          return 0      This will result in a CSV file that looks like this when opened in MS Excel

User · Answer

Here is a STL-like class File  quot csvfile h quot   pragma once   include  lt iostream gt   include  lt fstream gt   class csvfile   inline static csvfile amp  endrow csvfile amp  file   inline static csvfile amp  flush csvfile amp  file    class csvfile       std  ofstream fs       const std  string separator   public      csvfile const std  string filename  const std  string separator    quot   quot             fs              separator  separator                fs  exceptions std  ios  failbit   std  ios  badbit           fs  open filename               csvfile                 flush            fs  close               void flush                 fs  flush               void endrow                 fs   lt  lt  std  endl             csvfile amp  operator  lt  lt    csvfile amp     val  csvfile amp                  return val  this              csvfile amp  operator  lt  lt   const char   val                fs   lt  lt    quot    lt  lt  val  lt  lt    quot    lt  lt  separator           return  this             csvfile amp  operator  lt  lt   const std  string  amp  val                fs   lt  lt    quot    lt  lt  val  lt  lt    quot    lt  lt  separator           return  this             template lt typename T gt      csvfile amp  operator  lt  lt   const T amp  val                fs   lt  lt  val  lt  lt  separator           return  this             inline static csvfile amp  endrow csvfile amp  file        file endrow        return file     inline static csvfile amp  flush csvfile amp  file        file flush        return file     File  quot main cpp quot   include  quot csvfile h quot   int main         try               csvfile csv  quot MyTable csv quot       throws exceptions             Header         csv  lt  lt   quot X quot   lt  lt   quot VALUE quot          lt  lt  endrow             Data         csv  lt  lt   1   lt  lt   quot String value quot   lt  lt  endrow          csv  lt  lt   2   lt  lt  123             lt  lt  endrow          csv  lt  lt   3   lt  lt  1 f             lt  lt  endrow          csv  lt  lt   4   lt  lt  1 2             lt  lt  endrow            catch  const std  exception amp  ex                std  cout  lt  lt   quot Exception was thrown   quot   lt  lt  e what    lt  lt  std  endl            return 0     Latest version here

User · Answer

As explained above by  kris  depending on the region configurations of MS Excel it won t interpret the comma as the separator character  In my case I had to change it to semi-colon

User · Answer

You must     separator  CSV    Comma Separator Value   ofstream Morison File   linear wave loading csv              Opening file to print info to     Morison File  lt  lt    Time    Force N m      lt  lt  endl             Headings for file     for  t   0  t  lt   20  t            u   sin omega   t         du   cos omega   t          F    0 5   rho   C d   D   u   fabs u     rho   Area   C m   du          cout  lt  lt   t      lt  lt  t  lt  lt    t tF      lt  lt  F  lt  lt  endl        Morison File  lt  lt  t  lt  lt       lt  lt  F               Morison File close

User · Answer

Change   Morison File  lt  lt  t                                    Printing to file Morison File  lt  lt  F    To   Morison File  lt  lt  t  lt  lt       lt  lt  F  lt  lt  endl                                    Printing to file   a   would also do instead of

[c++] Writing .csv files from C++

Examples related to c++

Examples related to csv