MFC输出EXCEL文档的过程总结 - windows编程基础

break;
case 14:iSlotCtrl = 14;
break;
}
}
strCtrl = pCardBaseCtrl->GetCardTypeName();
str.Format("%d:%s",iSlotCtrl,strCtrl);
strCtrl.LoadString(IDS_SLOT);
str = strCtrl+str;
m_ExlRge.SetItem(_variant_t((long)(3+iSlot)),_variant_t((long)1),_variant_t(str));
}
}
CHHCardBase *pCardBase = dynamic_cast( pDBase->GetSuperCardBase(ucSystemCardSlot)); //系统盘
if (pCardBase != NULL)
{
int iChuCount = pCardBase->GetSpecifyPortCount(Port_CHU);
for (int iChuNum = 0 ; iChuNum < iChuCount ; iChuNum++)
{
int iChuType = 0xff;
int iChuStatus = 0xff;
CHHPort* pChuPort = pCardBase->GetPortByType( iChuNum, Port_CHU );
if (pChuPort != NULL)
{
int iChuNumCtrl =0;
int iSlotCtrl = 0;
if (iChuNum < 30)
{
iChuNumCtrl = iChuNum%8;
iSlotCtrl = 10- iChuNum/8;
}
else
{
iChuNumCtrl = (iChuNum+2)%8;
iSlotCtrl = 10 - (iChuNum+2)/8 ;
}
if(!pChuPort->GetPortIsUsedForChu())
{
continue;
}
CHHChuIfModule *pModule = dynamic_cast(pChuPort->GetModule(Mod_ChuIf));

if(pModule == NULL)
{
continue;
}
iChuType = pModule->GetChuType(TRUE);
str.Format("%d", iChuNumCtrl+1);
str = "CH"+ str;
m_ExlRge.SetItem(_variant_t((long)3),_variant_t((long)(2+iChuNumCtrl)),_variant_t(str));
str = GetChuTypeString(iChuType);
if (pGroup->GetExtModelID() == MFA) //MFA特殊处理
{
m_ExlRge.SetItem(_variant_t((long)(5+iSlotCtrl)),_variant_t((long)(2+iChuNumCtrl)),_variant_t(str));
}
else
{
m_ExlRge.SetItem(_variant_t((long)(4+iSlotCtrl)),_variant_t((long)(2+iChuNumCtrl)),_variant_t(str));
}
if (iChuNumCtrl >= nMaxChuCount)
{
nMaxChuCount = iChuNumCtrl +1;
}
}
}
}

//加载要合并的单元格
switch (nMaxChuCount)
{
case 8:
m_ExlRge.AttachDispatch(m_ExlSheet.GetRange(_variant_t("A1"),_variant_t("I2")),TRUE);

m_ExlRge.Merge(_variant_t((long)0));
break;
case 10:
m_ExlRge.AttachDispatch(m_ExlSheet.GetRange(_variant_t("A1"),_variant_t("K2")),TRUE);

m_ExlRge.Merge(_variant_t((long)0));
break;
case 16:
m_ExlRge.AttachDispatch(m_ExlSheet.GetRange(

MFC输出EXCEL文档的过程总结(六)