|
Hi,
I have an excel sheet with some data. I need to read these data
elements from a VC++ application. How do I do this? What I need
to know specifically are:
- What component to use for getting access to an excel sheet?
- What are the methods exposed by this component which will
be useful for this purpose?
Any suggestions are welcome. Sample code or URL for the same
will be appreciated as well.
With best regards,
Sayan Mukherjee
Email:sayanmukherjee@indiatimes.com
|
|
|
|
|
I use (Excel) Automation. You can also use ODBC, but I have not personally tried that method.
|
|
|
|
|
If you use ODBC, make sure that you set the cells as a named range in Excel.
|
|
|
|
|
Hi,
I've written some utility in VC++ .Net
Now it's time to write help for it , but have never did it before.
Anyone knows any free help authoring tool that will fast and in intuitive
way generate winhelp file for my program ? Preferrably one which supports
inserting screenshots and can parse .rc/.h files to generate context help.
Thanks a lot 
|
|
|
|
|
there are 2
1. (help workshop) ... should be in the microsoft visual tools ...if not, download it
2. (HTLP help workshop)... should be in the microsoft visual tools ...if not, download it
|
|
|
|
|
|
Hi,
I have a program that needs to saves a lot of different data into a file. What I did was to put a seperator inbetween data and I used the character ^E (ASCII code 5) as the seperator. I later found out that it is fine if the data is all in English alphabets. However, other non-English languages actually uses ASCII code 5 as a readable/writable character. So if the data itself happens to have code 5 in it, my program mistakens it as a seperator and everything goes wrong.
So what I would like to know is what are the better ways organize data in a file (besides using a character as a sepeartor). And if I had to use the separator scheme, what are the best ASCII characters to use as separators?
I also don't want to use MFC's CFile and CArchive to write data.
Thank you very much!
|
|
|
|
|
Tab and comma are the most common separators. Ascii characters below 0x20 are control characters, so I have trouble imagining a language which uses Ascii 5 as a character. What language is this?
Neville Franks, Author of ED for Windows. www.getsoft.com
Make money with our new Affilate program
|
|
|
|
|
Use fixed length data if you can, then you don't need any separator.
Or use the same delimiters as Excel(or Access) uses. Test by selecting
save as,Save as type, and select some standard type.
jhaga
CodeProject House, Paul Watson wrote:
...and the roar of John Simmons own personal Nascar in the garage. Meg flitting about taking photos.Chris having an heated arguement with Colin Davies and .S.Rod. over egian values. Nish manically typing *censur*. Duncan racing around after his pet *c.* Michael Martin and Bryce loudly yelling *c.* C.G. having a fit as Roger Wright loads up *c.* . Anna waving her *c.* and Deb scoffing chocolates in the corner.
...Good heavens!
|
|
|
|
|
Use XML and you'll be fine.
|
|
|
|
|
I store data with separator '\t' ( TAB ) and i'm satisfied 
|
|
|
|
|
Hi
I've made a clistctrl + subclassed it to add more functions.
My list-view looks like this:
Employee Nr Name Age School
1 MyStupidName 15 SKL(BUTTON)
..
All fields are not editable + added some extended styles (gridlines, full row select).
If you click on the button, a dialog should appear with another listcontrol displaying all schools. After selecting a school + pressing ok, the name of the school should appear before the button.
The form is already made with all schools in the list, and when you press ok, it returns the name of the school. So that part is ok.
But how do i insert such a button into a listcontrol at the correct place of every line?
I think i have to owner-draw it, i checked a few examples at codeproject & codeguru but none seemed handling this problem.
Hope someone knows how to get this done.
and btw, i use VC5 for 'developping'
Greetings
JensB
|
|
|
|
|
I want to develop a program that runs as a scheduling program (on my webserver). I can do that by setting up a timer and frequently check the date/time to execute appropriate functions.
But I think that way is not good, it put more stress to the server. Is there any better way to do that? Does window send us date/time notification?
Please show me the way.
|
|
|
|
|
Why not just use AT, or its GUI equivalent? It comes with the OS!
|
|
|
|
|
DavidCrow wrote:
Why not just use AT, or its GUI equivalent? It comes with the OS!
Wow I'd never heard of AT - thanks. Of course I've heard of Cron in the Unix world.
Neville Franks, Author of ED for Windows. Free Trial at www.getsoft.com
|
|
|
|
|
What are AT, GUI? Please help me to understand them and to know how to use them.
|
|
|
|
|
AT is console program on WinXP and I assume W2K and NT4 and possibly other Windows platforms which lets you run commands/programs at specific times. Open a command prompt and type AT.
Neville Franks, Author of ED for Windows. Free Trial at www.getsoft.com
|
|
|
|
|
Thank you for your reply.
Oh, "Scheduled Task" tool of Windows is based on AT, isn't it? If not, is that tool equivalent AT?
|
|
|
|
|
TPN wrote:
Oh, "Scheduled Task" tool of Windows is based on AT, isn't it?
I don't know.
TPN wrote:
If not, is that tool equivalent AT?
I'd say they are very similar.
Neville Franks, Author of ED for Windows. Free Trial at www.getsoft.com
|
|
|
|
|
ultimatly every program (even the part of OS) do the same thing as you expect.
they also check for the date and time frquently and compare the current time
is Windows Sheduler can help you?
[ It is possible to represent everything in this universe by using 0 and 1 ]
|
|
|
|
|
But using a timer is not an exactly way, by ex : Starting a task when a new day starts. We can not check date/time every 1/1000s, it wastes the computer resources.
I don't know how to do, but it's very important for me.
Thanks you.
|
|
|
|
|
Hi!
I realy need to download thr Photoshop SDK .. propearly 6.. because 7 is not for free... there can i download it???
I need to make a plugin for PS ... maybe i need another info about it.. maybe not the SDK? so if not, wat?
help me please 
|
|
|
|
|
I have an MFC dislog app. The dialog has nothing on it since everything is being drawn my GDI+. My nothing I mean no menu bar or anything just a blank dialog.
I am trying to capture virtual key presses such as VK_LEFT, VK_DOWN etc. Several odd things are happening.
If you create a simple MFC dialog app with the wizard it will have two default buttons, On and OK. Using the wizard you add a message handler for OnKeyDown(). Now if you try to capture any keypresses the app just sound a "bonk" sound and does nothing. If you delete two default buttons then the OnKeyDown will capture keypress like 'A' and 'a' but still not pressed like VK_LEFT.
Ugh...
Can anyone shed some light on the subject?
Thanks,
Steve
|
|
|
|
|
For virtual keys like VK_LEFT try ON_WM_SYSKEYDOWN() and OnSysKeyDown().
Neville Franks, Author of ED for Windows. Free Trial at www.getsoft.com
|
|
|
|
|
How to check if file existe (not by trying to open it, fail : not existe or not)
How to get the temporary file name which is not coincide with existing files.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
