|
Hello guys,
Consider I have some text data(maybe a Microsoft Access database *.mdb file
too), and I want to save them as Microsoft Excel file.
How can I achieve that ?
thanks.
PS. I have MFC Dialog based Application
"Success is the ability to go from one failure to another with no loss of enthusiasm." - W.Churchill
-- modified at 9:25 Saturday 4th February, 2006
|
|
|
|
|
I haven't actually tried this, but you might be able use Microsoft's ODBC driver for Excel[^].
Steve
|
|
|
|
|
You might want to save the data in Comma Separated Variable (csv) format. Excel can open csv format files directly. For instance:
int value1 = 20;
int value2 = 32;
float value3 = 10.3f;
FILE* myFile;
myFile = fopen("c:\\temp\\foo.csv", "wt");
if(myFile)
{
fprintf(myFile, "%d, %d, %.1f\n", value1, value2, value3);
}
fclose(myFile);
Graham
|
|
|
|
|
thanks Graham.
"Success is the ability to go from one failure to another with no loss of enthusiasm." - W.Churchill
|
|
|
|
|
I use this one since a long time. You're able to modify it like you want.
http://www.codeproject.com/printing/testexcel.asp
|
|
|
|
|
meinhard_risch wrote: http://www.codeproject.com/printing/testexcel.asp
Good link, thanks
"Success is the ability to go from one failure to another with no loss of enthusiasm." - W.Churchill
|
|
|
|
|
Suppose that I have a CString variable inside it there is a float,
How can I affect this value to a variable float:
Ex
CString varstr("1258.59");
float varfloat;
How to affect 1258.59 in varfloat ?
I learn my self
|
|
|
|
|
One way would be the following:
double dval = _tstof(varstr);
You'll need to make sure <tchar.h> is included.
Steve
|
|
|
|
|
|
try strtod or neutral _tcstod
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow cheers, Alok Gupta VC Forum Q&A :- I/ IV
|
|
|
|
|
Hey everyone.
I keep getting this error while using Visual C++ 2005 Express Edition, does anyone know how to fix this?
Error 1 error C2664: 'MessageBoxW' : cannot convert parameter 2 from 'const char [15]' to 'LPCWSTR' d:\my documents\visual studio 2005\projects\hello-win32\hello-win32\page1.cpp 17
Thanks in Advance
|
|
|
|
|
Wrap the strings in your MessageBox in the _T macro like this:
MessageBox(NULL, _T("Hello"), _T("Hello"), MB_OK);
If you get an error saying _T is not defined add #include <tchar.h> to your project (in the precompiled header would be the best).
Steve
|
|
|
|
|
It sounds like your program is set to compile for UNICODE, which implies that most Windows API functions that take strings expect UNICODE strings. The LPCWSTR in this case refers to a 'Long Pointer to Constant Wide-character STRing'.
The previous suggestion is correct; wrap your strings in the '_T("string") ' macro call, which is #define 'd in tchar.h . _T("string") evaluates to L"string" when compiling for UNICODE, and just "string" when compiling for MBCS.
Software Zen: delete this;
|
|
|
|
|
Hello!!
I am doing MFC programming after a very long time. I had forgot all the basic concepts.
I am working on an mfc sdi application. Could anybody tell me how to add a dialog to it.
I want the dialog to be displayd when i click on a specific menu item.
Thanx
"If you change then change for the good."
|
|
|
|
|
I think by default, there willl be a "About" dialog box when u choose the mfc sdi application, right? Just add a dialog from the resource and see how it map the message then that's it!
|
|
|
|
|
i am looking on the net for a long time for an example code that shows how can i resolve Channel.
does anybody know?
thanks.
|
|
|
|
|
can somebody help my please?
|
|
|
|
|
I have a problem with my project .My project is about socket programming with multiThread.
|
|
|
|
|
you have to create your own data object class like below.
...::OnConnected(sockthread* client)
{
client->data = new MyClientData;
..
}
one thread has to have one MyClientData.
this is the problem that mostly occured in socket programming.
Anderson Sheen (exteide@gmail.com)
The Extension IDE: http://www.exteide.com
|
|
|
|
|
Hi everybody!
I would like to add graphical objects like buttons and so on to my project. But I do not want to use any wizzard.
In every book I bought there is just the information how to add things by using the wizzard.
Were can I get sources of information about Vc++ .Net, that I will be able to programm everything without a wizzard.
Thank you very much.
Georg
|
|
|
|
|
like this?
class CCustomPrjToolWindow : public CFrameWnd
{
...
protected:
CButton btn;
};
CCustomPrjToolWindow::CCustomPrjToolWindow()
{
Create(NULL, "Custom Project Tool Window", WS_OVERLAPPEDWINDOW);
btn.Create( "button", WS_CHILD | WS_VISIBLE, CRect(20, 100, 150, 120), this, 0);
}
if you want to catch the btn click event, you have to make your own button class that is overrided from CButton.
Enjoy
Anderson Sheen (exteide@gmail.com)
The Extension IDE: http://www.exteide.com
|
|
|
|
|
Thank you so much I will try this!
Do you have any book recommendation how to learn this without the wizzard?
I have knowledge in programming C++ and I would need information how the framework works and its functionality.
Thank you very much in advance.
Georg
|
|
|
|
|
|
I am doing project in vc.I have created a directory and allocated space for that directory,right now i wanted to lock or restrict the directory .How it can be done
|
|
|
|
|
to lock the directory, use SetCurrentDirectory("c:\\folder");
and you can catch the state of file or dir by using FindFirstChangeNotification API series.
Enjoy
Anderson Sheen (exteide@gmail.com)
The Extension IDE: http://www.exteide.com
|
|
|
|