]> git.saurik.com Git - wxWidgets.git/commitdiff
Added wxAutomationObject class.
authorJulian Smart <julian@anthemion.co.uk>
Tue, 8 Dec 1998 18:55:30 +0000 (18:55 +0000)
committerJulian Smart <julian@anthemion.co.uk>
Tue, 8 Dec 1998 18:55:30 +0000 (18:55 +0000)
git-svn-id: https://svn.wxwidgets.org/svn/wx/wxWidgets/trunk@1133 c3d73ce0-8a6f-49c7-b76d-6d57e0e08775

src/msw/ole/automtn.cpp [new file with mode: 0644]

diff --git a/src/msw/ole/automtn.cpp b/src/msw/ole/automtn.cpp
new file mode 100644 (file)
index 0000000..2d94102
--- /dev/null
@@ -0,0 +1,1108 @@
+/////////////////////////////////////////////////////////////////////////////
+// Name:        automtn.cpp
+// Purpose:     OLE automation utilities
+// Author:      Julian Smart
+// Modified by:
+// Created:     11/6/98
+// RCS-ID:      $Id$
+// Copyright:   (c) 1998, Julian Smart
+// Licence:     wxWindows Licence
+/////////////////////////////////////////////////////////////////////////////
+
+#ifdef __GNUG__
+#pragma implementation "automtn.h"
+#endif
+
+// For compilers that support precompilation, includes "wx.h".
+#include "wx/wxprec.h"
+
+#if defined(__BORLANDC__)
+#pragma hdrstop
+#endif
+
+#include "wx/log.h"
+#include "wx/msw/ole/automtn.h"
+
+#include <windows.h>
+#include <ole2ver.h>
+#include <oleauto.h>
+#include <math.h>
+#include <time.h>
+
+// Convert string to Unicode
+static BSTR ConvertStringToOle(const wxString& str);
+
+// Convert string from BSTR to wxString
+static wxString ConvertStringFromOle(BSTR bStr);
+
+// Verifies will fail if the needed buffer size is too large
+#define MAX_TIME_BUFFER_SIZE    128         // matches that in timecore.cpp
+#define MIN_DATE                (-657434L)  // about year 100
+#define MAX_DATE                2958465L    // about year 9999
+
+// Half a second, expressed in days
+#define HALF_SECOND  (1.0/172800.0)
+
+// One-based array of days in year at month start
+static int rgMonthDays[13] =
+       {0, 31, 59, 90, 120, 151, 181, 212, 243, 273, 304, 334, 365};
+
+static BOOL OleDateFromTm(WORD wYear, WORD wMonth, WORD wDay,
+       WORD wHour, WORD wMinute, WORD wSecond, DATE& dtDest);
+static BOOL TmFromOleDate(DATE dtSrc, struct tm& tmDest);
+static void TmConvertToStandardFormat(struct tm& tmSrc);
+static double DoubleFromDate(DATE dt);
+static DATE DateFromDouble(double dbl);
+
+static void ClearVariant(VARIANTARG *pvarg) ;
+static void ReleaseVariant(VARIANTARG *pvarg) ;
+// static void ShowException(LPOLESTR szMember, HRESULT hr, EXCEPINFO *pexcep, unsigned int uiArgErr);
+
+/*
+ * wxAutomationObject
+ */
+
+wxAutomationObject::wxAutomationObject(WXIDISPATCH* dispatchPtr)
+{
+       m_dispatchPtr = dispatchPtr;
+}
+
+wxAutomationObject::~wxAutomationObject()
+{
+       if (m_dispatchPtr)
+       {
+               ((IDispatch*)m_dispatchPtr)->Release();
+               m_dispatchPtr = NULL;
+       }
+}
+
+#define INVOKEARG(i) (args ? args[i] : *(ptrArgs[i]))
+
+// For Put/Get, no named arguments are allowed.
+bool wxAutomationObject::Invoke(const wxString& member, int action,
+        wxVariant& retValue, int noArgs, wxVariant args[], const wxVariant* ptrArgs[]) const
+{
+       if (!m_dispatchPtr)
+               return FALSE;
+
+       // nonConstMember is necessary because the wxString class doesn't have enough consts...
+       wxString nonConstMember(member);
+
+       int ch = nonConstMember.Find('.');
+       if (ch != -1)
+       {
+               // Use dot notation to get the next object
+               wxString member2(nonConstMember.Left((size_t) ch));
+               wxString rest(nonConstMember.Right(nonConstMember.Length() - ch - 1));
+               wxAutomationObject obj;
+               if (!GetObject(obj, member2))
+                       return FALSE;
+               return obj.Invoke(rest, action, retValue, noArgs, args, ptrArgs);
+       }
+
+       VARIANTARG vReturn;
+       ClearVariant(& vReturn);
+
+       VARIANTARG* vReturnPtr = & vReturn;
+
+       // Find number of names args
+       int namedArgCount = 0;
+       int i;
+       for (i = 0; i < noArgs; i++)
+               if (!INVOKEARG(i).GetName().IsNull())
+               {
+                       namedArgCount ++;
+               }
+
+       int namedArgStringCount = namedArgCount + 1;
+       BSTR* argNames = new BSTR[namedArgStringCount];
+       argNames[0] = ConvertStringToOle(member);
+
+       // Note that arguments are specified in reverse order
+       // (all totally logical; hey, we're dealing with OLE here.)
+
+       int j = 0;
+       for (i = 0; i < namedArgCount; i++)
+       {       
+               if (!INVOKEARG(i).GetName().IsNull())
+               {
+                       argNames[(namedArgCount-j)] = ConvertStringToOle(INVOKEARG(i).GetName());
+                       j ++;
+               }
+       }
+
+       // + 1 for the member name, + 1 again in case we're a 'put'
+       DISPID* dispIds = new DISPID[namedArgCount + 2];
+
+       HRESULT hr;
+       DISPPARAMS dispparams;
+       unsigned int uiArgErr;
+       EXCEPINFO excep;
+       
+       // Get the IDs for the member and its arguments.  GetIDsOfNames expects the
+       // member name as the first name, followed by argument names (if any).
+       hr = ((IDispatch*)m_dispatchPtr)->GetIDsOfNames(IID_NULL, argNames,
+                                                               1 + namedArgCount, LOCALE_SYSTEM_DEFAULT, dispIds);
+       if (FAILED(hr)) 
+       {
+//             ShowException(szMember, hr, NULL, 0);
+               return FALSE;
+       }
+
+       // if doing a property put(ref), we need to adjust the first argument to have a
+       // named arg of DISPID_PROPERTYPUT.
+       if (action & (DISPATCH_PROPERTYPUT | DISPATCH_PROPERTYPUTREF))
+       {
+               namedArgCount = 1;
+               dispIds[1] = DISPID_PROPERTYPUT;
+               vReturnPtr = (VARIANTARG*) NULL;
+       }
+
+       // Convert the wxVariants to VARIANTARGs
+       VARIANTARG* oleArgs = new VARIANTARG[noArgs];
+       for (i = 0; i < noArgs; i++)
+       {
+               // Again, reverse args
+               wxVariant& theVariant = INVOKEARG((noArgs-1) - i);
+               if (!ConvertVariantToOle(theVariant, oleArgs[i]))
+                       return FALSE; // TODO: clean up memory at this point
+       }
+
+       dispparams.rgdispidNamedArgs = dispIds + 1;
+       dispparams.rgvarg = oleArgs;
+       dispparams.cArgs = noArgs;
+       dispparams.cNamedArgs = namedArgCount;
+       
+       excep.pfnDeferredFillIn = NULL;
+       
+       hr = ((IDispatch*)m_dispatchPtr)->Invoke(dispIds[0], IID_NULL, LOCALE_SYSTEM_DEFAULT,
+                                               action, &dispparams, vReturnPtr, &excep, &uiArgErr);
+
+       for (i = 0; i < namedArgStringCount; i++)
+       {
+               SysFreeString(argNames[i]);
+       }
+       delete[] argNames;
+       delete[] dispIds;
+       
+       for (i = 0; i < noArgs; i++)
+               ReleaseVariant(& oleArgs[i]) ;
+       delete[] oleArgs;
+       
+       if (FAILED(hr)) 
+       {
+               // display the exception information if appropriate:
+//             ShowException((const char*) member, hr, &excep, uiArgErr);
+       
+               // free exception structure information
+               SysFreeString(excep.bstrSource);
+               SysFreeString(excep.bstrDescription);
+               SysFreeString(excep.bstrHelpFile);
+
+               if (vReturnPtr)
+                       ReleaseVariant(vReturnPtr);
+               return FALSE;
+       }
+       else
+       {
+               if (vReturnPtr)
+               {
+                       // Convert result to wxVariant form
+                       ConvertOleToVariant(vReturn, retValue);
+                       // Mustn't release the dispatch pointer
+                       if (vReturn.vt == VT_DISPATCH)
+                       {
+                               vReturn.pdispVal = (IDispatch*) NULL;
+                       }
+                       ReleaseVariant(& vReturn);
+               }
+       }
+       return TRUE;
+}
+
+// Invoke a member function
+wxVariant wxAutomationObject::CallMethod(const wxString& member, int noArgs, wxVariant args[])
+{
+       wxVariant retVariant;
+       if (!Invoke(member, DISPATCH_METHOD, retVariant, noArgs, args))
+       {
+               retVariant.MakeNull();
+       }
+       return retVariant;
+}
+
+wxVariant wxAutomationObject::CallMethod(const wxString& member,
+               const wxVariant& arg1, const wxVariant& arg2,
+               const wxVariant& arg3, const wxVariant& arg4,
+               const wxVariant& arg5, const wxVariant& arg6)
+{
+       const wxVariant** args = new const wxVariant*[6];
+       int i = 0;
+       if (!arg1.IsNull())
+       {
+               args[i] = & arg1;
+               i ++;
+       }
+       if (!arg2.IsNull())
+       {
+               args[i] = & arg2;
+               i ++;
+       }
+       if (!arg3.IsNull())
+       {
+               args[i] = & arg3;
+               i ++;
+       }
+       if (!arg4.IsNull())
+       {
+               args[i] = & arg4;
+               i ++;
+       }
+       if (!arg5.IsNull())
+       {
+               args[i] = & arg5;
+               i ++;
+       }
+       if (!arg6.IsNull())
+       {
+               args[i] = & arg6;
+               i ++;
+       }
+       wxVariant retVariant;
+       if (!Invoke(member, DISPATCH_METHOD, retVariant, i, NULL, args))
+       {
+               retVariant.MakeNull();
+       }
+       delete[] args;
+       return retVariant;
+}
+
+// Get/Set property
+wxVariant wxAutomationObject::GetProperty(const wxString& property, int noArgs, wxVariant args[]) const
+{
+       wxVariant retVariant;
+       if (!Invoke(property, DISPATCH_PROPERTYGET, retVariant, noArgs, args))
+       {
+               retVariant.MakeNull();
+       }
+       return retVariant;
+}
+
+wxVariant wxAutomationObject::GetProperty(const wxString& property,
+               const wxVariant& arg1, const wxVariant& arg2,
+               const wxVariant& arg3, const wxVariant& arg4,
+               const wxVariant& arg5, const wxVariant& arg6)
+{
+       const wxVariant** args = new const wxVariant*[6];
+       int i = 0;
+       if (!arg1.IsNull())
+       {
+               args[i] = & arg1;
+               i ++;
+       }
+       if (!arg2.IsNull())
+       {
+               args[i] = & arg2;
+               i ++;
+       }
+       if (!arg3.IsNull())
+       {
+               args[i] = & arg3;
+               i ++;
+       }
+       if (!arg4.IsNull())
+       {
+               args[i] = & arg4;
+               i ++;
+       }
+       if (!arg5.IsNull())
+       {
+               args[i] = & arg5;
+               i ++;
+       }
+       if (!arg6.IsNull())
+       {
+               args[i] = & arg6;
+               i ++;
+       }
+       wxVariant retVariant;
+       if (!Invoke(property, DISPATCH_PROPERTYGET, retVariant, i, NULL, args))
+       {
+               retVariant.MakeNull();
+       }
+       delete[] args;
+       return retVariant;
+}
+
+bool wxAutomationObject::PutProperty(const wxString& property, int noArgs, wxVariant args[])
+{
+       wxVariant retVariant;
+       if (!Invoke(property, DISPATCH_PROPERTYPUT, retVariant, noArgs, args))
+       {
+               return FALSE;
+       }
+       return TRUE;
+}
+
+bool wxAutomationObject::PutProperty(const wxString& property,
+               const wxVariant& arg1, const wxVariant& arg2,
+               const wxVariant& arg3, const wxVariant& arg4,
+               const wxVariant& arg5, const wxVariant& arg6)
+{
+       const wxVariant** args = new const wxVariant*[6];
+       int i = 0;
+       if (!arg1.IsNull())
+       {
+               args[i] = & arg1;
+               i ++;
+       }
+       if (!arg2.IsNull())
+       {
+               args[i] = & arg2;
+               i ++;
+       }
+       if (!arg3.IsNull())
+       {
+               args[i] = & arg3;
+               i ++;
+       }
+       if (!arg4.IsNull())
+       {
+               args[i] = & arg4;
+               i ++;
+       }
+       if (!arg5.IsNull())
+       {
+               args[i] = & arg5;
+               i ++;
+       }
+       if (!arg6.IsNull())
+       {
+               args[i] = & arg6;
+               i ++;
+       }
+       wxVariant retVariant;
+       bool ret = Invoke(property, DISPATCH_PROPERTYPUT, retVariant, i, NULL, args);
+       delete[] args;
+       return ret;
+}
+
+
+// Uses DISPATCH_PROPERTYGET
+// and returns a dispatch pointer. The calling code should call Release
+// on the pointer, though this could be implicit by constructing an wxAutomationObject
+// with it and letting the destructor call Release.
+WXIDISPATCH* wxAutomationObject::GetDispatchProperty(const wxString& property, int noArgs, wxVariant args[]) const
+{
+       wxVariant retVariant;
+       if (Invoke(property, DISPATCH_PROPERTYGET, retVariant, noArgs, args))
+       {
+               if (retVariant.GetType() == "void*")
+               {
+                       return (WXIDISPATCH*) retVariant.GetVoidPtr();
+               }
+               else
+               {
+                       return (WXIDISPATCH*) NULL;
+               }
+       }
+       else
+               return (WXIDISPATCH*) NULL;
+}
+
+// A way of initialising another wxAutomationObject with a dispatch object
+bool wxAutomationObject::GetObject(wxAutomationObject& obj, const wxString& property, int noArgs, wxVariant args[]) const
+{
+       WXIDISPATCH* dispatch = GetDispatchProperty(property, noArgs, args);
+       if (dispatch)
+       {
+               obj.SetDispatchPtr(dispatch);
+               return TRUE;
+       }
+       else
+               return FALSE;
+}
+
+// Get a dispatch pointer from the current object associated
+// with a class id
+bool wxAutomationObject::GetInstance(const wxString& classId) const
+{
+       if (m_dispatchPtr)
+               return FALSE;
+
+       CLSID clsId;
+       IUnknown * pUnk = NULL;
+
+       BasicString unicodeName((const char*) classId);
+       
+       if (FAILED(CLSIDFromProgID((BSTR) unicodeName, &clsId))) 
+       {
+               wxLogWarning("Cannot obtain CLSID from ProgID");
+               return FALSE;
+       }
+
+       if (FAILED(GetActiveObject(clsId, NULL, &pUnk)))
+       {
+               wxLogWarning("Cannot find an active object");
+               return FALSE;
+       }
+       
+       if (pUnk->QueryInterface(IID_IDispatch, (LPVOID*) &m_dispatchPtr) != S_OK)
+       {
+               wxLogWarning("Cannot find IDispatch interface");
+               return FALSE;
+       }
+
+       return TRUE;
+}
+
+// Get a dispatch pointer from a new object associated
+// with the given class id
+bool wxAutomationObject::CreateInstance(const wxString& classId) const
+{
+       if (m_dispatchPtr)
+               return FALSE;
+
+       CLSID clsId;
+       IUnknown * pUnk = NULL;
+
+       BasicString unicodeName((const char*) classId);
+       
+       if (FAILED(CLSIDFromProgID((BSTR) unicodeName, &clsId))) 
+       {
+               wxLogWarning("Cannot obtain CLSID from ProgID");
+               return FALSE;
+       }
+
+       // start a new copy of Excel, grab the IDispatch interface
+       if (FAILED(CoCreateInstance(clsId, NULL, CLSCTX_LOCAL_SERVER, IID_IDispatch, (void**)&m_dispatchPtr))) 
+       {
+               wxLogWarning("Cannot start an instance of this class.");
+               return FALSE;
+       }
+       
+       return TRUE;
+}
+
+
+bool wxAutomationObject::ConvertVariantToOle(const wxVariant& variant, VARIANTARG& oleVariant)
+{
+       ClearVariant(&oleVariant);
+       if (variant.IsNull())
+       {
+               oleVariant.vt = VT_NULL;
+               return TRUE;
+       }
+
+    wxString type(variant.GetType());
+
+    if (type == "long")
+    {
+        oleVariant.vt = VT_I4;
+        oleVariant.lVal = variant.GetLong() ;
+    }
+    else if (type == "double")
+    {
+        oleVariant.vt = VT_R8;
+        oleVariant.dblVal = variant.GetDouble();
+    }
+    else if (type == "bool")
+    {
+        oleVariant.vt = VT_BOOL;
+        oleVariant.boolVal = variant.GetBool();
+    }
+    else if (type == "string")
+    {
+        wxString str( variant.GetString() );
+        oleVariant.vt = VT_BSTR;
+        oleVariant.bstrVal = ConvertStringToOle(str);
+    }
+    else if (type == "date")
+    {
+        wxDate date( variant.GetDate() );
+        oleVariant.vt = VT_DATE;
+
+               if (!OleDateFromTm(date.GetYear(), date.GetMonth(), date.GetDay(),
+                               0, 0, 0, oleVariant.date))
+                       return FALSE;
+    }
+    else if (type == "time")
+    {
+        wxTime time( variant.GetTime() );
+        oleVariant.vt = VT_DATE;
+
+               if (!OleDateFromTm(time.GetYear(), time.GetMonth(), time.GetDay(),
+                       time.GetHour(), time.GetMinute(), time.GetSecond(), oleVariant.date))
+                       return FALSE;
+    }
+    else if (type == "void*")
+    {
+        oleVariant.vt = VT_DISPATCH;
+        oleVariant.pdispVal = (IDispatch*) variant.GetVoidPtr();
+    }
+    else if (type == "list" || type == "stringlist")
+    {
+        oleVariant.vt = VT_VARIANT | VT_ARRAY;
+
+           SAFEARRAY *psa;
+           SAFEARRAYBOUND saBound;
+           VARIANTARG *pvargBase;
+           VARIANTARG *pvarg;
+           int i, j;
+
+        int iCount = variant.GetCount();
+       
+           saBound.lLbound = 0;
+           saBound.cElements = iCount;
+       
+           psa = SafeArrayCreate(VT_VARIANT, 1, &saBound);
+           if (psa == NULL)
+                   return FALSE;
+       
+           SafeArrayAccessData(psa, (void**)&pvargBase);
+       
+           pvarg = pvargBase;
+           for (i = 0; i < iCount; i++)
+           {
+                   // copy each string in the list of strings
+            wxVariant eachVariant(variant[i]);
+            if (!ConvertVariantToOle(eachVariant, * pvarg))
+            {
+                           // memory failure:  back out and free strings alloc'ed up to
+                           // now, and then the array itself.
+                           pvarg = pvargBase;
+                           for (j = 0; j < i; j++)
+                           {
+                                   SysFreeString(pvarg->bstrVal);
+                                   pvarg++;
+                           }
+                           SafeArrayDestroy(psa);
+                           return FALSE;
+                   }
+                   pvarg++;
+           }
+       
+           SafeArrayUnaccessData(psa);
+
+        oleVariant.parray = psa;
+    }
+    else
+    {
+        oleVariant.vt = VT_NULL;
+        return FALSE;
+    }
+    return TRUE;
+}
+
+#ifndef VT_TYPEMASK
+#define VT_TYPEMASK 0xfff
+#endif
+
+bool wxAutomationObject::ConvertOleToVariant(const VARIANTARG& oleVariant, wxVariant& variant)
+{
+       switch (oleVariant.vt & VT_TYPEMASK)
+       {
+       case VT_BSTR:
+               {
+                       wxString str(ConvertStringFromOle(oleVariant.bstrVal));
+                       variant = str;
+                       break;
+               }
+       case VT_DATE:
+               {
+                       struct tm tmTemp;
+                       if (!TmFromOleDate(oleVariant.date, tmTemp))
+                               return FALSE;
+
+                       wxDate date(tmTemp.tm_yday, tmTemp.tm_mon, tmTemp.tm_year);
+                       wxTime time(date, tmTemp.tm_hour, tmTemp.tm_min, tmTemp.tm_sec);
+
+                       variant = time;
+                       break;
+               }
+       case VT_I4:
+               {
+                       variant = (long) oleVariant.lVal;
+                       break;
+               }
+       case VT_I2:
+               {
+                       variant = (long) oleVariant.iVal;
+                       break;
+               }
+
+       case VT_BOOL:
+               {
+                       variant = (bool) (oleVariant.boolVal != 0);
+                       break;
+               }
+       case VT_R8:
+               {
+                       variant = oleVariant.dblVal;
+                       break;
+               }
+       case VT_ARRAY:
+               {
+                       variant.ClearList();
+
+                       int cDims, cElements, i;
+                       VARIANTARG* pvdata;
+
+                       // Iterate the dimensions: number of elements is x*y*z
+                       for (cDims = 0, cElements = 1;
+                               cDims < oleVariant.parray->cDims; cDims ++)
+                                       cElements *= oleVariant.parray->rgsabound[cDims].cElements;
+
+                       // Get a pointer to the data
+                       HRESULT hr = SafeArrayAccessData(oleVariant.parray, (void HUGEP* FAR*) & pvdata);
+                       if (hr != NOERROR)
+                               return FALSE;
+                       // Iterate the data.
+                       for (i = 0; i < cElements; i++)
+                       {
+                               VARIANTARG& oleElement = pvdata[i];
+                               wxVariant vElement;
+                               if (!ConvertOleToVariant(oleElement, vElement))
+                                       return FALSE;
+                               
+                               variant.Append(vElement);
+                       }
+                       SafeArrayUnaccessData(oleVariant.parray);
+                       break;
+               }
+       case VT_DISPATCH:
+               {
+                       variant = (void*) oleVariant.pdispVal;
+                       break;
+               }
+       case VT_NULL:
+               {
+                       variant.MakeNull();
+                       break;
+               }
+       default:
+               {
+                       wxLogError("wxAutomationObject::ConvertOleToVariant: Unknown variant value type");
+                       return FALSE;
+               }
+       }
+    return TRUE;
+}
+
+static BSTR ConvertStringToOle(const wxString& str)
+{
+/*
+       unsigned int len = strlen((const char*) str);
+       unsigned short* s = new unsigned short[len*2+2];
+       unsigned int i;
+       memset(s, 0, len*2+2);
+       for (i=0; i < len; i++)
+               s[i*2] = str[i];
+*/
+       BasicString bstr((const char*) str);
+       return bstr.Get();
+}
+
+static wxString ConvertStringFromOle(BSTR bStr)
+{
+       int len = SysStringLen(bStr) + 1;
+       char    *buf = new char[len];
+       int i = wcstombs( buf, bStr, len);
+
+       wxString str(buf);
+       delete[] buf;
+       return str;
+}
+
+// ----------------------------------------------------------------------------
+// BasicString
+// ----------------------------------------------------------------------------
+
+// ctor takes an ANSI string and transforms it to Unicode
+BasicString::BasicString(const char *sz)
+{
+  // get the size of required buffer
+  UINT lenAnsi = strlen(sz);
+  UINT lenWide = mbstowcs(NULL, sz, lenAnsi);
+
+  if ( lenWide > 0 ) {
+    m_wzBuf = new OLECHAR[lenWide + 1];
+    mbstowcs(m_wzBuf, sz, lenAnsi);
+    m_wzBuf[lenWide] = L'\0';
+  }
+  else {
+    m_wzBuf = NULL;
+  }
+}
+
+// dtor frees memory
+BasicString::~BasicString()
+{
+  delete [] m_wzBuf;
+}
+
+/////////////////////////////////////////////////////////////////////////////
+// COleDateTime class HELPERS - implementation
+
+BOOL OleDateFromTm(WORD wYear, WORD wMonth, WORD wDay,
+       WORD wHour, WORD wMinute, WORD wSecond, DATE& dtDest)
+{
+       // Validate year and month (ignore day of week and milliseconds)
+       if (wYear > 9999 || wMonth < 1 || wMonth > 12)
+               return FALSE;
+
+       //  Check for leap year and set the number of days in the month
+       BOOL bLeapYear = ((wYear & 3) == 0) &&
+               ((wYear % 100) != 0 || (wYear % 400) == 0);
+
+       int nDaysInMonth =
+               rgMonthDays[wMonth] - rgMonthDays[wMonth-1] +
+               ((bLeapYear && wDay == 29 && wMonth == 2) ? 1 : 0);
+
+       // Finish validating the date
+       if (wDay < 1 || wDay > nDaysInMonth ||
+               wHour > 23 || wMinute > 59 ||
+               wSecond > 59)
+       {
+               return FALSE;
+       }
+
+       // Cache the date in days and time in fractional days
+       long nDate;
+       double dblTime;
+
+       //It is a valid date; make Jan 1, 1AD be 1
+       nDate = wYear*365L + wYear/4 - wYear/100 + wYear/400 +
+               rgMonthDays[wMonth-1] + wDay;
+
+       //  If leap year and it's before March, subtract 1:
+       if (wMonth <= 2 && bLeapYear)
+               --nDate;
+
+       //  Offset so that 12/30/1899 is 0
+       nDate -= 693959L;
+
+       dblTime = (((long)wHour * 3600L) +  // hrs in seconds
+               ((long)wMinute * 60L) +  // mins in seconds
+               ((long)wSecond)) / 86400.;
+
+       dtDest = (double) nDate + ((nDate >= 0) ? dblTime : -dblTime);
+
+       return TRUE;
+}
+
+BOOL TmFromOleDate(DATE dtSrc, struct tm& tmDest)
+{
+       // The legal range does not actually span year 0 to 9999.
+       if (dtSrc > MAX_DATE || dtSrc < MIN_DATE) // about year 100 to about 9999
+               return FALSE;
+
+       long nDays;             // Number of days since Dec. 30, 1899
+       long nDaysAbsolute;     // Number of days since 1/1/0
+       long nSecsInDay;        // Time in seconds since midnight
+       long nMinutesInDay;     // Minutes in day
+
+       long n400Years;         // Number of 400 year increments since 1/1/0
+       long n400Century;       // Century within 400 year block (0,1,2 or 3)
+       long n4Years;           // Number of 4 year increments since 1/1/0
+       long n4Day;             // Day within 4 year block
+                                                       //  (0 is 1/1/yr1, 1460 is 12/31/yr4)
+       long n4Yr;              // Year within 4 year block (0,1,2 or 3)
+       BOOL bLeap4 = TRUE;     // TRUE if 4 year block includes leap year
+
+       double dblDate = dtSrc; // tempory serial date
+
+       // If a valid date, then this conversion should not overflow
+       nDays = (long)dblDate;
+
+       // Round to the second
+       dblDate += ((dtSrc > 0.0) ? HALF_SECOND : -HALF_SECOND);
+
+       nDaysAbsolute = (long)dblDate + 693959L; // Add days from 1/1/0 to 12/30/1899
+
+       dblDate = fabs(dblDate);
+       nSecsInDay = (long)((dblDate - floor(dblDate)) * 86400.);
+
+       // Calculate the day of week (sun=1, mon=2...)
+       //   -1 because 1/1/0 is Sat.  +1 because we want 1-based
+       tmDest.tm_wday = (int)((nDaysAbsolute - 1) % 7L) + 1;
+
+       // Leap years every 4 yrs except centuries not multiples of 400.
+       n400Years = (long)(nDaysAbsolute / 146097L);
+
+       // Set nDaysAbsolute to day within 400-year block
+       nDaysAbsolute %= 146097L;
+
+       // -1 because first century has extra day
+       n400Century = (long)((nDaysAbsolute - 1) / 36524L);
+
+       // Non-leap century
+       if (n400Century != 0)
+       {
+               // Set nDaysAbsolute to day within century
+               nDaysAbsolute = (nDaysAbsolute - 1) % 36524L;
+
+               // +1 because 1st 4 year increment has 1460 days
+               n4Years = (long)((nDaysAbsolute + 1) / 1461L);
+
+               if (n4Years != 0)
+                       n4Day = (long)((nDaysAbsolute + 1) % 1461L);
+               else
+               {
+                       bLeap4 = FALSE;
+                       n4Day = (long)nDaysAbsolute;
+               }
+       }
+       else
+       {
+               // Leap century - not special case!
+               n4Years = (long)(nDaysAbsolute / 1461L);
+               n4Day = (long)(nDaysAbsolute % 1461L);
+       }
+
+       if (bLeap4)
+       {
+               // -1 because first year has 366 days
+               n4Yr = (n4Day - 1) / 365;
+
+               if (n4Yr != 0)
+                       n4Day = (n4Day - 1) % 365;
+       }
+       else
+       {
+               n4Yr = n4Day / 365;
+               n4Day %= 365;
+       }
+
+       // n4Day is now 0-based day of year. Save 1-based day of year, year number
+       tmDest.tm_yday = (int)n4Day + 1;
+       tmDest.tm_year = n400Years * 400 + n400Century * 100 + n4Years * 4 + n4Yr;
+
+       // Handle leap year: before, on, and after Feb. 29.
+       if (n4Yr == 0 && bLeap4)
+       {
+               // Leap Year
+               if (n4Day == 59)
+               {
+                       /* Feb. 29 */
+                       tmDest.tm_mon = 2;
+                       tmDest.tm_mday = 29;
+                       goto DoTime;
+               }
+
+               // Pretend it's not a leap year for month/day comp.
+               if (n4Day >= 60)
+                       --n4Day;
+       }
+
+       // Make n4DaY a 1-based day of non-leap year and compute
+       //  month/day for everything but Feb. 29.
+       ++n4Day;
+
+       // Month number always >= n/32, so save some loop time */
+       for (tmDest.tm_mon = (n4Day >> 5) + 1;
+               n4Day > rgMonthDays[tmDest.tm_mon]; tmDest.tm_mon++);
+
+       tmDest.tm_mday = (int)(n4Day - rgMonthDays[tmDest.tm_mon-1]);
+
+DoTime:
+       if (nSecsInDay == 0)
+               tmDest.tm_hour = tmDest.tm_min = tmDest.tm_sec = 0;
+       else
+       {
+               tmDest.tm_sec = (int)nSecsInDay % 60L;
+               nMinutesInDay = nSecsInDay / 60L;
+               tmDest.tm_min = (int)nMinutesInDay % 60;
+               tmDest.tm_hour = (int)nMinutesInDay / 60;
+       }
+
+       return TRUE;
+}
+
+void TmConvertToStandardFormat(struct tm& tmSrc)
+{
+       // Convert afx internal tm to format expected by runtimes (_tcsftime, etc)
+       tmSrc.tm_year -= 1900;  // year is based on 1900
+       tmSrc.tm_mon -= 1;      // month of year is 0-based
+       tmSrc.tm_wday -= 1;     // day of week is 0-based
+       tmSrc.tm_yday -= 1;     // day of year is 0-based
+}
+
+double DoubleFromDate(DATE dt)
+{
+       // No problem if positive
+       if (dt >= 0)
+               return dt;
+
+       // If negative, must convert since negative dates not continuous
+       // (examples: -1.25 to -.75, -1.50 to -.50, -1.75 to -.25)
+       double temp = ceil(dt);
+       return temp - (dt - temp);
+}
+
+DATE DateFromDouble(double dbl)
+{
+       // No problem if positive
+       if (dbl >= 0)
+               return dbl;
+
+       // If negative, must convert since negative dates not continuous
+       // (examples: -.75 to -1.25, -.50 to -1.50, -.25 to -1.75)
+       double temp = floor(dbl); // dbl is now whole part
+       return temp + (temp - dbl);
+}
+
+/*
+ *  ClearVariant
+ *
+ *  Zeros a variant structure without regard to current contents
+ */
+static void ClearVariant(VARIANTARG *pvarg)
+{
+       pvarg->vt = VT_EMPTY;
+       pvarg->wReserved1 = 0;
+       pvarg->wReserved2 = 0;
+       pvarg->wReserved3 = 0;
+       pvarg->lVal = 0;
+}
+
+/*
+ *  ReleaseVariant
+ *
+ *  Clears a particular variant structure and releases any external objects
+ *  or memory contained in the variant.  Supports the data types listed above.
+ */
+static void ReleaseVariant(VARIANTARG *pvarg)
+{
+       VARTYPE vt;
+       VARIANTARG _huge *pvargArray;
+       long lLBound, lUBound, l;
+       
+       vt = pvarg->vt & 0xfff;         // mask off flags
+       
+       // check if an array.  If so, free its contents, then the array itself.
+       if (V_ISARRAY(pvarg)) 
+       {
+               // variant arrays are all this routine currently knows about.  Since a
+               // variant can contain anything (even other arrays), call ourselves
+               // recursively.
+               if (vt == VT_VARIANT) 
+               {
+                       SafeArrayGetLBound(pvarg->parray, 1, &lLBound);
+                       SafeArrayGetUBound(pvarg->parray, 1, &lUBound);
+                       
+                       if (lUBound > lLBound) 
+                       {
+                               lUBound -= lLBound;
+                               
+                               SafeArrayAccessData(pvarg->parray, (void**)&pvargArray);
+                               
+                               for (l = 0; l < lUBound; l++) 
+                               {
+                                       ReleaseVariant(pvargArray);
+                                       pvargArray++;
+                               }
+                               
+                               SafeArrayUnaccessData(pvarg->parray);
+                       }
+               }
+               else 
+               {
+                       wxLogWarning("ReleaseVariant: Array contains non-variant type");
+               }
+               
+               // Free the array itself.
+               SafeArrayDestroy(pvarg->parray);
+       }
+       else 
+       {
+               switch (vt) 
+               {
+                       case VT_DISPATCH:
+                               if (pvarg->pdispVal)
+                                       pvarg->pdispVal->Release();
+                               break;
+                               
+                       case VT_BSTR:
+                               SysFreeString(pvarg->bstrVal);
+                               break;
+                               
+                       case VT_I2:
+                       case VT_BOOL:
+                       case VT_R8:
+                       case VT_ERROR:          // to avoid erroring on an error return from Excel
+                               // no work for these types
+                               break;
+                               
+                       default:
+                               wxLogWarning("ReleaseVariant: Unknown type");
+                               break;
+               }
+       }
+       
+       ClearVariant(pvarg);
+}
+
+#if 0
+
+void ShowException(LPOLESTR szMember, HRESULT hr, EXCEPINFO *pexcep, unsigned int uiArgErr)
+{
+       TCHAR szBuf[512];
+       
+       switch (GetScode(hr)) 
+       {
+               case DISP_E_UNKNOWNNAME:
+                       wsprintf(szBuf, L"%s: Unknown name or named argument.", szMember);
+                       break;
+       
+               case DISP_E_BADPARAMCOUNT:
+                       wsprintf(szBuf, L"%s: Incorrect number of arguments.", szMember);
+                       break;
+                       
+               case DISP_E_EXCEPTION:
+                       wsprintf(szBuf, L"%s: Error %d: ", szMember, pexcep->wCode);
+                       if (pexcep->bstrDescription != NULL)
+                               lstrcat(szBuf, pexcep->bstrDescription);
+                       else
+                               lstrcat(szBuf, L"<<No Description>>");
+                       break;
+                       
+               case DISP_E_MEMBERNOTFOUND:
+                       wsprintf(szBuf, L"%s: method or property not found.", szMember);
+                       break;
+               
+               case DISP_E_OVERFLOW:
+                       wsprintf(szBuf, L"%s: Overflow while coercing argument values.", szMember);
+                       break;
+               
+               case DISP_E_NONAMEDARGS:
+                       wsprintf(szBuf, L"%s: Object implementation does not support named arguments.",
+                                               szMember);
+                   break;
+                   
+               case DISP_E_UNKNOWNLCID:
+                       wsprintf(szBuf, L"%s: The locale ID is unknown.", szMember);
+                       break;
+               
+               case DISP_E_PARAMNOTOPTIONAL:
+                       wsprintf(szBuf, L"%s: Missing a required parameter.", szMember);
+                       break;
+               
+               case DISP_E_PARAMNOTFOUND:
+                       wsprintf(szBuf, L"%s: Argument not found, argument %d.", szMember, uiArgErr);
+                       break;
+                       
+               case DISP_E_TYPEMISMATCH:
+                       wsprintf(szBuf, L"%s: Type mismatch, argument %d.", szMember, uiArgErr);
+                       break;
+
+               default:
+                       wsprintf(szBuf, L"%s: Unknown error occured.", szMember);
+                       break;
+       }
+       
+       wxLogWarning(szBuf);
+}
+
+#endif
+