自己总结的OLE操作EXCEL的常数宏解决方法

//exceldef.h
#if !defined _HEAD_FILE_EXCELDEF
#define _HEAD_FILE_EXCELDEF
/////////////////////////////////////////////////////////////////////////////
//excel defined
typedef _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