//打开excel文件
BOOL IllusionExcelFile::OpenExcelFile(const TCHAR* file_name)
{
//先关闭
CloseExcelFile();
CFileFind filefind;
if (!filefind.FindFile(CString(file_name)))
{
//利用模板文件建立新文档
//excel_books_.AttachDispatch(excel_application_.get_Workbooks(),true);
//LPDISPATCH lpDis = NULL;
//lpDis = excel_books_.Add(COleVariant(file_name));
//if (lpDis)
//{
// excel_work_book_.AttachDispatch(lpDis);
// //得到Worksheets
// excel_sheets_.AttachDispatch(excel_work_book_.get_Worksheets(),true);
// //记录打开的文件名称
// open_excel_file_ = file_name;
// return TRUE;
//}
//return FALSE;
COleVariant covOptional((long)DISP_E_PARAMNOTFOUND,VT_ERROR);
excel_books_ = excel_application_.get_Workbooks();
//books.AttachDispatch(app.get_Workbooks());可代替上面一行
excel_work_book_ = excel_books_.Add(covOptional);
//book.AttachDispatch(books.Add(covOptional),true); 可代替上面一行
excel_sheets_=excel_work_book_.get_Worksheets();
//sheets.AttachDispatch(book.get_Worksheets(),true); 可代替上面一行
islocal_ = false;
open_excel_file_ = file_name;
return TRUE;
}else{
excel_books_ = excel_application_.get_Workbooks();
excel_work_book_ = excel_books_.Open(file_name,
covOptional, covOptional, covOptional, covOptional,
covOptional, covOptional, covOptional, covOptional,
covOptional, covOptional, covOptional, covOptional,
covOptional, covOptional);
excel_sheets_ = excel_work_book_.get_Worksheets();
islocal_ = true;
open_excel_file_ = file_name;
return FALSE;
}
}
//打开excel文件
BOOL IllusionExcelFile::OpenExcelFile(const char *file_name)
{
//先关闭
CloseExcelFile();
//利用模板文件建立新文档
excel_books_.AttachDispatch(excel_application_.get_Workbooks(), TRUE);
LPDISPATCH lpDis = NULL;
lpDis = excel_books_.Add(COleVariant(file_name));
if (lpDis)
{
excel_work_book_.AttachDispatch(lpDis);
//得到Worksheets
excel_sheets_.AttachDispatch(excel_work_book_.get_Worksheets(), TRUE);
//记录打开的文件名称
open_excel_file_ = file_name;
//open_excel_file_.Empty();//清空内容
return TRUE;
}
return FALSE;
}
//打开excel文件
BOOL CExcelFile::OpenExcelFile(CString file_name)
{
//先关闭
CloseExcelFile();
//利用模板文件建立新文档
excel_books_.AttachDispatch(excel_application_.get_Workbooks(),true);
LPDISPATCH lpDis = NULL;
lpDis = excel_books_.Add(COleVariant(file_name));
if (lpDis)
{
excel_work_book_.AttachDispatch(lpDis);
//得到Worksheets
excel_sheets_.AttachDispatch(excel_work_book_.get_Worksheets(),true);
//记录打开的文件名称
open_excel_file_ = file_name;
return TRUE;
}
return FALSE;
}
IllusionExcelFile::~IllusionExcelFile()
{
CloseExcelFile();
}
CExcelFile::~CExcelFile()
{
//
CloseExcelFile();
}
