VC++操作Excel在VS2008编码实例(一)

这篇文章是接上一篇 VC++操作Excel在VS2008配置过程后的编码实例，详细给出了操作EXCEL的操作过程，大家可以举一反三，实现自己的功能。

gsExcel::CApplication m_ExlApp;
gsExcel::CRange m_ExlRange;
gsExcel::CWorkbook m_ExlWorkBook;
gsExcel::CWorkbooks m_ExlWorkBooks;
gsExcel::CWorksheet m_ExlWorkSheet;
gsExcel::CWorksheets m_ExlWorkSheets;
gsExcel::CRange m_ExlColor;
gsExcel::CFont0 m_ExlFont;


CString strTheAppPath;
CString strTheAppName;


TCHAR szAppPath[MAX_PATH];
GetModuleFileName(NULL, szAppPath, MAX_PATH);
strTheAppPath = CString(szAppPath);


strTheAppName = AfxGetApp()->m_pszAppName;
strTheAppName += _T(".exe");


int iLengthOne = strTheAppPath.GetLength();
int iLengthTwo = strTheAppName.GetLength();


strTheAppPath.Delete(iLengthOne - iLengthTwo, iLengthTwo);


CString strTemplatePath;


strTemplatePath += _T("TemplateOne.xlsx");
strTemplatePath = strTheAppPath + strTemplatePath;




COleVariant covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR);


// 启动EXCEL应用程序
if(!m_ExlApp.CreateDispatch(_T("Excel.Application")))
{
MessageBox(_T("创建Excel服务失败...."),_T("信息提示"), MB_OK);
return;
}


// 设置为可见
m_ExlApp.put_Visible(FALSE);


// 获取工作簿集合
m_ExlWorkBooks = m_ExlApp.get_Workbooks();


// 在工作簿集合中添加一个工作簿
m_ExlWorkBook = m_ExlWorkBooks.Add(covOptional);
m_ExlWorkSheets = m_ExlWorkBook.get_Sheets();
m_ExlWorkSheet = m_ExlWorkSheets.get_Item(_variant_t((short)2));