Outputing to a file...can excel be used?

Discussion in 'Mac Programming' started by sari210, Jun 23, 2009.

  1. sari210 macrumors newbie

    Joined:
    Jun 8, 2009
    Location:
    St. Paul, MN
    #1
    So I need to be able to send my data to an outside file to be viewed, saved, and eventually graphed. Is there a way to send it straight to an excel file or do I need to send it to a text file and then sort it on my own?

    If this is possible does any one know the most efficient way to go about this?


    Thanks!
     
  2. jpyc7 macrumors 6502

    Joined:
    Mar 8, 2009
    Location:
    Denver, CO
    #2
    csv file

    You could generate a CSV (comma separated value) file. Technically, you can use any type of delimiter, but I'm not sure how easy it is to make Excel accept a different delimiter character. The main reason to use other delimiter is if the comma character is in your regular data.

    On Windows OS, if I use a file with .csv extension, Excel will read it.

    If you use a graphing program like gnuplot, then that should also take csv files. A program like "matlab" prefers white-space delimited input.
     
  3. sari210 thread starter macrumors newbie

    Joined:
    Jun 8, 2009
    Location:
    St. Paul, MN
    #3
    Perhaps I would have been more helpful if I had said I was fairly new at this.
    Also, I plan on graphing the data in excel as that is what my advisor is looking for.
     

Share This Page