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