Reading data in to a program from Excel

[cathym]

I have an extensive Excel spreadsheet with many references and calculations. To ease the load, I want to write a c++ program to read the data into a one dimentional array of structs, do some sorts and some calculations, and then spit the data back out to a separate part of the spreadsheet. If I were using .dat or .txt files instead of an Excel spreadsheet, there would be no problem. How do I actually capture a number out of a cell on a spreadsheet? With as little overhead as possible.

 

[whycobol]

if you want you can export the excel to common delimited and then do a search for the "," in question and do whatever calculations you want an the save the file in comma delimited form again and import into excel. hope this help