C / C++ / MFC

1-Jun-12 5:42

To preview xls file i call CreateFromFile or CreateFromClipboard and it works

But if xls file has password and i do not enter it then my program hangs. It gives switch to/retry message.
Is there any way to solve this problem

David Crow1-Jun-12 6:49

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

MKC0021-Jun-12 23:15

1-Jun-12 23:15

I want to show excel file contents in my own window

David Crow4-Jun-12 2:40

4-Jun-12 2:40

Ok, so what's the problem?

MKC0024-Jun-12 4:33

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.

David Crow4-Jun-12 5:07

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.

MKC0024-Jun-12 18:55

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?

David Crow5-Jun-12 2:25

5-Jun-12 2:25

MKC002 wrote:
Is that possible with excel automation?

Yes.

MKC0026-Jun-12 1:22

6-Jun-12 1:22

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

David Crow6-Jun-12 2:18

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.

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.

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.

_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 ...

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.

Erudite_Eric1-Jun-12 20:52

Erudite_Eric

1-Jun-12 20:52

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

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

Nothing to say.