Click here to Skip to main content
15,925,602 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: Faking a window size Pin
Leeroy7018-Nov-07 21:51
Leeroy7018-Nov-07 21:51 
QuestionHow to open and view a file in Exclusive mode? Pin
narayanagvs18-Nov-07 20:29
narayanagvs18-Nov-07 20:29 
AnswerRe: How to open and view a file in Exclusive mode? Pin
Rajesh R Subramanian18-Nov-07 22:10
professionalRajesh R Subramanian18-Nov-07 22:10 
GeneralRe: How to open and view a file in Exclusive mode? Pin
narayanagvs18-Nov-07 22:42
narayanagvs18-Nov-07 22:42 
GeneralRe: How to open and view a file in Exclusive mode? Pin
Rajesh R Subramanian18-Nov-07 23:06
professionalRajesh R Subramanian18-Nov-07 23:06 
QuestionAccessing data of excel sheet through mfc application Pin
Pritam Kamble18-Nov-07 20:20
Pritam Kamble18-Nov-07 20:20 
AnswerRe: Accessing data of excel sheet through mfc application Pin
Rajesh R Subramanian18-Nov-07 22:12
professionalRajesh R Subramanian18-Nov-07 22:12 
GeneralRe: Accessing data of excel sheet through mfc application Pin
Matthew Faithfull18-Nov-07 22:18
Matthew Faithfull18-Nov-07 22:18 
There are at least 4 ways to do this. The easy way, the less easy way, the COM way and the really hard way.
The easy way is to save your spreadsheet as a .csv (Comma Separated Value) file and then open it and read in the data. Parsing the comma separated fields is then pretty trivial.

The less easy way is to use ODBC/OLE DB to read the original Excel file as a database. Microsoft publishes a driver/provider for this so you can execute SQL queries against the spreadsheet. Unfortunately the last time I used it it was rubbish and had more gotchas than the Sun newspaper archive.

The COM way is to instance Excel itself as a COM server and use the interfaces it exposes to access the data. If you're into COM this is not actually very difficult because it's all IDispatch based, designed to be used from VB.

The really hard way would be to attempt to read Excel native files directly. This, while technically possible, could prove to be really difficult and is almost certainly not worth the effort.

There's your options, enjoy Smile | :)

Nothing is exactly what it seems but everything with seems can be unpicked.

QuestionProblem in Getting Handle of EditBox. Pin
Atul2318-Nov-07 19:57
Atul2318-Nov-07 19:57 
AnswerRe: Problem in Getting Handle of EditBox. Pin
Peter Weyzen18-Nov-07 20:06
Peter Weyzen18-Nov-07 20:06 
QuestionRe: Problem in Getting Handle of EditBox. Pin
Hamid_RT18-Nov-07 21:58
Hamid_RT18-Nov-07 21:58 
Questionhow to disable a button in toolbar? Pin
panthal18-Nov-07 19:25
panthal18-Nov-07 19:25 
AnswerRe: how to disable a button in toolbar? Pin
Rajesh R Subramanian18-Nov-07 22:07
professionalRajesh R Subramanian18-Nov-07 22:07 
QuestionInternet Explorer Security Setting of Trusted Sites Programmatically - Please Guide Pin
h@$@n18-Nov-07 18:48
h@$@n18-Nov-07 18:48 
Questionhow to create an exe from an dll file. Pin
amiya das18-Nov-07 18:36
amiya das18-Nov-07 18:36 
QuestionHow compile this managed c++ help urgently needed Pin
G.Makesh18-Nov-07 18:35
G.Makesh18-Nov-07 18:35 
AnswerRe: How compile this managed c++ help urgently needed Pin
Nelek18-Nov-07 22:23
protectorNelek18-Nov-07 22:23 
QuestionDelete or Destroy? Pin
Oliver12318-Nov-07 18:19
Oliver12318-Nov-07 18:19 
AnswerRe: Delete or Destroy? Pin
CooperWu18-Nov-07 18:30
CooperWu18-Nov-07 18:30 
AnswerRe: Delete or Destroy? Pin
Peter Weyzen18-Nov-07 19:22
Peter Weyzen18-Nov-07 19:22 
AnswerRe: Delete or Destroy? Pin
jhwurmbach18-Nov-07 22:19
jhwurmbach18-Nov-07 22:19 
QuestionData connection is failed Pin
CodingLover18-Nov-07 17:55
CodingLover18-Nov-07 17:55 
AnswerRe: Data connection is failed Pin
manish.patel18-Nov-07 18:10
manish.patel18-Nov-07 18:10 
GeneralRe: Data connection is failed Pin
CodingLover18-Nov-07 18:40
CodingLover18-Nov-07 18:40 
QuestionPassing and receving value through ShellExecute Pin
neha.agarwal2718-Nov-07 17:36
neha.agarwal2718-Nov-07 17:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.