Thread: Outputting to excel...

  1. #1
    Registered User
    Join Date
    Apr 2007
    Posts
    42

    Outputting to excel...

    Hi all,

    Assuming I had a file with tons of figures in it (I think a csv would be the easiest to use), how would I go about exporting it to an xls file, and then view it in Excel? Going through the file and grabbing the necessary data wouldn't be a problem, but I'm unsure as to how I would actually write these columns to a new xls file.

    Thanks.

  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
    Given that excel can open csv files, why would you want to do this?

    Yes you can do this, but the code for writing an actual .xls file is far from trivial.
    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
    Mar 2005
    Location
    Mountaintop, Pa
    Posts
    1,058
    A possible Windows solution

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Excel question
    By Dark_Phoenix in forum Tech Board
    Replies: 2
    Last Post: 12-10-2007, 09:10 PM
  2. using Excel to connect to external data source
    By George2 in forum Windows Programming
    Replies: 4
    Last Post: 05-01-2007, 10:07 PM
  3. Exporting a DataTable to Excel (.NET)
    By Trauts in forum C# Programming
    Replies: 0
    Last Post: 07-29-2005, 01:03 PM
  4. C++ Builder and Excel files
    By mfdemi in forum Windows Programming
    Replies: 3
    Last Post: 09-24-2004, 01:51 AM
  5. Print a File via Excel
    By ginoitalo in forum C# Programming
    Replies: 2
    Last Post: 05-10-2002, 12:33 AM