Thread: c++ link to an excell table to use. possible?

  1. #1
    Registered User
    Join Date
    Nov 2001
    Posts
    1

    Question c++ link to an excell table to use. possible?

    is there any way to link c++ to microsoft excell? i need to use a table from excell as information in microsoft visual c++. email is [email protected]

  2. #2
    Registered User
    Join Date
    Sep 2001
    Posts
    156
    Yes you can. Excel is an automation object so you can get the IUnknown (or any other published interface) from it using CoCreateInstance then use the appropriate methods. Their are lots of VB examples and some c++ out on MSDN.

    Or you can talk to it via ODBC. You'll have to rummage around MSDN http://msdn.microsoft.com/library/ to find which method works best for you.
    Last edited by Dang; 11-02-2001 at 10:12 AM.

  3. #3
    Registered User
    Join Date
    Apr 2002
    Posts
    2

    Question Anybody figure this one out?

    I've found myself in a very similar situation: I need to input/output data from/to an excel file. Thanks in advance.

  4. #4
    train spotter
    Join Date
    Aug 2001
    Location
    near a computer
    Posts
    3,868
    Use a type of Excel file called a .csv

    That is one where the cells are seperated by commas.

    Can be written as text or by Excel.

    Do a search on the Windows programming board for more info.

    or look here

    http://www.cprogramming.com/cboard/s...ighlight=excel
    Last edited by novacain; 04-03-2002 at 10:57 PM.
    "Man alone suffers so excruciatingly in the world that he was compelled to invent laughter."
    Friedrich Nietzsche

    "I spent a lot of my money on booze, birds and fast cars......the rest I squandered."
    George Best

    "If you are going through hell....keep going."
    Winston Churchill

  5. #5
    Registered User
    Join Date
    Apr 2002
    Posts
    2
    Thanks! I'll give that a try.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Writing array, to file
    By zootreeves in forum C Programming
    Replies: 9
    Last Post: 09-08-2007, 05:06 PM
  2. Function to check memory left from malloc and free?
    By Lechx in forum C Programming
    Replies: 4
    Last Post: 04-24-2006, 05:45 AM
  3. Request for comments
    By Prelude in forum A Brief History of Cprogramming.com
    Replies: 15
    Last Post: 01-02-2004, 10:33 AM
  4. extra word printing
    By kashifk in forum C++ Programming
    Replies: 2
    Last Post: 10-25-2003, 04:03 PM
  5. inputting words from a file
    By kashifk in forum C++ Programming
    Replies: 5
    Last Post: 10-24-2003, 07:18 AM