Thread: Reading/Writing Excel Files

  1. #1
    Registered User
    Join Date
    Nov 2008
    Posts
    3

    Reading/Writing Excel Files

    we have been given a uni assignment to model the performance of a car as it accelerates from 0-60mph using c code. this is all fine but now that i have the data i need to write it to an excel file from the appropiate arrays. any ideas aboput how to go about this. i know how to write to a .txt file but nothing else !!!
    many thanks
    hugh

  2. #2
    and the hat of int overfl Salem's Avatar
    Join Date
    Aug 2001
    Location
    The edge of the known universe
    Posts
    39,659
    Write it out in CSV format (it's just a simple text format).
    Then read it in with excel.
    If you dance barefoot on the broken glass of undefined behaviour, you've got to expect the occasional cut.
    If at first you don't succeed, try writing your phone number on the exam paper.

  3. #3
    Registered User
    Join Date
    Nov 2008
    Posts
    3
    cheers that opens it in excel but all in 1 column any idea how to get it to read out into different ones
    e.g.

    x1 y1
    x2 y2
    x3 y3

    cos at the moment it is

    x1y1
    x2y2
    x3y3

    cheers hugh

  4. #4
    and the Hat of Guessing tabstop's Avatar
    Join Date
    Nov 2007
    Posts
    14,336
    Did you write it out with commas?

  5. #5
    Registered User
    Join Date
    Nov 2008
    Posts
    3
    oops
    cheers prob sorted !!!

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Program Deployment and DLL/OCX Files?
    By dfghjk in forum C++ Programming
    Replies: 5
    Last Post: 06-16-2008, 02:47 AM
  2. Data Organization and Excel
    By uniqst3r in forum C Programming
    Replies: 4
    Last Post: 05-26-2008, 01:37 AM
  3. Folding@Home Cboard team?
    By jverkoey in forum A Brief History of Cprogramming.com
    Replies: 398
    Last Post: 10-11-2005, 08:44 AM
  4. Accessesing Excel files from borland c++ builder 6
    By warturtle in forum Windows Programming
    Replies: 4
    Last Post: 09-21-2005, 11:50 PM
  5. Batch file programming
    By year2038bug in forum Tech Board
    Replies: 10
    Last Post: 09-05-2005, 03:30 PM