// ----------------------------------------------------------------------------
// headers
// ----------------------------------------------------------------------------
-#ifdef __GNUG__
- #pragma implementation "oleauto.cpp"
- #pragma interface "oleauto.cpp"
-#endif
// For compilers that support precompilation, includes "wx/wx.h".
#include "wx/wxprec.h"
#include "wx/wx.h"
#endif
-#include <wx/msw/ole/automtn.h>
+#include "wx/msw/ole/automtn.h"
#ifndef __WXMSW__
#error "Sorry, this sample works under Windows only."
OleAuto_Test,
// controls start here (the numbers are, of course, arbitrary)
- OleAuto_Text = 1000,
+ OleAuto_Text = 1000
};
// ----------------------------------------------------------------------------
// `Main program' equivalent: the program execution "starts" here
bool MyApp::OnInit()
{
+ if ( !wxApp::OnInit() )
+ return false;
+
// Create the main application window
- MyFrame *frame = new MyFrame(_T("OleAuto wxWidgets App"),
+ MyFrame *frame = new MyFrame(wxT("OleAuto wxWidgets App"),
wxPoint(50, 50), wxSize(450, 340));
// Show it and tell the application that it's our main window
// create a menu bar
wxMenu *menuFile = new wxMenu;
- menuFile->Append(OleAuto_Test, _T("&Test Excel Automation..."));
- menuFile->Append(OleAuto_About, _T("&About..."));
+ menuFile->Append(OleAuto_Test, wxT("&Test Excel Automation..."));
+ menuFile->Append(OleAuto_About, wxT("&About..."));
menuFile->AppendSeparator();
- menuFile->Append(OleAuto_Quit, _T("E&xit"));
+ menuFile->Append(OleAuto_Quit, wxT("E&xit"));
// now append the freshly created menu to the menu bar...
wxMenuBar *menuBar = new wxMenuBar;
- menuBar->Append(menuFile, _T("&File"));
+ menuBar->Append(menuFile, wxT("&File"));
// ... and attach this menu bar to the frame
SetMenuBar(menuBar);
#if wxUSE_STATUSBAR
// create a status bar just for fun (by default with 1 pane only)
CreateStatusBar(2);
- SetStatusText(_T("Welcome to wxWidgets!"));
+ SetStatusText(wxT("Welcome to wxWidgets!"));
#endif // wxUSE_STATUSBAR
}
void MyFrame::OnAbout(wxCommandEvent& WXUNUSED(event))
{
- wxMessageBox(_T("This is an OLE Automation sample"),
- _T("About OleAuto"), wxOK | wxICON_INFORMATION, this);
+ wxMessageBox(wxT("This is an OLE Automation sample"),
+ wxT("About OleAuto"), wxOK | wxICON_INFORMATION, this);
}
/* Tests OLE automation by making the active Excel cell bold,
*/
void MyFrame::OnTest(wxCommandEvent& WXUNUSED(event))
{
- wxMessageBox(_T("Please ensure Excel is running, then press OK.\nThe active cell should then say 'wxWidgets automation test!' in bold."));
+ wxMessageBox(wxT("Please ensure Excel is running, then press OK.\nThe active cell should then say 'wxWidgets automation test!' in bold."));
wxAutomationObject excelObject, rangeObject;
- if (!excelObject.GetInstance(_T("Excel.Application")))
+ if (!excelObject.GetInstance(wxT("Excel.Application")))
{
- if (!excelObject.CreateInstance(_T("Excel.Application")))
+ // Start Excel if it is not running
+ if (!excelObject.CreateInstance(wxT("Excel.Application")))
{
- wxMessageBox(_T("Could not create Excel object."));
+ wxMessageBox(wxT("Could not create Excel object."));
return;
}
}
- if (!excelObject.PutProperty(_T("ActiveCell.Value"), _T("wxWidgets automation test!")))
+
+ // Ensure that Excel is visible
+ if (!excelObject.PutProperty(wxT("Visible"), true))
+ {
+ wxMessageBox(wxT("Could not make Excel object visible"));
+ }
+ const wxVariant workbooksCountVariant = excelObject.GetProperty(wxT("Workbooks.Count"));
+ if (workbooksCountVariant.IsNull())
{
- wxMessageBox(_T("Could not set active cell value."));
+ wxMessageBox(wxT("Could not get workbooks count"));
return;
}
- if (!excelObject.PutProperty(_T("ActiveCell.Font.Bold"), wxVariant(true)) )
+ const long workbooksCount = workbooksCountVariant;
+ if (workbooksCount == 0)
{
- wxMessageBox(_T("Could not put Bold property to active cell."));
+ const wxVariant workbook = excelObject.CallMethod(wxT("Workbooks.Add"));
+ if (workbook.IsNull())
+ {
+ wxMessageBox(wxT("Could not create new Workbook"));
+ return;
+ }
+ }
+
+ if (!excelObject.PutProperty(wxT("ActiveCell.Value"), wxT("wxWidgets automation test!")))
+ {
+ wxMessageBox(wxT("Could not set active cell value."));
+ return;
+ }
+ if (!excelObject.PutProperty(wxT("ActiveCell.Font.Bold"), wxVariant(true)) )
+ {
+ wxMessageBox(wxT("Could not put Bold property to active cell."));
return;
}
}
-