Excel封装类.docxVIP

//ExcelUtil.h?#includestdafx.h#include io.h#include..\ExcelWrapper\excel.husingnamespace Excel;?namespace Excel {class ExcelUtil {private: CString out_file_name;public: CString GetOutFileName() { return out_file_name; };void SetOutFileName(CString new_file_name) { if (new_file_name.GetLength()0) out_file_name = new_file_name; }private: _Application m_excelApp; Workbooks m_excelBooks; _Workbook m_excelBook; Worksheets m_excelSheets; _Worksheet m_excelSheet; Range m_excelRange;public:void CreateExcel() { COleException pError;?if (!m_excelApp.CreateDispatch(Excel.Application, pError)) { pError.ReportError();return; }else { m_excelBooks = m_excelApp.GetWorkbooks(); m_excelBook = m_excelBooks.Add(COleVariant((short)TRUE)); m_excelSheet = m_excelBook.GetActiveSheet(); } }?void OpenExcel(CString fileName) { COleException pError;?if (!m_excelApp.CreateDispatch(Excel.Application, pError)) { pError.ReportError();return; }else { COleVariant covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR); m_excelBooks = m_excelApp.GetWorkbooks(); m_excelBook = m_excelBooks.Open(fileName,covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional, covOptional); m_excelSheet = m_excelBook.GetActiveSheet(); out_file_name = fileName; } }?bool SaveExcel() {if (out_file_name.GetLength()==0) { AfxMessageBox(Excel路径未指定,无法保存);return false; }else { TRY {if (_access(out_file_name, 0) == 0) remove(out_file_name);? COleVariant covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR); m_excelBook.SaveAs(COleVariant(out_file_name),