MFC导入Excel数据问题
大鱼> 2015-05-09 01:35:01 oid ReadExcelToList(CListCtrl* pList, CString strTitle)
{
strTitle+=".xls";
CSpreadSheet sheet(strTitle,"覆压孔隙度参数");
CStringArray Rows, Column;
//清空列表框
pList->DeleteAllItems();//首先清空listview
int iCount,i;
iCount= pList->GetHeaderCtrl()->GetItemCount();
for(i=0; i<iCount;i++)
{
pList->DeleteColumn(0);
}
for(i= 0; i< iCount; i++)
{
pList->GetHeaderCtrl()->DeleteItem(0);
}
pList->InsertColumn(0,"覆压",LVCFMT_CENTER,155);
pList->InsertColumn(1,"孔隙度",LVCFMT_CENTER,154);
for (i =0; i <sheet.GetTotalRows()-1; i++)
{
// 读取一行
sheet.ReadRow(Rows, i+2);
CString strContents = "";
pList->InsertItem(i, strContents) ;
for (int j = 0; j < Rows.GetSize(); j++)
{
strContents = Rows.GetAt(j);
pList->SetItemText(i,j,strContents);
}
}
}
void CDataAnalysisDlg::OnBnClickedBtninput()
{
CFileDialog dlg(TRUE,NULL, NULL, OFN_HIDEREADONLY | OFN_OVERWRITEPROMPT, _T("Excel 文件(*.xls)|*.xls||"),AfxGetMainWnd());//打开文件
if(dlg.DoModal()==IDOK)
{
CString strPath = dlg.GetPathName();//获得文件路径名
m_Path.SetWindowTextA(strPath);//在编辑框中显示文件的路径
DWORD dwRe = GetFileAttributes(strPath);
/*if(dwRe!=(DWORD)-1)
{
MessageBox("请检查Excel表格中的数据,在导入前进行修改!","检查数据");
ShellExecute(NULL, NULL, strPath, NULL, NULL, SW_RESTORE); //将选中的Excel表格打开
}*/
// else return;
ReadExcelToList(&m_List,strPath);
}
else
MessageBox("数据导入失败!");
}
问什么数据在CListCtrl上显示不出来?