杰克东的专栏

CApplication xlsAppLication;//初始化略CString macro = _T("macro");//excel文件中的宏名字例如：假如宏的名字是marco1 那么就传入macro = _T("macro1");xlsAppLication.Run(_variant_t(macro),vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtMissing,vtM

/*enum XlInsertFormatOrigin { xlFormatFromLeftOrAbove = 0,//向上插入行 xlFormatFromRightOrBelow = 1//向下插入行 }; */本例是以Excel2007为例CApplication xlsAppLication;//初始化ole还有excel略LPDISPATCH lpDisp = NULL; lpDisp = xlsAppLication.get_ActiveSheet(); CWork

以Excel2007为例请自行根据不同版本的Excel库进行相应的更改/*enum XlMousePointer{ xlIBeam = 3, xlDefault = -4143, xlNorthwestArrow = 1, xlWait = 2};光标样式枚举*/XlMousePointer xlmouse;CApplication xlsAppLication;//初始化略xlsAppLication.put_Cursor(xlmouse);

//绘制外边框void XlsDrawOutBorders(const CString &Row, const CString &Col,XlBordersLineStyle xlLineStyle, XlBorderWeight XlsWeight,long coloIndex){ if (!xlsAppIsInit()) { return; } if (Row.IsEmpty(

//设置行高void XlsSetRowHeight(int Row, double height){ if (!xlsAppIsInit()) { return; } CRange range; LPDISPATCH lpDisp = NULL; /*得到工作簿中的Sheet的容器*/ lpDisp = m_xlsAppLication.get_ActiveSheet

//获得一组单元格中的数据 CString COperExcel::XlsGetRangeStrData(const CString &Row, const CString &Col){ if (!xlsAppIsInit()) { return _T("erro"); } if (Row.IsEmpty() || Col.IsEmpty()) { retu...

enum CellHorizonAlignment { xlCenter = -4108, xlLeft = -4131, xlRight = -4152, xlFill = 5, xlJustify= -4130, xlCenterAcrossSelection = 7, xlDistributed= -4117 }; enum CellVer...

//插入图片void COperExcel::XlsInsertPictrue(const CString &strPicPath,float xPos, float yPos,float picWidth, float picHeight){ if (!xlsAppIsInit()) { return; } if (strPicPath.IsEmpty()) { ...