Re: Driving MS-Excel. - C / C++ / MFC Discussion Boards

Re: OS awareness

Rage26-May-03 4:40

Rage

26-May-03 4:40

#ifdef is a precompiler command. If you put your code like :

#ifdef WINDOWS

bla ...

#elsif UNIX

stuff...

#endif

then putting a #define WINDOWS at top of the file will compile only the code between WINDOWS "scope" (i.e. bla...), and #define UNIX will compile the "stuff...". But this is only at compilation time and you need something at run-time. On solution would be to compile two separate app, one for Unix, one for Windows. Second solution would be to ask the user about the OS when installing your app, store the result in the registry, and read the key at application start.

~RaGE();

Re: OS awareness

markkuk26-May-03 4:51

markkuk

26-May-03 4:51

The same executable file won't run under both Windows and Unix, so there must always be two separately compiled applications.

Re: OS awareness

Themis26-May-03 7:55

Themis

26-May-03 7:55

Hm, did I say run-time??? Well I wanted to say compile time, thank you for your help.

Themis

Re: OS awareness

markkuk26-May-03 4:48

markkuk

26-May-03 4:48

Most compilers have predefined macros specifying the OS used for compilation like __WIN32__ or __unix__

Re: OS awareness

Alvaro Mendez26-May-03 7:06

Alvaro Mendez

26-May-03 7:06

The ones I know of, predefined by the compiler (so you don't have to):

__unix<br />
_WIN32

Regards,
Alvaro

If you want to get to the top, prepare to kiss a lot of bottom. -- despair.com

Driving MS-Excel.

⁷³Zeppelin26-May-03 4:14

⁷³Zeppelin

26-May-03 4:14

Seems I'm full of questions today.

Is there and easy way to send data to and Excel worksheet
from an MFC application?
For example, if I have an open excel worksheet, can I send data
from a separate application to that worksheet with a small amount of
code/effort?
We're looking to automate a painful manual import of data into Excel.
Thanks.

Re: Driving MS-Excel.

Andrew Walker26-May-03 4:28

Andrew Walker

26-May-03 4:28

John Theal wrote:
Is there and easy way to send data to and Excel worksheet from an MFC application?

Use automation.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnautoma/html/msdn_thrdole.asp[^]

Re: Driving MS-Excel.

Rage26-May-03 4:30

Rage

26-May-03 4:30

John Theal wrote:
Is there and easy way to send data to and Excel worksheet
from an MFC application?
For example, if I have an open excel worksheet, can I send data
from a separate application to that worksheet with a small amount of
code/effort?

It depends of what you want to do. Just make a search on MSDN[^] with "HOWTO automation Excel", or have a look at Article ID: Q178749 and Article ID: Q178781 (in MSDN) and you will have a good start.

~RaGE();

Capturing of View

TDS26-May-03 4:02

TDS

26-May-03 4:02

We need to capture view, when a dialog box is being displayed. we are not getting the information of the view which is below the dialog box.
could anybody please help to solve this problem.
thanx.

Re: Capturing of View

Rage26-May-03 4:27

Rage

26-May-03 4:27

What is not working ? What did you try ? How is your code ? What is returned by GetActiveView() ?

~RaGE();

MFC document menu

Rowan Seymour26-May-03 4:00

Rowan Seymour

26-May-03 4:00

I'm coding an MFC MDI doc/view simple sound editor called Asaph.

There are 2 menu resources: the IDR_MAINFRAME one for when there are no open docs, and the IDR_ASAPHTYPE one used when a doc is open.
I want to be able to dynamically add menu items (using CMenu::InsertMenu()) for things like plugins, to the IDR_ASAPHTYPE menu.

Even tho the applicatiopn starts with a new blank doc, when CMainFrame::OnCreate() is called, GetMenu() still returns the CMenu created from IDR_MAINFRAME.

When is the doc menu loaded and how I can I access it to add the items ?

My only idea so far is to do it from the the document class in the first call to OnNewDocument() or OnOpenDocument() but that seems like a bit of a hack fix.

Cheers, Rowan

Getting version information from a resource

Trollslayer26-May-03 3:35

Trollslayer

26-May-03 3:35

In order to write registry keys etc., I want t use the details entered in the version part of a resource (such as CompanyName).
The question is, how do I read this ?
Thanks.

Elaine Rose | [Rose]

The tigress is here Big Grin | :-D

Re: Getting version information from a resource

Michael Dunn26-May-03 4:30

Michael Dunn

26-May-03 4:30

Here you go Smile | :)

// GetDllVersion - Returns version # in a string: "1.2.3.4"
// Reads the ProductVersion info block from the given file and returns it in sProductVersion.
// Return value is true/false for success/failure.
 
bool GetDllVersion ( LPTSTR szDllFilename, std::string& sProductVersion )
{
DWORD dwHandle, dwInfoSize;
BYTE* pBuffer;
void* pvVersion;
UINT  uBufLen;
 
    dwInfoSize = GetFileVersionInfoSize ( szDllFilename, &dwHandle );
 
    if ( 0 == dwInfoSize )
        return false;
 
    pBuffer = new BYTE [dwInfoSize];
 
    if ( NULL == pBuffer )
        return false;
 
__try
    {
    if ( 0 == GetFileVersionInfo ( szDllFilename, dwHandle, dwInfoSize, pBuffer
        return false;
 
    if ( 0 == VerQueryValue ( pBuffer, _T("\\StringFileInfo\\040904B0\\ProductVersion"),
                              &pvVersion, &uBufLen ))
        return false;
 
    sProductVersion = (LPCTSTR) pvVersion;
    }
__finally
    {
    delete [] pBuffer;
    }
 
    return true;
}

--Mike--
Latest blog entry: *drool* (Alyson) [May 10]
Ericahist | Homepage | RightClick-Encrypt | 1ClickPicGrabber
"You have Erica on the brain" - Jon Sagara to me

Re: Getting version information from a resource

Trollslayer26-May-03 5:04

Trollslayer

26-May-03 5:04

Thanks Mike, but that is to get the version number of an external DLL.
I was trying to avoid redundant information in my project by reading the CompanyName string from the resource and using that to build the registry key entry. This would include ProductName.

Elaine Rose | [Rose]

The tigress is here Big Grin | :-D

Re: Getting version information from a resource

Michael Dunn26-May-03 9:55

Michael Dunn

26-May-03 9:55

That's what the code does, reads the version resource from a binary (it doesn't have to be a DLL, you can pass the filename of your EXE). Just change the "ProductVersion" part in the VerQueryValue() call to the field you want to read.

--Mike--
Latest blog entry: *drool* (Alyson) [May 10]
Ericahist | Homepage | RightClick-Encrypt | 1ClickPicGrabber
"You have Erica on the brain" - Jon Sagara to me

File error checking.

⁷³Zeppelin26-May-03 3:06

⁷³Zeppelin

26-May-03 3:06

Is this a valid check to see if a file has been opened?

// Save original Node data
ofstream NodeOrig;
NodeOrig.open("NodeOrig.txt", ios::out);

if ( !NodeOrig.is_open() )
    throw "Could not open original node data file.\n";

Re: File error checking.

Rage26-May-03 3:32

Rage

26-May-03 3:32

If you are sure the target file path is correct and the file not corrupted, then Yes.

~RaGE();

Re: File error checking.

⁷³Zeppelin26-May-03 3:37

⁷³Zeppelin

26-May-03 3:37

Maybe this is a bit more robust?

// Save original Node data
ofstream NodeOrig;
NodeOrig.open("NodeOrig.txt", ios::out);

if ( NodeOrig.fail() )
    throw "Could not open original node data file.\n";

or maybe I should be checking flags?
Eg:

if(FileStream.rdstate() == ios::eofbit)

      cout << "End of file!\n";

if(FileStream.rdstate() == ios::badbit)

      cout << "Fatal I/O error!\n";

if(FileStream.rdstate() == ios::failbit)

      cout << "Non-fatal I/O error!\n";

if(FileStream.rdstate() == ios::goodbit)

      cout << "No errors!\n";

Re: File error checking.

Andrew Walker26-May-03 3:39

Andrew Walker

26-May-03 3:39

Maybe just?

if(FileStream.fail())
{
  throw ...
}

How to owner-draw the titlebar of one SDI ?

scgy94_jiang26-May-03 2:47

scgy94_jiang

26-May-03 2:47

the problem is : where should i put the lines of drawing ? in OnPaint() only? what else should i do ?

i wish to draw the titlebar of one SDI program. but i met some problems.

here is how i do it as following:

i add lines in the CMainFrame::OnPaint() :

	<br />
CFrameWnd::OnPaint();<br />
<br />
	if (IsIconic()) return;<br />
<br />
	RECT stRect1;<br />
<br />
        // Get the coordinates of the window on the screen<br />
        ::GetWindowRect(m_hWnd, &stRect1);<br />
<br />
	CRgn m_rgn0;<br />
        m_rgn0.CreateRectRgn(0,8,stRect1.right-stRect1.left,stRect1.bottom-                             stRect1.top);<br />
<br />
        SetWindowRgn(m_rgn0,1);<br />
<br />
	<br />
	RECT stRect;<br />
<br />
	CRect rect;<br />
<br />
<br />
	CDC *pDC;<br />
	pDC = GetWindowDC();<br />
	<br />
<br />
<br />
<br />
        // Get the coordinates of the window on the screen<br />
        ::GetWindowRect(m_hWnd, &stRect);<br />
<br />
	<br />
<br />
    rect.SetRect(0,0,stRect.right - stRect.left,stRect.bottom - stRect.top);<br />
<br />
    // Get a handle to the window's device context<br />
    HDC hDC = ::GetWindowDC(m_hWnd);<br />
<br />
    HPEN hPen;<br />
    hPen = CreatePen(PS_INSIDEFRAME, 1* GetSystemMetrics(SM_CXBORDER), <br />
        RGB(123, 200, 243));<br />
<br />
	CPen pen;<br />
<br />
	pen.CreatePen(PS_INSIDEFRAME, 1* GetSystemMetrics(SM_CXBORDER), <br />
        RGB(123, 220, 233));<br />
<br />
<br />
	pDC->SelectObject(&pen);<br />
<br />
	//CBrush brush;<br />
<br />
	<br />
<br />
	<br />
    // Draw the rectangle around the window<br />
    HPEN   hOldPen   = (HPEN)SelectObject(hDC, hPen);<br />
    HBRUSH hOldBrush = (HBRUSH)SelectObject(hDC, GetStockObject(NULL_BRUSH));<br />
<br />
	stRect.bottom = stRect.bottom-stRect.top;<br />
	stRect.right = stRect.right-stRect.left;<br />
<br />
	int btm = stRect.bottom;<br />
	<br />
	CRgn m_rgn6,m_rgn5,m_rgn7;<br />
<br />
	m_rgn6.CreateRectRgn(0,0,4,stRect.bottom);<br />
	m_rgn5.CreateRectRgn(stRect.right -4,0,stRect.right,stRect.bottom);<br />
	m_rgn7.CreateRectRgn(0,stRect.bottom-4,stRect.right,stRect.bottom);<br />
<br />
	stRect.left = 0 ;<br />
	stRect.top = 0 ;<br />
	stRect.bottom = 29;<br />
<br />
	<br />
	<br />
	m_rgn2.CreateRectRgn(stRect.left,stRect.top,stRect.right,stRect.bottom);<br />
	//pDC->SelectObject(&brush);<br />
<br />
	m_rgn2.CombineRgn(&m_rgn2,&m_rgn,RGN_DIFF);<br />
	m_rgn2.CombineRgn(&m_rgn2,&m_rgn6,RGN_OR);<br />
	m_rgn2.CombineRgn(&m_rgn2,&m_rgn5,RGN_OR);<br />
	m_rgn2.CombineRgn(&m_rgn2,&m_rgn7,RGN_OR);<br />
<br />
	SelectClipRgn(hDC,HRGN(m_rgn2));<br />
<br />
<br />
	CBrush brush;<br />
<br />
	brush.CreateSolidBrush(RGB(255,255,255));<br />
	//pDC->SelectClipRgn(&m_rgn2,RGN_AND);<br />
	//brush.CreateStockObject(NULL_BRUSH);<br />
	<br />
	<br />
<br />
	//pDC->FillRgn(&m_rgn2,&brush);<br />
<br />
	FillRgn(hDC,HRGN(m_rgn2),HBRUSH(brush));<br />
<br />
	brush.CreateStockObject(NULL_BRUSH);<br />
<br />
	int i = 0;<br />
<br />
	for (i; i < btm;i)<br />
	{<br />
		MoveToEx(hDC,0,i,NULL);<br />
		LineTo(hDC,stRect.right,i);	<br />
		i += 2;<br />
	}<br />
<br />
    hPen = CreatePen(PS_INSIDEFRAME, 2* GetSystemMetrics(SM_CXBORDER), <br />
     RGB(33, 120, 120));<br />
<br />
	SelectObject(hDC, hPen);<br />
<br />
	MoveToEx(hDC,2,28,NULL);<br />
	LineTo(hDC,stRect.right-2,28);<br />
<br />
<br />
	MoveToEx(hDC,3,28,NULL);<br />
	LineTo(hDC,3,btm-3);<br />
	<br />
	MoveToEx(hDC,stRect.right-3,28,NULL);<br />
	LineTo(hDC,stRect.right-3,btm-3);<br />
<br />
	MoveToEx(hDC,3,btm-4,NULL);<br />
	LineTo(hDC,stRect.right-3,btm-4);<br />
<br />
<br />
	MoveToEx(hDC,0,0,NULL);<br />
	LineTo(hDC,0,btm);<br />
<br />
	MoveToEx(hDC,stRect.right,0,NULL);<br />
	LineTo(hDC,stRect.right,btm);<br />
<br />
<br />
    //Give the window its device context back, and destroy our pen<br />
    ::ReleaseDC(m_hWnd,hDC);<br />
<br />
    SelectObject(hDC, hOldPen);<br />
    SelectObject(hDC, hOldBrush);<br />
<br />
    DeleteObject(hPen);<br />
    DeleteObject(hDC);

it works well at most times, but when the window lost focus or reactiviate, it doesn't redraw. when u drag this window, it doesn't redraw after it moves from top-outside area back, either.
Jiang

What message should i handle to perform this?

scgy94_jiang26-May-03 2:58

scgy94_jiang

26-May-03 2:58

ast

Re: What message should i handle to perform this?

Rage26-May-03 3:40

Rage

26-May-03 3:40

Try also the invalidate in OnEraseBackground() only, this should catch the three previous cases.

~RaGE();

Re: How to owner-draw the titlebar of one SDI ?

Rage26-May-03 3:38

Rage

26-May-03 3:38

Try to Invalidate() your window titlebar rect in OnActivate(), OnKillFocus() and OnMoving()

~RaGE();

Re: How to owner-draw the titlebar of one SDI ?

John R. Shaw26-May-03 9:33

John R. Shaw

26-May-03 9:33

OnPaint() is used to paint the client area. The title bar is a non-client area. Look up (search) WM_NCPAINT or OnNcPaint(). You could also try searching for "owner drawn title bar" here or on the www.

Trust in the code Luke. Yea right!

zip, docfile?

novachen26-May-03 2:21

novachen

26-May-03 2:21

I am designing a software to collect and organize web pages catched from internet and the drafts created user himself. In my first model, i store them in file system. But there are so many little gif/jpg that will waste disk space and not easy to manage. I hope there is a way to pack them into a single file or database.
The first thing into my mind is a zip file, but i dont know whether it is efficient enough for delete and insert frequently.
The second one is a ole docfile, it is said to be a file with directory structure inside. But i have very limit knowledge about it, hope somebody can tell me whether it is fit for my usage.
The third one is some object databases, i know zope is a good one, but it is build on python. Hope you can introduce some good c/c++ object database for me.
Thank you!

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