Click here to Skip to main content
15,887,135 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: Creating MPEG-1 from series of JPEG Pin
Mark Salsbery28-Mar-07 6:57
Mark Salsbery28-Mar-07 6:57 
QuestionHow to send messages to windows Pin
Goggelmoggel27-Mar-07 0:57
Goggelmoggel27-Mar-07 0:57 
AnswerRe: How to send messages to windows Pin
Naveen27-Mar-07 1:03
Naveen27-Mar-07 1:03 
GeneralRe: How to send messages to windows Pin
Goggelmoggel27-Mar-07 1:27
Goggelmoggel27-Mar-07 1:27 
QuestionBackground color of a property page Pin
Farhat Aisha27-Mar-07 0:56
Farhat Aisha27-Mar-07 0:56 
AnswerRe: Background color of a property page Pin
prasad_som27-Mar-07 2:20
prasad_som27-Mar-07 2:20 
QuestionUsing Excel from C++ Pin
BusyDeveloper27-Mar-07 0:44
BusyDeveloper27-Mar-07 0:44 
AnswerRe: Using Excel from C++ Pin
Roger Stoltz27-Mar-07 2:30
Roger Stoltz27-Mar-07 2:30 
aoe wrote:
The app reads the settings from Excel using OLE. I think it's slow


Are the cells by any chance read one by one?
In that case it can be very slow because each call is made out-of-process since Excel runs as such server.
I've encoutered this once when writing a huge amount of data into an Excel sheet and it took about 40 minutes to complete the operation. Then I realized that it could all be done in one single call by using a multidimensional SafeArray. The only thing is that the SafeArray can only hold one datatype at a time, i.e. you cannot read headings for the columns in the same call as numeric data.
After I made the change the operation completed in less than 10 seconds.


"It's supposed to be hard, otherwise anybody could do it!" - selfquote
"High speed never compensates for wrong direction!" - unknown

GeneralRe: Using Excel from C++ Pin
BusyDeveloper27-Mar-07 20:12
BusyDeveloper27-Mar-07 20:12 
QuestionRe: Using Excel from C++ Pin
Roger Stoltz27-Mar-07 20:47
Roger Stoltz27-Mar-07 20:47 
AnswerRe: Using Excel from C++ Pin
BusyDeveloper27-Mar-07 22:09
BusyDeveloper27-Mar-07 22:09 
GeneralRe: Using Excel from C++ Pin
Roger Stoltz27-Mar-07 23:01
Roger Stoltz27-Mar-07 23:01 
GeneralRe: Using Excel from C++ Pin
BusyDeveloper28-Mar-07 22:46
BusyDeveloper28-Mar-07 22:46 
QuestionDestroyWindow & Focus Pin
baerten27-Mar-07 0:15
baerten27-Mar-07 0:15 
QuestionAbout storing file content Pin
siddharthsan26-Mar-07 23:37
siddharthsan26-Mar-07 23:37 
AnswerRe: About storing file content Pin
David Crow27-Mar-07 2:54
David Crow27-Mar-07 2:54 
Questionto call GlobalAlloc Pin
zon_cpp26-Mar-07 23:17
zon_cpp26-Mar-07 23:17 
AnswerRe: to call GlobalAlloc Pin
toxcct26-Mar-07 23:21
toxcct26-Mar-07 23:21 
GeneralRe: to call GlobalAlloc Pin
zon_cpp27-Mar-07 0:03
zon_cpp27-Mar-07 0:03 
GeneralRe: to call GlobalAlloc Pin
toxcct27-Mar-07 0:12
toxcct27-Mar-07 0:12 
QuestionRe: to call GlobalAlloc Pin
zon_cpp27-Mar-07 0:27
zon_cpp27-Mar-07 0:27 
AnswerRe: to call GlobalAlloc Pin
toxcct27-Mar-07 0:33
toxcct27-Mar-07 0:33 
GeneralRe: to call GlobalAlloc [modified] Pin
zon_cpp27-Mar-07 1:11
zon_cpp27-Mar-07 1:11 
GeneralRe: to call GlobalAlloc Pin
toxcct27-Mar-07 2:02
toxcct27-Mar-07 2:02 
GeneralRe: to call GlobalAlloc Pin
zon_cpp27-Mar-07 2:38
zon_cpp27-Mar-07 2:38 

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.