自己总结的OLE操作EXCEL的常数宏
自己总结的OLE操作EXCEL的常数宏,拿出来和大家分享一下,可能不太全,希望大家不断补充.全了的话,做成一个完善的H文件,供大家使用.

C/C++ code

//exceldef.h#if !defined _HEAD_FILE_EXCELDEF#define _HEAD_FILE_EXCELDEF///////////////////////////////////////////////////////////////////////////////excel definedtypedef _variant_t    _var_t;#define etRangeValueDefault    10//WPS ET单元格默认的值类型////////////Alignment 对齐//HorizontalAlignment and VerticalAlignment//水平垂直公用 #define xlCenter        _var_t(long(-4108))//居中#define xlJustify        _var_t(long(-4130))//两端对齐#define xlDistributed    _var_t(long(-4117))//分散对齐//SetHorizontalAlignment or GetHorizontalAlignment//水平对齐#define xlGeneral        _var_t(long(1))//常规#define xlFill            _var_t(long(5))//填充#define xlCenterAcrossSelection    _var_t(long(7))//跨列居中#define xlLeft            _var_t(long(-4131))//左对齐#define xlRight            _var_t(long(-4152))//右对齐//SetVerticalAlignment or GetVerticalAlignment//垂直对齐#define xlTop            _var_t(long(-4160))//上对齐#define xlBottom        _var_t(long(-4107))//下对齐/////////////////////////////////////////////////////border use Borders::GetItem()//边框标识符#define xlDiagonalDown    _var_t(long(5))//斜下线＼#define xlDiagonalUp    _var_t(long(6))//斜上线／#define xlEdgeLeft        _var_t(long(7))//左线#define xlEdgeTop        _var_t(long(8))//上线#define xlEdgeBottom    _var_t(long(9))//右线#define xlEdgeRight        _var_t(long(10))//下线#define xlInsideVertical    _var_t(long(11))//内部垂直线#define xlInsideHorizontal    _var_t(long(12))//内部水平线#define xlNone            _var_t(long(-4142))//无边框线//颜色#define xlAutomatic        _var_t(long(-4105))//自动的//SetLineStyle or GetLineStyle//边框线类型#define xlContinuous    _var_t(long(1))//连续的线──#define xlDashDot        _var_t(long(4))//点虚线-─-─#define xlDashDotDot    _var_t(long(5))//点点虚线--─--#define xlSlantDashDot    _var_t(long(13))//斜点虚线#define xlLineStyleNone    _var_t(long(-4112))//无#define xlDash            _var_t(long(-4115))//虚线┄#define xlDot            _var_t(long(-4118))//点线┈#define xlDouble        _var_t(long(-4119))//双线＝//SetReadingOrder or GetReadingOrder//读取顺序#define xlRTL            _var_t(long(-5004))//从右到左#define xlLTR            _var_t(long(-5003))//从左到右#define xlContext        _var_t(long(-5002))//根据内容//PageSetup::Orientation//页面设置:方向#define xlPortrait            _var_t(long(1))//横向打印#define xlLandscape            _var_t(long(2))//纵向打印//PageSetup::PrintComments#define xlPortrait            _var_t(long(1))//横向打印#define xlLandscape            _var_t(long(2))//纵向打印//Validation//add type#define xlValidateInputOnly     _var_t(long(0))//整数#define xlValidateWholeNumber    _var_t(long(1))//整数#define xlValidateDecimal         _var_t(long(2))//小数#define xlValidateList            _var_t(long(3))//序列#define xlValidateDate             _var_t(long(4))//日期#define xlValidateTime          _var_t(long(5))//时间#define xlValidateTextLength      _var_t(long(6))//文本长度#define xlValidateCustom          _var_t(long(7))//自定义//AlertStyle#define xlValidAlertStop           _var_t(long(1))//停止#define xlValidAlertWarning       _var_t(long(2))//告警#define xlValidAlertInformation _var_t(long(3))//信息//Operator#define xlBetween        _var_t(long(1))//<>#define xlNotBetween    _var_t(long(2))//><#define xlEqual            _var_t(long(3))//==#define xlNotEqual        _var_t(long(4))//!=#define xlGreater        _var_t(long(5))//>#define xlLess             _var_t(long(6))//<#define xlGreaterEqual     _var_t(long(7))//>=#define xlLessEqual      _var_t(long(8))//<=#endif