Re: Use OLE - C / C++ / MFC Discussion Boards

Re: Use OLE

David Crow1-Jun-12 6:49

David Crow

1-Jun-12 6:49

MKC002 wrote:
Is there any way to solve this problem

How about using Excel automation instead (where the password can be provided to the Open function)?

"One man's wage rise is another man's price increase." - Harold Wilson

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

"Show me a community that obeys the Ten Commandments and I'll show you a less crowded prison system." - Anonymous

Re: Use OLE

MKC0021-Jun-12 23:15

MKC002

1-Jun-12 23:15

I want to show excel file contents in my own window

Re: Use OLE

David Crow4-Jun-12 2:40

David Crow

4-Jun-12 2:40

Ok, so what's the problem?

Re: Use OLE

MKC0024-Jun-12 4:33

MKC002

4-Jun-12 4:33

CreateFromFile hangs my program.
If excel file contains some password and i call CreateFromFile for that file, it asks me to enter password. If i click on cancel button and do not enter the password then my program hangs. It gives retry/switch-to message. How to solve this problem.

Re: Use OLE

David Crow4-Jun-12 5:07

David Crow

4-Jun-12 5:07

MKC002 wrote:
How to solve this problem.

Use Excel automation instead, where the password can be provided to the Open() function.

Re: Use OLE

MKC0024-Jun-12 18:55

MKC002

4-Jun-12 18:55

I want to open excel file contents in my own window, not in excel window. Is that possible with excel automation?

Re: Use OLE

David Crow5-Jun-12 2:25

David Crow

5-Jun-12 2:25

MKC002 wrote:
Is that possible with excel automation?

Yes.

Re: Use OLE

MKC0026-Jun-12 1:22

MKC002

6-Jun-12 1:22

Thanks for confirmation
Is there any example available in VC++
Can you please give some link

Re: Use OLE

David Crow6-Jun-12 2:18

David Crow

6-Jun-12 2:18

MKC002 wrote:
Is there any example available in VC++
Can you please give some link

Google produced the following:

http://support.microsoft.com/kb/216686[^]

http://support.microsoft.com/kb/196776/[^]

http://code.msdn.microsoft.com/office/CppAutomateExcel-be36992e[^]

Fastest data structure

_Flaviu31-May-12 22:59

_Flaviu

31-May-12 22:59

I want to ask you something, from yours experience : how is the fastest way to handle data (1 - 10 000 items) ?
In serialized CMap object ? Or in xml file ? I want to simulate 3 - 4 SQL tables, but I don't want to keep it into database ... I work in VC6 (MFC). Thank you.

modified 1-Jun-12 5:42am.

Re: Fastest data structure

Erudite_Eric1-Jun-12 0:19

Erudite_Eric

1-Jun-12 0:19

Hash list is generally quickest, unless you can sort the data.

If you are going to be reading-writing to file though it doesnt really mater whet the structure is in memory snce the speed bottleneck will be the disk access.

==============================

Nothing to say.

modified 2-Jun-12 2:53am.

Re: Fastest data structure

Aescleal1-Jun-12 1:04

Aescleal

1-Jun-12 1:04

If your program isn't something that has to stay closed source you could try using Berkeley DB[^], I've found it works really well for simple DB style apps.

If you can't or won't go open source for whatever reason I've found (for me, your data may be used in a completely different fashion) that a two layered approach for fast disk data access works best:

- the data itself is stored in a file with fixed size records
- another file containing a sorted or hashed index of key against index in the data file

Generally I read the index into memory, bung it in a vector or map. When I need data I look the index up in the map and hit the disk for the data itself.

Re: Fastest data structure

_Flaviu1-Jun-12 1:48

_Flaviu

1-Jun-12 1:48

Very good ideea, I never use map from STL, I play only with CMap from MFC, and I like it ...

Re: Fastest data structure

CPallini1-Jun-12 6:30

CPallini

1-Jun-12 6:30

Flaviu2 wrote:
I never use map from STL, I play only with CMap from MFC

You should rather do the opposite.

Veni, vidi, vici.

Re: Fastest data structure

Erudite_Eric1-Jun-12 20:52

Erudite_Eric

1-Jun-12 20:52

Yeah, STL is highly optimised. And highly used....

==============================

Nothing to say.

Re: Fastest data structure

Alan Balkany4-Jun-12 7:12

Alan Balkany

4-Jun-12 7:12

STL's map is implemented as a tree, which isn't as fast as hashing. MFC's CMap... classes and STL's hash map use hashing, so should be used if speed is the top goal.

"Microsoft -- Adding unnecessary complexity to your work since 1987!"

is it possible to call web service from java script

Subramani HM31-May-12 20:05

Subramani HM

31-May-12 20:05

Hi,

is it possible to call web service from java script? if so how to call. please provide me answer

Re: is it possible to call web service from java script

Chandrasekharan P31-May-12 20:15

Chandrasekharan P

31-May-12 20:15

You should try this link. [^]

Every new day is another chance to change your life.

Re: is it possible to call web service from java script

Iain Clarke, Warrior Programmer3-Jun-12 1:38

Iain Clarke, Warrior Programmer

3-Jun-12 1:38

You do realise this is a C++ group, with a strong bias to MFC?

There is a java and a javascript forum on codeproject too.

Good luck,

Iain.

I am one of "those foreigners coming over here and stealing our jobs". Yay me!

Division By Zero Exception

ForNow31-May-12 2:54

ForNow

31-May-12 2:54

Hi,

I have a CWinThread::run overidable that is generating a division by zero at a call to IsIdleMessage which I cann't for the life of me figure out why

Any insight is appreciated

<pre lang='cpp'> int SockCLeintThread::Run()
{ ASSERT_VALID(this);
MSG m_msgCur;
// for tracking the idle time state
if (!flags.is_connected)
return TRUE;
BOOL bIdle = TRUE;
LONG lIdleCount = 0;
// acquire and dispatch messages until a WM_QUIT message is received.
for (;;)
{ phase1: // check to see if we can do idle work
while (bIdle && !::PeekMessage(&m_msgCur, NULL, NULL, NULL, PM_NOREMOVE))
{ // call OnIdle while in bIdle state
if (!OnIdle(lIdleCount++))
bIdle = FALSE; // assume "no idle" state
} // phase2: pump messages while available
do { // pump message, but quit on WM_QUIT
if (!PumpMessage())
return ExitInstance();
// reset "no idle" state after pumping "normal" message
<b>if (IsIdleMessage(&m_msgCur))<=== code causing exception </b> bIdle = TRUE;
lIdleCount = 0;}
} while (::PeekMessage(&m_msgCur, NULL, NULL, NULL, PM_NOREMOVE));
}
ASSERT(FALSE); // not reachable
} </pre>

Re: Division By Zero Exception

C^hris L^osinger31-May-12 3:25

C^hris L^osinger

31-May-12 3:25

have you overridden IsIdleMessage ?

image processing toolkits | batch image processing

Re: Division By Zero Exception

ForNow31-May-12 12:43

ForNow

31-May-12 12:43

no I haven't

Re: Division By Zero Exception

Albert Holguin31-May-12 9:35

Albert Holguin

31-May-12 9:35

Why are you overriding CWinThread::Run() anyway? I don't see anything in your code that would require you to do this.

Re: Division By Zero Exception

ForNow31-May-12 12:44

ForNow

31-May-12 12:44

I am overriding it because I want to use PostthreadMessage and am using the code to create aa mesaage queue

CWinThread::Run works by turning optimization off #pragma optimize("",on)

ForNow31-May-12 18:24

ForNow

31-May-12 18:24

Hi,

All my exceptions Were occurring in CWinThread::Run Being an Assembler programmer I went into Assembly mode to try and debug it

However the optimizer made things crptic

I then proceeded to use the #pragma to turn off optimization after doing this however the exceptions disappeared

Thanks Again

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