16,472
社区成员
发帖
与我相关
我的任务
分享
void CShowJpgDlg::OnMemberDoc()
{
if (!config_flag)
{
CFileDialog* lpszOpenFile;
vec.clear();
lpszOpenFile = new CFileDialog(TRUE, "", "", OFN_FILEMUSTEXIST | OFN_HIDEREADONLY, "Excel File(*.xlsx;*.xls)|*.xls;*.xlsx", NULL);
if (lpszOpenFile->DoModal() == IDOK)
{
szGetName = lpszOpenFile->GetPathName();
//SetWindowText(szGetName);
if (!config_flag)
{
::WritePrivateProfileString("SETTING", "memberinfo", szGetName.GetBuffer(szGetName.GetLength()), configpath.GetBuffer(configpath.GetLength()));
}
//delete lpszOpenFile;
}
else
{
return;
}
}
else
{
//szGetName 定义为CString
::GetPrivateProfileString("SETTING", "memberinfo", "Error", szGetName.GetBuffer(MAX_PATH), MAX_PATH, configpath);
if (szGetName == "Error")
{
MessageBox("图片路径出错,请删除程序路径下的config.ini文件,并重启");
}
}
//文件中包含多个sheet时,默认打开第一个sheet
CExport2Excel Excel_example;
Excel_example.OpenExcel(szGetName);
//Excel_example.SetSheet(0);
//获取sheet个数
int iSheetNum = Excel_example.GetSheetsNumber();
//获取已使用表格行列数
int iRows = Excel_example.GetRowCount();//iRows 获取不正常
int iCols = Excel_example.GetColCount();
for (int i = 2; i <= iRows; i++)//第一行为表头
{
MemberInfo *member = new MemberInfo;
member->setInfo(i-1, Excel_example.GetText(i, 2), Excel_example.GetText(i, 3));
vec.push_back(*member);
}
Excel_example.Close();
}