?? excel9.cpp
字號:
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x708, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
LPDISPATCH _Application::GetLanguageSettings()
{
LPDISPATCH result;
InvokeHelper(0x709, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetAnswerWizard()
{
LPDISPATCH result;
InvokeHelper(0x70c, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Application::CalculateFull()
{
InvokeHelper(0x70d, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
BOOL _Application::FindFile()
{
BOOL result;
InvokeHelper(0x6eb, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
return result;
}
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);
}
/////////////////////////////////////////////////////////////////////////////
// _Worksheet properties
/////////////////////////////////////////////////////////////////////////////
// _Worksheet operations
LPDISPATCH _Worksheet::GetApplication()
{
LPDISPATCH result;
InvokeHelper(0x94, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long _Worksheet::GetCreator()
{
long result;
InvokeHelper(0x95, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
LPDISPATCH _Worksheet::GetParent()
{
LPDISPATCH result;
InvokeHelper(0x96, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Worksheet::Activate()
{
InvokeHelper(0x130, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void _Worksheet::Copy(const VARIANT& Before, const VARIANT& After)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x227, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Before, &After);
}
void _Worksheet::Delete()
{
InvokeHelper(0x75, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
CString _Worksheet::GetCodeName()
{
CString result;
InvokeHelper(0x55d, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
CString _Worksheet::Get_CodeName()
{
CString result;
InvokeHelper(0x80010000, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Worksheet::Set_CodeName(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x80010000, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
long _Worksheet::GetIndex()
{
long result;
InvokeHelper(0x1e6, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Worksheet::Move(const VARIANT& Before, const VARIANT& After)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x27d, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Before, &After);
}
CString _Worksheet::GetName()
{
CString result;
InvokeHelper(0x6e, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Worksheet::SetName(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x6e, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
LPDISPATCH _Worksheet::GetNext()
{
LPDISPATCH result;
InvokeHelper(0x1f6, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Worksheet::GetPageSetup()
{
LPDISPATCH result;
InvokeHelper(0x3e6, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Worksheet::GetPrevious()
{
LPDISPATCH result;
InvokeHelper(0x1f7, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Worksheet::PrintPreview(const VARIANT& EnableChanges)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x119, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&EnableChanges);
}
void _Worksheet::Protect(const VARIANT& Password, const VARIANT& DrawingObjects, const VARIANT& Contents, const VARIANT& Scenarios, const VARIANT& UserInterfaceOnly)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x11a, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Password, &DrawingObjects, &Contents, &Scenarios, &UserInterfaceOnly);
}
BOOL _Worksheet::GetProtectContents()
{
BOOL result;
InvokeHelper(0x124, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL _Worksheet::GetProtectDrawingObjects()
{
BOOL result;
InvokeHelper(0x125, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL _Worksheet::GetProtectionMode()
{
BOOL result;
InvokeHelper(0x487, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL _Worksheet::GetProtectScenarios()
{
BOOL result;
InvokeHelper(0x126, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Worksheet::SaveAs(LPCTSTR Filename, const VARIANT& FileFormat, const VARIANT& Password, const VARIANT& WriteResPassword, const VARIANT& ReadOnlyRecommended, const VARIANT& CreateBackup, const VARIANT& AddToMru, const VARIANT& TextCodepage, const VARIANT& TextVisualLayout)
{
static BYTE parms[] =
VTS_BSTR VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x11c, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Filename, &FileFormat, &Password, &WriteResPassword, &ReadOnlyRecommended, &CreateBackup, &AddToMru, &TextCodepage, &TextVisualLayout);
}
void _Worksheet::Select(const VARIANT& Replace)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0xeb, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Replace);
}
void _Worksheet::Unprotect(const VARIANT& Password)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x11d, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Password);
}
long _Worksheet::GetVisible()
{
long result;
InvokeHelper(0x22e, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Worksheet::SetVisible(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x22e, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
LPDISPATCH _Worksheet::GetShapes()
{
LPDISPATCH result;
InvokeHelper(0x561, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
BOOL _Worksheet::GetTransitionExpEval()
{
BOOL result;
InvokeHelper(0x191, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Worksheet::SetTransitionExpEval(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x191, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Worksheet::GetAutoFilterMode()
{
BOOL result;
InvokeHelper(0x318, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Worksheet::SetAutoFilterMode(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x318, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
void _Worksheet::SetBackgroundPicture(LPCTSTR Filename)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x4a4, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Filename);
}
void _Worksheet::Calculate()
{
InvokeHelper(0x117, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
BOOL _Worksheet::GetEnableCalculation()
{
BOOL result;
InvokeHelper(0x590, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Worksheet::SetEnableCalculation(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x590, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
LPDISPATCH _Worksheet::GetCells()
{
LPDISPATCH result;
InvokeHelper(0xee, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Worksheet::ChartObjects(const VARIANT& Index)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x424, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
&Index);
return result;
}
void _Worksheet::CheckSpelling(const VARIANT& CustomDictionary, const VARIANT& IgnoreUppercase, const VARIANT& AlwaysSuggest, const VARIANT& SpellLang)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x1f9, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&CustomDictionary, &IgnoreUppercase, &AlwaysSuggest, &SpellLang);
}
LPDISPATCH _Worksheet::GetCircularReference()
{
LPDISPATCH result;
InvokeHelper(0x42d, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Worksheet::ClearArrows()
{
InvokeHelper(0x3ca, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
LPDISPATCH _Worksheet::GetColumns()
{
LPDISPATCH result;
InvokeHelper(0xf1, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long _Worksheet::GetConsolidationFunction()
{
long result;
InvokeHelper(0x315, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
VARIANT _Worksheet::GetConsolidationOptions()
{
VARIANT result;
InvokeHelper(0x316, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT _Worksheet::GetConsolidationSources()
{
VARIANT result;
InvokeHelper(0x317, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
BOOL _Worksheet::GetEnableAutoFilter()
{
BOOL result;
InvokeHelper(0x484, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Worksheet::SetEnableAutoFilter(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x484, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Worksheet::GetEnableSelection()
{
long result;
InvokeHelper(0x591, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Worksheet::SetEnableSelection(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x591, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
BOOL _Worksheet::GetEnableOutlining()
{
BOOL result;
InvokeHelper(0x485, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Worksheet::SetEnableOutlining(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x485, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Worksheet::GetEnablePivotTable()
{
BOOL result;
InvokeHelper(0x486, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Worksheet::SetEnablePivotTable(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x486, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
VARIANT _Worksheet::Evaluate(const VARIANT& Name)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x1, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Name);
return result;
}
VARIANT _Worksheet::_Evaluate(const VARIANT& Name)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0xfffffffb, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Name);
return result;
}
BOOL _Worksheet::GetFilterMode()
{
BOOL result;
InvokeHelper(0x320, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Worksheet::ResetAllPageBreaks()
{
InvokeHelper(0x592, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
LPDISPATCH _Worksheet::GetNames()
{
LPDISPATCH result;
InvokeHelper(0x1ba, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Worksheet::OLEObjects(const VARIANT& Index)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x31f, DISPATCH_METHOD, VT_D?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -