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,456
    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%.

  6. #6
    (?<!re)tired Mario F.'s Avatar
    Join Date
    May 2006
    Location
    Portugal
    Posts
    7,517
    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, 08:32 AM
  2. asynchronized I/O == multiplexing I/O?
    By George2 in forum C Programming
    Replies: 1
    Last Post: 07-24-2006, 10:06 AM
  3. why page based I/O can improve performance?
    By George2 in forum C Programming
    Replies: 1
    Last Post: 06-12-2006, 07:42 AM
  4. Nonblocking I/O
    By fnoyan in forum Linux Programming
    Replies: 4
    Last Post: 11-29-2005, 03:37 PM
  5. Overlapped I/O and Completion Port :: Winsock
    By kuphryn in forum Windows Programming
    Replies: 0
    Last Post: 10-30-2002, 04:14 PM

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