📄 cworksheet.h
字号:
// 从类型库向导中用“添加类”创建的计算机生成的 IDispatch 包装类
//#import "D:\\Program Files\\Microsoft Office\\OFFICE11\\EXCEL.EXE" no_namespace
// CWorksheet 包装类
class CWorksheet : public COleDispatchDriver
{
public:
CWorksheet(){} // 调用 COleDispatchDriver 默认构造函数
CWorksheet(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
CWorksheet(const CWorksheet& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
// 属性
public:
// 操作
public:
// _QueryTable 方法
public:
LPDISPATCH get_Application()
{
LPDISPATCH result;
InvokeHelper(0x94, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long get_Creator()
{
long result;
InvokeHelper(0x95, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
LPDISPATCH get_Parent()
{
LPDISPATCH result;
InvokeHelper(0x96, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
CString get_Name()
{
CString result;
InvokeHelper(0x6e, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void put_Name(LPCTSTR newValue)
{
static BYTE parms[] = VTS_BSTR ;
InvokeHelper(0x6e, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
}
BOOL get_FieldNames()
{
BOOL result;
InvokeHelper(0x630, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void put_FieldNames(BOOL newValue)
{
static BYTE parms[] = VTS_BOOL ;
InvokeHelper(0x630, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
}
BOOL get_RowNumbers()
{
BOOL result;
InvokeHelper(0x631, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void put_RowNumbers(BOOL newValue)
{
static BYTE parms[] = VTS_BOOL ;
InvokeHelper(0x631, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
}
BOOL get_FillAdjacentFormulas()
{
BOOL result;
InvokeHelper(0x632, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void put_FillAdjacentFormulas(BOOL newValue)
{
static BYTE parms[] = VTS_BOOL ;
InvokeHelper(0x632, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
}
BOOL get_HasAutoFormat()
{
BOOL result;
InvokeHelper(0x2b7, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void put_HasAutoFormat(BOOL newValue)
{
static BYTE parms[] = VTS_BOOL ;
InvokeHelper(0x2b7, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
}
BOOL get_RefreshOnFileOpen()
{
BOOL result;
InvokeHelper(0x5c7, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void put_RefreshOnFileOpen(BOOL newValue)
{
static BYTE parms[] = VTS_BOOL ;
InvokeHelper(0x5c7, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
}
BOOL get_Refreshing()
{
BOOL result;
InvokeHelper(0x633, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL get_FetchedRowOverflow()
{
BOOL result;
InvokeHelper(0x634, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL get_BackgroundQuery()
{
BOOL result;
InvokeHelper(0x593, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void put_BackgroundQuery(BOOL newValue)
{
static BYTE parms[] = VTS_BOOL ;
InvokeHelper(0x593, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
}
void CancelRefresh()
{
InvokeHelper(0x635, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
long get_RefreshStyle()
{
long result;
InvokeHelper(0x636, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void put_RefreshStyle(long newValue)
{
static BYTE parms[] = VTS_I4 ;
InvokeHelper(0x636, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
}
BOOL get_EnableRefresh()
{
BOOL result;
InvokeHelper(0x5c5, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void put_EnableRefresh(BOOL newValue)
{
static BYTE parms[] = VTS_BOOL ;
InvokeHelper(0x5c5, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
}
BOOL get_SavePassword()
{
BOOL result;
InvokeHelper(0x5c9, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void put_SavePassword(BOOL newValue)
{
static BYTE parms[] = VTS_BOOL ;
InvokeHelper(0x5c9, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
}
LPDISPATCH get_Destination()
{
LPDISPATCH result;
InvokeHelper(0x2a9, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
VARIANT get_Connection()
{
VARIANT result;
InvokeHelper(0x598, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void put_Connection(VARIANT& newValue)
{
static BYTE parms[] = VTS_VARIANT ;
InvokeHelper(0x598, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, &newValue);
}
VARIANT get_Sql()
{
VARIANT result;
InvokeHelper(0x5c8, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void put_Sql(VARIANT& newValue)
{
static BYTE parms[] = VTS_VARIANT ;
InvokeHelper(0x5c8, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, &newValue);
}
CString get_PostText()
{
CString result;
InvokeHelper(0x637, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void put_PostText(LPCTSTR newValue)
{
static BYTE parms[] = VTS_BSTR ;
InvokeHelper(0x637, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
}
LPDISPATCH get_ResultRange()
{
LPDISPATCH result;
InvokeHelper(0x638, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void Delete()
{
InvokeHelper(0x75, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
BOOL Refresh(VARIANT& BackgroundQuery)
{
BOOL result;
static BYTE parms[] = VTS_VARIANT ;
InvokeHelper(0x589, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms, &BackgroundQuery);
return result;
}
LPDISPATCH get_Parameters()
{
LPDISPATCH result;
InvokeHelper(0x639, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH get_Recordset()
{
LPDISPATCH result;
InvokeHelper(0x48d, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void putref_Recordset(LPDISPATCH newValue)
{
static BYTE parms[] = VTS_DISPATCH ;
InvokeHelper(0x48d, DISPATCH_PROPERTYPUTREF, VT_EMPTY, NULL, parms, newValue);
}
BOOL get_SaveData()
{
BOOL result;
InvokeHelper(0x2b4, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void put_SaveData(BOOL newValue)
{
static BYTE parms[] = VTS_BOOL ;
InvokeHelper(0x2b4, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
}
BOOL get_TablesOnlyFromHTML()
{
BOOL result;
InvokeHelper(0x63a, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void put_TablesOnlyFromHTML(BOOL newValue)
{
static BYTE parms[] = VTS_BOOL ;
InvokeHelper(0x63a, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
}
BOOL get_EnableEditing()
{
BOOL result;
InvokeHelper(0x63b, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void put_EnableEditing(BOOL newValue)
{
static BYTE parms[] = VTS_BOOL ;
InvokeHelper(0x63b, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
}
long get_TextFilePlatform()
{
long result;
InvokeHelper(0x73f, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void put_TextFilePlatform(long newValue)
{
static BYTE parms[] = VTS_I4 ;
InvokeHelper(0x73f, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
}
long get_TextFileStartRow()
{
long result;
InvokeHelper(0x740, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void put_TextFileStartRow(long newValue)
{
static BYTE parms[] = VTS_I4 ;
InvokeHelper(0x740, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
}
long get_TextFileParseType()
{
long result;
InvokeHelper(0x741, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void put_TextFileParseType(long newValue)
{
static BYTE parms[] = VTS_I4 ;
InvokeHelper(0x741, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
}
long get_TextFileTextQualifier()
{
long result;
InvokeHelper(0x742, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void put_TextFileTextQualifier(long newValue)
{
static BYTE parms[] = VTS_I4 ;
InvokeHelper(0x742, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
}
BOOL get_TextFileConsecutiveDelimiter()
{
BOOL result;
InvokeHelper(0x743, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void put_TextFileConsecutiveDelimiter(BOOL newValue)
{
static BYTE parms[] = VTS_BOOL ;
InvokeHelper(0x743, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
}
BOOL get_TextFileTabDelimiter()
{
BOOL result;
InvokeHelper(0x744, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void put_TextFileTabDelimiter(BOOL newValue)
{
static BYTE parms[] = VTS_BOOL ;
InvokeHelper(0x744, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
}
BOOL get_TextFileSemicolonDelimiter()
{
BOOL result;
InvokeHelper(0x745, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void put_TextFileSemicolonDelimiter(BOOL newValue)
{
static BYTE parms[] = VTS_BOOL ;
InvokeHelper(0x745, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms, newValue);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -