这篇文章是接上一篇 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(_