?? excel.cpp
字號:
long _Application::GetCalculationVersion()
{
long result;
InvokeHelper(0x70e, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
BOOL _Application::GetShowWindowsInTaskbar()
{
BOOL result;
InvokeHelper(0x70f, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetShowWindowsInTaskbar(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x70f, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Application::GetFeatureInstall()
{
long result;
InvokeHelper(0x710, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetFeatureInstall(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x710, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
BOOL _Application::GetReady()
{
BOOL result;
InvokeHelper(0x78c, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetFindFormat()
{
LPDISPATCH result;
InvokeHelper(0x78e, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Application::SetRefFindFormat(LPDISPATCH newValue)
{
static BYTE parms[] =
VTS_DISPATCH;
InvokeHelper(0x78e, DISPATCH_PROPERTYPUTREF, VT_EMPTY, NULL, parms,
newValue);
}
LPDISPATCH _Application::GetReplaceFormat()
{
LPDISPATCH result;
InvokeHelper(0x78f, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Application::SetRefReplaceFormat(LPDISPATCH newValue)
{
static BYTE parms[] =
VTS_DISPATCH;
InvokeHelper(0x78f, DISPATCH_PROPERTYPUTREF, VT_EMPTY, NULL, parms,
newValue);
}
LPDISPATCH _Application::GetUsedObjects()
{
LPDISPATCH result;
InvokeHelper(0x790, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long _Application::GetCalculationState()
{
long result;
InvokeHelper(0x791, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
long _Application::GetCalculationInterruptKey()
{
long result;
InvokeHelper(0x792, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetCalculationInterruptKey(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x792, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
LPDISPATCH _Application::GetWatches()
{
LPDISPATCH result;
InvokeHelper(0x793, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
BOOL _Application::GetDisplayFunctionToolTips()
{
BOOL result;
InvokeHelper(0x794, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetDisplayFunctionToolTips(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x794, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Application::GetAutomationSecurity()
{
long result;
InvokeHelper(0x795, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetAutomationSecurity(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x795, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
LPDISPATCH _Application::GetFileDialog(long fileDialogType)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x796, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, parms,
fileDialogType);
return result;
}
void _Application::CalculateFullRebuild()
{
InvokeHelper(0x799, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
BOOL _Application::GetDisplayPasteOptions()
{
BOOL result;
InvokeHelper(0x79a, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetDisplayPasteOptions(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x79a, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetDisplayInsertOptions()
{
BOOL result;
InvokeHelper(0x79b, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetDisplayInsertOptions(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x79b, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetGenerateGetPivotData()
{
BOOL result;
InvokeHelper(0x79c, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetGenerateGetPivotData(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x79c, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
LPDISPATCH _Application::GetAutoRecover()
{
LPDISPATCH result;
InvokeHelper(0x79d, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long _Application::GetHwnd()
{
long result;
InvokeHelper(0x79e, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
long _Application::GetHinstance()
{
long result;
InvokeHelper(0x79f, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::CheckAbort(const VARIANT& KeepAbort)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x7a0, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&KeepAbort);
}
LPDISPATCH _Application::GetErrorCheckingOptions()
{
LPDISPATCH result;
InvokeHelper(0x7a2, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
BOOL _Application::GetAutoFormatAsYouTypeReplaceHyperlinks()
{
BOOL result;
InvokeHelper(0x7a3, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetAutoFormatAsYouTypeReplaceHyperlinks(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x7a3, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
LPDISPATCH _Application::GetSmartTagRecognizers()
{
LPDISPATCH result;
InvokeHelper(0x7a4, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetNewWorkbook()
{
LPDISPATCH result;
InvokeHelper(0x61d, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetSpellingOptions()
{
LPDISPATCH result;
InvokeHelper(0x7a5, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetSpeech()
{
LPDISPATCH result;
InvokeHelper(0x7a6, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
BOOL _Application::GetMapPaperSize()
{
BOOL result;
InvokeHelper(0x7a7, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetMapPaperSize(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x7a7, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetShowStartupDialog()
{
BOOL result;
InvokeHelper(0x7a8, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetShowStartupDialog(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x7a8, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
CString _Application::GetDecimalSeparator()
{
CString result;
InvokeHelper(0x711, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Application::SetDecimalSeparator(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x711, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
CString _Application::GetThousandsSeparator()
{
CString result;
InvokeHelper(0x712, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Application::SetThousandsSeparator(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x712, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
BOOL _Application::GetUseSystemSeparators()
{
BOOL result;
InvokeHelper(0x7a9, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetUseSystemSeparators(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x7a9, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
LPDISPATCH _Application::GetThisCell()
{
LPDISPATCH result;
InvokeHelper(0x7aa, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetRtd()
{
LPDISPATCH result;
InvokeHelper(0x7ab, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
BOOL _Application::GetDisplayDocumentActionTaskPane()
{
BOOL result;
InvokeHelper(0x8cb, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetDisplayDocumentActionTaskPane(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x8cb, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
void _Application::DisplayXMLSourcePane(const VARIANT& XmlMap)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x8cc, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&XmlMap);
}
BOOL _Application::GetArbitraryXMLSupportAvailable()
{
BOOL result;
InvokeHelper(0x8ce, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
/////////////////////////////////////////////////////////////////////////////
// Sheets properties
/////////////////////////////////////////////////////////////////////////////
// Sheets operations
LPDISPATCH Sheets::GetApplication()
{
LPDISPATCH result;
InvokeHelper(0x94, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long Sheets::GetCreator()
{
long result;
InvokeHelper(0x95, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
LPDISPATCH Sheets::GetParent()
{
LPDISPATCH result;
InvokeHelper(0x96, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH Sheets::Add(const VARIANT& Before, const VARIANT& After, const VARIANT& Count, const VARIANT& Type)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0xb5, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
&Before, &After, &Count, &Type);
return result;
}
void Sheets::Copy(const VARIANT& Before, const VARIANT& After)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x227, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Before, &After);
}
long Sheets::GetCount()
{
long result;
InvokeHelper(0x76, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void Sheets::Delete()
{
InvokeHelper(0x75, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void Sheets::FillAcrossSheets(LPDISPATCH Range, long Type)
{
static BYTE parms[] =
VTS_DISPATCH VTS_I4;
InvokeHelper(0x1d5, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Range, Type);
}
LPDISPATCH Sheets::GetItem(const VARIANT& Index)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0xaa, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, parms,
&Index);
return result;
}
void Sheets::Move(const VARIANT& Before, const VARIANT& After)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x27d, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Before, &After);
}
LPUNKNOWN Sheets::Get_NewEnum()
{
LPUNKNOWN result;
InvokeHelper(0xfffffffc, DISPATCH_PROPERTYGET, VT_UNKNOWN, (void*)&result, NULL);
return result;
}
void Sheets::PrintPreview(const VARIANT& EnableChanges)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x119, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&EnableChanges);
}
void Sheets::Select(const VARIANT& Replace)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0xeb, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Replace);
}
LPDISPATCH Sheets::GetHPageBreaks()
{
LPDISPATCH result;
InvokeHelper(0x58a, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&resu?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -