wxwidgets应用手记(6) 之报表

wxwidgets开发系统，缺少很好的报表设计工具，可以借助Word来做报表。

Office自动化参考http://msdn.microsoft.com/en-us/library/78whx7s6(v=vs.80).aspx

一个很好的对COM的操作类http://disphelper.sourceforge.net/

仔细看它的readme.htm文件

贴上一个操作类

void ReportDll_Open(const wchar_t* fileName,bool visible)//打开报表模板

void ReportDll_Close()//关闭

void ReportDll_Write(const wchar_t* data[],int len)//插一行，填一行数据

void ReportDll_SearchReplace(const wchar_t* Find, const wchar_t* Replacement)//查找占位符，用值替换占位符

#include "disphelper.h"
#include <string>
#include "ReportDll.h"
using namespace std;


CDispPtr wdApp, wdDoc;

void ReportDll_Open(const wchar_t* fileName,bool visible)
{
    //CDhInitialize init;    /* Initialize DispHelper for this thread. */
    /* Turn on DispHelper exceptions */
    dhToggleExceptions(TRUE);

    try
    {
        /* Create an instance of 'Word.Application' on the local machine */
        dhCheck( dhCreateObject(L"Word.Application", NULL, &wdApp) );

        /* wdApp.Visible = True */
        dhPutValue(wdApp, L".Visible = %b", visible);

        dhCallMethod(wdApp, L".Documents.Open(%S)", fileName);

        /* Set wdDoc = wdApp.Documents.Add */
        /* '%o' means we wish to receive an IDispatch object in wdDoc */
        dhCheck( dhGetValue(L"%o", &wdDoc, wdApp, L".ActiveDocument") );
    }
    catch (string errstr)
    {
        MessageBox(NULL,std::wstring(errstr.begin(), errstr.end()).c_str(),L"ReportDll", MB_OK);
    }
}

void ReportDll_Close()
{
    try
    {
        /* wdApp.ActiveDocument.Saved = True */
        /* This prevents the user being prompted when word is closed. */
        //dhPutValue(wdApp, L".ActiveDocument.Saved = %b", TRUE);

        dhCallMethod(wdDoc, L".Save");
        dhCallMethod(wdDoc, L".Close");

        /* wdApp.Quit() */
        dhCallMethod(wdApp, L".Quit");

        wdDoc = NULL;
        wdApp = NULL;
    }
    catch (string errstr)
    {
        MessageBox(NULL,std::wstring(errstr.begin(), errstr.end()).c_str(),L"ReportDll", MB_OK);
    }

    /* Turn off exceptions display for cleanup */
    dhToggleExceptions(FALSE);
}

void ReportDll_Write(const wchar_t* data[],int len)
{
    CDispPtr wdTab,wdRow;

    try
    {
        dhCheck( dhGetValue(L"%o", &wdTab, wdDoc, L".Tables(%d)",1));
        dhCheck( dhGetValue(L"%o", &wdRow, wdTab, L".Rows(%d)",2));
        //在上面插入一行
        dhCallMethod(wdTab, L".Rows.Add(%o)",wdRow);

        for (int i = 0; i <len;i++)
        {
            dhPutValue(wdTab, L".Cell(%d,%d).Range.Text=%S", 2,i+1,data[i]);
        }
    }
    catch (string errstr)
    {
        MessageBox(NULL,std::wstring(errstr.begin(), errstr.end()).c_str(),L"ReportDll", MB_OK);
    }
}


void ReportDll_SearchReplace(const wchar_t* Find, const wchar_t* Replacement)
{
    try
    {
        dhCallMethod(wdApp, L".Selection.Find.ClearFormatting");
        dhCallMethod(wdApp, L".Selection.Find.Replacement.ClearFormatting");

        dhPutValue(wdApp, L".Selection.Find.Text = %S",Find);
        dhPutValue(wdApp, L".Selection.Find.Replacement.Text = %S",Replacement);

        dhPutValue(wdApp, L".Selection.Find.MatchWholeWord = %b",TRUE);
        dhPutValue(wdApp, L".Selection.Find.Forward =  %b",TRUE);
        dhPutValue(wdApp, L".Selection.Find.Wrap = %d",1);
        dhPutValue(wdApp, L".Selection.Find.Format = %b",FALSE);

        dhCallMethod(wdApp, L".Selection.Find.Execute(%m,%m,%m,%m,%m,%m,%m,%m,%m,%m,%d,%m,%m,%m,%m)",2);
    }
    catch (string errstr)
    {
        MessageBox(NULL,std::wstring(errstr.begin(), errstr.end()).c_str(),L"ReportDll", MB_OK);
    }
}

调用

void ReportMainFrame::m_button3OnButtonClick( wxCommandEvent& event )
{
    wxFileName file(ty::Common::GetModuleFileName());
    wxString  file1 = file.GetPath() + _T("\\Orders.doc");
    wxString  file2 = file.GetPath() + _T("\\Orders_Test.doc");
    wxCopyFile(file1,file2,true);

    wxString str;
    str<<_T("打印时间：");
    str<< ty::Common::DateTimeToString(wxDateTime::Now());

    ReportDll_Open(file2.c_str(),true);

    ReportDll_SearchReplace(L"打印人：",L"打印人：李明");
    ReportDll_SearchReplace(L"打印时间：",str.c_str());

    for (int i = 0;i< 10;i++)
    {
        const wchar_t* data[] = {
            m_grid1->GetCellValue(i,0).c_str(),
            m_grid1->GetCellValue(i,1).c_str(),
            m_grid1->GetCellValue(i,2).c_str(),
            m_grid1->GetCellValue(i,3).c_str(),
            m_grid1->GetCellValue(i,4).c_str(),
            m_grid1->GetCellValue(i,5).c_str(),
            m_grid1->GetCellValue(i,6).c_str(),
            m_grid1->GetCellValue(i,7).c_str(),
            m_grid1->GetCellValue(i,8).c_str(),
            m_grid1->GetCellValue(i,9).c_str(),
            m_grid1->GetCellValue(i,10).c_str(),
            m_grid1->GetCellValue(i,11).c_str(),
            m_grid1->GetCellValue(i,12).c_str(),
            m_grid1->GetCellValue(i,13).c_str()
        } ;

        ReportDll_Write(data,14);
    }

    ReportDll_Close();
}

报表模板如

 

根据生成得到的报表