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

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

  1. 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. 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. 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