Spreadsheet I/O formats

This is a discussion on Spreadsheet I/O formats within the C++ Programming forums, part of the General Programming Boards category; Hey there. I havent tried this yet. Was planning on having a look tonight... But I wondered how I could ...

  1. #1
    Registered User
    Join Date
    Aug 2008
    Posts
    33

    Spreadsheet I/O formats

    Hey there.

    I havent tried this yet. Was planning on having a look tonight...

    But I wondered how I could access individual elements within a MS Excel spreadsheet.

    Think I will probably end up with garbled rubbish if I try it solo...

    Any ideas?

  2. #2
    Registered User
    Join Date
    Aug 2008
    Posts
    33
    ...bearing in mind that i can read/write to disc already.

  3. #3
    Registered User
    Join Date
    Aug 2006
    Posts
    99
    Look here, it's not as simple as you may think:

    http://www.microsoft.com/interop/doc...ryFormats.mspx

  4. #4
    Registered User
    Join Date
    Apr 2006
    Posts
    2,053
    Easiest spreadsheet format to work with is csv. Excel can save to csv, and it is easy to write a program that can read that.

    For any practical use, that should be enough.
    It is too clear and so it is hard to see.
    A dunce once searched for fire with a lighted lantern.
    Had he known what fire was,
    He could have cooked his rice much sooner.

  5. #5
    Registered User
    Join Date
    Jun 2005
    Posts
    6,660
    You may also want to look at Wotsit. It has all sorts of specifications of interest.

    I haven't specifically used the information it provides (or links to) about Excel file formats, but I have found information about other file formats on that site useful.
    Right 98% of the time, and don't care about the other 3%.

    If I seem grumpy or unhelpful in reply to you, or tell you you need to demonstrate more effort before you can expect help, it is likely you deserve it. Suck it up, Sunshine, and read this, this, and this before posting again.

  6. #6
    (?<!re)tired Mario F.'s Avatar
    Join Date
    May 2006
    Location
    Portugal
    Posts
    7,581
    A simple tutorial on interfacing C++ and Excel. Both creating an Excel Add-in and accessing Excel from within a C++ program: Here (pdf link).

    The more relevant information starts on page 58. It uses COM and the Excel Object Model to interface with an Excel spreadsheet. I haven't tried any of this.
    The programmer’s wife tells him: “Run to the store and pick up a loaf of bread. If they have eggs, get a dozen.”
    The programmer comes home with 12 loaves of bread.


    Originally Posted by brewbuck:
    Reimplementing a large system in another language to get a 25% performance boost is nonsense. It would be cheaper to just get a computer which is 25% faster.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Raw I/O vs. Stream I/O
    By NuNn in forum C Programming
    Replies: 1
    Last Post: 03-17-2009, 09:32 AM
  2. asynchronized I/O == multiplexing I/O?
    By George2 in forum C Programming
    Replies: 1
    Last Post: 07-24-2006, 11:06 AM
  3. why page based I/O can improve performance?
    By George2 in forum C Programming
    Replies: 1
    Last Post: 06-12-2006, 08:42 AM
  4. Nonblocking I/O
    By fnoyan in forum Linux Programming
    Replies: 4
    Last Post: 11-29-2005, 04:37 PM
  5. Overlapped I/O and Completion Port :: Winsock
    By kuphryn in forum Windows Programming
    Replies: 0
    Last Post: 10-30-2002, 05:14 PM

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21