呵呵,我找找。我做过。 这里面的CSpreadSheet是最关键的,一个打包好类。希望能够帮到你吧。
CSpreadSheet sheet(m_strExcel,"sheet1"); //打开工作簿中的工作表sheet1!
CString sCellValue;
long rows=sheet.GetTotalRows();
short columns=sheet.GetTotalColumns();
for(long j=3;j<=rows;j++){
CString sName = "";
CString sMachine = "";
for(short i=1;i<=5;i++) {
sheet.ReadCell(sCellValue,i,j);
switch(i){
case 1:
sName = sCellValue;
break;
case 2:
iType = atoi(sCellValue);
break;
case 3:
iCount = atoi(sCellValue);
break;
case 4:
iDays = atoi(sCellValue);
break;
case 5:
sMachine = sCellValue;
break;
}
}