编译通过,但是执行的弹一个没有错误代码的错误框是撒原因?
int i,j;
for (i=1;i<=sheetsum;i++)
{
CString haha;
m_oWorkSheet.AttachDispatch(m_oWorkSheets.GetItem(COleVariant((long)i)));
haha=m_oWorkSheet.GetName();
m_shit.AddString(haha);
//ÒѾ­Ê¹ÓõÄÐÐÊý
Range usedRange;
usedRange.AttachDispatch(m_oWorkSheet.GetUsedRange());
m_oCurrRange.AttachDispatch(usedRange.GetRows());
long iRowNum=m_oCurrRange.GetCount();
CString hangnum;
hangnum.Format("%ld",iRowNum);
m_hang.SetWindowText((LPCTSTR)hangnum);
//ÒѾ­Ê¹ÓõÄÁÐÊý
m_oCurrRange.AttachDispatch(usedRange.GetColumns());
long iColNum=m_oCurrRange.GetCount();
CString lienum;
lienum.Format("%ld",iColNum);
m_lie.SetWindowText((LPCTSTR)lienum);
//È¡µÃÒÑʹÓÃÇøÓòµÄÆðʼÐУ¬´Ó1¿ªÊ¼
long iStartRow = usedRange.GetRow();
CString hang;
hang.Format("%ld",iStartRow);
m_qishihang.SetWindowText(hang);
//È¡µÃÒÑʹÓÃÇøÓòµÄÆðʼÁУ¬´Ó1¿ªÊ¼
long iStartCol = usedRange.GetColumn();
CString lie;
lie.Format("%ld",iStartCol);
m_qishilie.SetWindowText(lie);
//°´Ë³Ðò¶Áȡÿ¸öµ¥Ôª¸ñÄÚÈÝ
for (i=iStartRow;i<=iRowNum;i++)
{
for(j=iStartCol;i<=iColNum;j++)
{
m_oCurrRange.AttachDispatch(m_oWorkSheet.GetCells());
m_oCurrRange.AttachDispatch(m_oCurrRange.GetItem (COleVariant((long)i),COleVariant((long)j)).pdispVal);
VARIANT varMerge=m_oCurrRange.GetMergeCells();
if (varMerge.boolVal==-1)
{
Range rangeMerge;
rangeMerge.AttachDispatch(m_oCurrRange.GetMergeArea());
rangeMerge.AttachDispatch(rangeMerge.GetColumns());
int mergecol=rangeMerge.GetCount();
if(mergecol>iColNum-4)
break;
else
continue;
}
else if(varMerge.boolVal==0)
{
CString cellcontext;
vResult = m_oCurrRange.GetValue2();
if(vResult.vt == VT_BSTR)
{
cellcontext=vResult.bstrVal;
int sign=m_gangcaiziyuan.GetItemCount();
CString temp2;
temp2.Format("%d",sign);
m_test.SetWindowText(temp2);
if(cellcontext.Find("ÀäÔþ")!=-1||cellcontext.Find("¶ÆÐ¿")!=-1||cellcontext.Find("²ÊÍ¿")!=-1||cellcontext.Find("¶ÆÂÁп")!=-1||cellcontext.Find("пÌú")!=-1)
{
if(sign==0)
{
m_gangcaiziyuan.InsertItem(0,"0");
m_gangcaiziyuan.SetItemText(0,1,cellcontext);
}
else
{
if(m_gangcaiziyuan.GetItemText(sign-1,1)=="")
m_gangcaiziyuan.SetItemText(sign-1,1,cellcontext);
else
{
CString temp;
temp.Format("%d",sign);
m_gangcaiziyuan.InsertItem(sign,temp);
m_gangcaiziyuan.SetItemText(sign,1,cellcontext);
}
}
}
else if(cellcontext.GetAt(0)>='A'||cellcontext.GetAt(0)<='Z'||cellcontext.Find(":")!=-1)
{
}
else if(cellcontext.Find("±¦¸Ö")!=-1)
{
}
else if(cellcontext.Find("*")!=-1)
{
}
else if(cellcontext.Find("¼þÖØ")!=-1)
{
}
else
{
}
}
else if(vResult.vt == VT_R8)
{
}
}
} 乱码处是中文
[解决办法]
- -,我来接分的
[解决办法]