|
From my experience I can tell you I've found two ways to read data from excel files, one is by adding the excel assembly reference to your project and creating an instance of the Excel application object, I suppose this would be the only way to actually 'show' the Excel grid programmatically, beware though, that this requires excel to be installed in any client executing you app. The other way is to use Extended Properties of the OleDbDataAdapter which allows you to get a range of cells or an entire worksheet into a DataTable, thereafter you can manipulate the data, show it in a datagrid or do whatever you need with it.
Chris.
|
|
|
|
|
Here an msdn search that will give you some articles/samples on doing this with ado.net's dataadapter:
http://search.microsoft.com/search/results.aspx?qu=excel+file+ado.net&View=msdn&st=b&c=0&s=1&swc=0
|
|
|
|
|
Hi,
im coding proper SDK now and i did a toolbar with couple of buttons, and each button got a BMP file that i created.
how can i add 24bit bmp and not only 8bit?
Avi
|
|
|
|
|
|
yeah, but everything is fine except that im coding only with SDK and no MFC.
do u know the exact way to do it bcuz i searched everywhere and nothing 
|
|
|
|
|
I would have downloaded the sample for one of the toolbars, for example http://www.codeproject.com/docking/ctruecolortoolbar_update.asp[^]. Build the sample and singlestep - in this case it's the function LoadTrueColorToolBar that is interesting. Step into the MFC source, where you will see the underlying SDK calls. The main problem with MFC is not that it is complicated, rather that it is a far too thin wrapper of the SDK
|
|
|
|
|
Hi,
how can i get the document pointer of CDocument derived class and traverse thru all views of the document?Say i have the caption of the MDI child Frame which should be activated..Currently that frame is inactive and some other frame is active.Now how can i activate that view....Is there any way such that i can get the handle of the child frame and then gets its window text and compare with my own text.If they both match then bring that frame and its view to active state..........how can i do it????
|
|
|
|
|
Poorniselva wrote:
how can i get the document pointer of CDocument derived class...
From the view class, call the GetDocument() method.
Poorniselva wrote:
Now how can i activate that view...
How about CFrameWnd::SetActiveView()?
Poorniselva wrote:
...and then gets its window text
Use GetWindowText().
"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen
|
|
|
|
|
plz
some one tell me how can i display bitmaps file in my app?
|
|
|
|
|
See if any of these articles help.
"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen
|
|
|
|
|
Hello,
I am currently writing a Windows Background Service and have run into some trouble.
So far things have been going well, but the only problem I have is that I need to set the state of the CAPS LOCK to on, which I am unable to achieve.
I have include winable.h and I am using the code:
::keybd_event( VK_CAPITAL, 0x45, KEYEVENTF_EXTENDEDKEY, 0 );
::keybd_event( VK_CAPITAL, 0x45, KEYEVENTF_EXTENDEDKEY | KEYEVENTF_KEYUP, 0 );
Which works in a regular console application, but I can't seem to get it to work in a windows service.
Is there some sort of security restriction that prevents me from changing the key state? Other then that, I have no idea.
Thanks in advance
|
|
|
|
|
Why do you need to alter the state of the CAPS LOCK key from within a service?
"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen
|
|
|
|
|
I do know that Windows Services run as the System user. When you create your service, are you giving it desktop privileges? Perhaps that's what's needed.
Check out the SERVICE_INTERACTIVE_PROCESS flag for the ::CreateService API on MSDN.
Note that chances are, the problem lies with the code that creates and registers your service, not the service itself.
"Fish and guests stink in three days." - Benjamin Franlkin
|
|
|
|
|
Hi!
I’ve used the java-program “Together” to generate a picture of my programming project, but now my license is out. Anyone got a tip of a good free alternative? I’m using VS.NET and would be very happy if I have a solution there…
...and justice for all
APe
|
|
|
|
|
|
I tried a few recently and Visual Paradigm seems to be as good as Visio proffesional.
Elaine ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
The tigress is here 
|
|
|
|
|
I just gave it a quick look...
Which language does it support?
...and justice for all
APe
|
|
|
|
|
Hai all,
When I am using Dialog Bar with buttons in win CE, the dialog bar appears but I am not able to browse the button. Mouse move event is also not occur. if anybody tell me the solution or weblinks.
thank you all
DARWIN PAUL RAJ
|
|
|
|
|
hi all, i am developing a windows explorer like app, i took a SDI app, created 2 views, a splitter window and my problem is how do i get the drives to be displayed in the tree view ?? and the files and folders in List view.
appreciate all ideas..
regards,
Kapil
|
|
|
|
|
The left pane needs to be a CTreeView, and the right pane needs to be a CListView. I assume you've gotten at least that far.
The item(s) in the tree view should start out with just top level drives (e.g., drive C). When any of those drives are expanded, the top-level folders of that drive are displayed. With each folder that is expanded, the folders under it are displayed. This would continue on an as-needed basis. Otherwise, a full scan of the drive prior to displaying, would take way too long to be of any use.
When an item in the tree view is clicked on, the contents of that folder are displayed in the list view.
Here is a pseudo-example.
Here is a C# example. And another.
"When I was born I was so surprised that I didn't talk for a year and a half." - Gracie Allen
|
|
|
|
|
Can we convert BMP to JPG image using VC++. If so what is the code that has to be written in VC++.
|
|
|
|
|
There are many solutions such as
CImage of MFC(or ATL), some third party libraries such as jpeglib.lib , CImageX etc.
Unmanaged in a .NET world
|
|
|
|
|
Take a look at the CxImage class here at cp.com
modified 12-Sep-18 21:01pm.
|
|
|
|
|
You also have the ability to do it in GDI+.
|
|
|
|
|
Hi,
I have a normal Doc/View application, and i see that even if i call AfxEnableControlContainer() the m_pOccManager of the AFX_MODULE_STATE remains NULL - and then all my OCX's crash...
any ideas? tried CoInitialize(NULL); as well, nothing seems to help
10x!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
