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?
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?
...bearing in mind that i can read/write to disc already.
Look here, it's not as simple as you may think:
http://www.microsoft.com/interop/doc...ryFormats.mspx
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.
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.
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.
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.