?? excel9.cpp
字號:
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);
}
/////////////////////////////////////////////////////////////////////////////
// _Workbook properties
/////////////////////////////////////////////////////////////////////////////
// _Workbook operations
LPDISPATCH _Workbook::GetApplication()
{
LPDISPATCH result;
InvokeHelper(0x94, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long _Workbook::GetCreator()
{
long result;
InvokeHelper(0x95, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetParent()
{
LPDISPATCH result;
InvokeHelper(0x96, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
BOOL _Workbook::GetAcceptLabelsInFormulas()
{
BOOL result;
InvokeHelper(0x5a1, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetAcceptLabelsInFormulas(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x5a1, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
void _Workbook::Activate()
{
InvokeHelper(0x130, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
LPDISPATCH _Workbook::GetActiveChart()
{
LPDISPATCH result;
InvokeHelper(0xb7, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetActiveSheet()
{
LPDISPATCH result;
InvokeHelper(0x133, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long _Workbook::GetAutoUpdateFrequency()
{
long result;
InvokeHelper(0x5a2, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Workbook::SetAutoUpdateFrequency(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x5a2, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
BOOL _Workbook::GetAutoUpdateSaveChanges()
{
BOOL result;
InvokeHelper(0x5a3, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetAutoUpdateSaveChanges(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x5a3, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Workbook::GetChangeHistoryDuration()
{
long result;
InvokeHelper(0x5a4, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Workbook::SetChangeHistoryDuration(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x5a4, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
LPDISPATCH _Workbook::GetBuiltinDocumentProperties()
{
LPDISPATCH result;
InvokeHelper(0x498, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Workbook::ChangeFileAccess(long Mode, const VARIANT& WritePassword, const VARIANT& Notify)
{
static BYTE parms[] =
VTS_I4 VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x3dd, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Mode, &WritePassword, &Notify);
}
void _Workbook::ChangeLink(LPCTSTR Name, LPCTSTR NewName, long Type)
{
static BYTE parms[] =
VTS_BSTR VTS_BSTR VTS_I4;
InvokeHelper(0x322, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Name, NewName, Type);
}
LPDISPATCH _Workbook::GetCharts()
{
LPDISPATCH result;
InvokeHelper(0x79, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Workbook::Close(const VARIANT& SaveChanges, const VARIANT& Filename, const VARIANT& RouteWorkbook)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x115, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&SaveChanges, &Filename, &RouteWorkbook);
}
CString _Workbook::GetCodeName()
{
CString result;
InvokeHelper(0x55d, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
CString _Workbook::Get_CodeName()
{
CString result;
InvokeHelper(0x80010000, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Workbook::Set_CodeName(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x80010000, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
VARIANT _Workbook::GetColors(const VARIANT& Index)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x11e, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, parms,
&Index);
return result;
}
void _Workbook::SetColors(const VARIANT& Index, const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x11e, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&Index, &newValue);
}
LPDISPATCH _Workbook::GetCommandBars()
{
LPDISPATCH result;
InvokeHelper(0x59f, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long _Workbook::GetConflictResolution()
{
long result;
InvokeHelper(0x497, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Workbook::SetConflictResolution(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x497, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
LPDISPATCH _Workbook::GetContainer()
{
LPDISPATCH result;
InvokeHelper(0x4a6, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
BOOL _Workbook::GetCreateBackup()
{
BOOL result;
InvokeHelper(0x11f, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetCustomDocumentProperties()
{
LPDISPATCH result;
InvokeHelper(0x499, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
BOOL _Workbook::GetDate1904()
{
BOOL result;
InvokeHelper(0x193, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetDate1904(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x193, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
void _Workbook::DeleteNumberFormat(LPCTSTR NumberFormat)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x18d, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
NumberFormat);
}
long _Workbook::GetDisplayDrawingObjects()
{
long result;
InvokeHelper(0x194, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Workbook::SetDisplayDrawingObjects(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x194, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
BOOL _Workbook::ExclusiveAccess()
{
BOOL result;
InvokeHelper(0x490, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
return result;
}
long _Workbook::GetFileFormat()
{
long result;
InvokeHelper(0x120, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Workbook::ForwardMailer()
{
InvokeHelper(0x3cd, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
CString _Workbook::GetFullName()
{
CString result;
InvokeHelper(0x121, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
BOOL _Workbook::GetHasPassword()
{
BOOL result;
InvokeHelper(0x122, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL _Workbook::GetHasRoutingSlip()
{
BOOL result;
InvokeHelper(0x3b6, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetHasRoutingSlip(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x3b6, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Workbook::GetIsAddin()
{
BOOL result;
InvokeHelper(0x5a5, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetIsAddin(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x5a5, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
VARIANT _Workbook::LinkInfo(LPCTSTR Name, long LinkInfo, const VARIANT& Type, const VARIANT& EditionRef)
{
VARIANT result;
static BYTE parms[] =
VTS_BSTR VTS_I4 VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x327, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
Name, LinkInfo, &Type, &EditionRef);
return result;
}
VARIANT _Workbook::LinkSources(const VARIANT& Type)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x328, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Type);
return result;
}
LPDISPATCH _Workbook::GetMailer()
{
LPDISPATCH result;
InvokeHelper(0x3d3, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Workbook::MergeWorkbook(const VARIANT& Filename)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x5a6, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Filename);
}
BOOL _Workbook::GetMultiUserEditing()
{
BOOL result;
InvokeHelper(0x491, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
CString _Workbook::GetName()
{
CString result;
InvokeHelper(0x6e, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetNames()
{
LPDISPATCH result;
InvokeHelper(0x1ba, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::NewWindow()
{
LPDISPATCH result;
InvokeHelper(0x118, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Workbook::OpenLinks(LPCTSTR Name, const VARIANT& ReadOnly, const VARIANT& Type)
{
static BYTE parms[] =
VTS_BSTR VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x323, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Name, &ReadOnly, &Type);
}
CString _Workbook::GetPath()
{
CString result;
InvokeHelper(0x123, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
BOOL _Workbook::GetPersonalViewListSettings()
{
BOOL result;
InvokeHelper(0x5a7, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetPersonalViewListSettings(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x5a7, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Workbook::GetPersonalViewPrintSettings()
{
BOOL result;
InvokeHelper(0x5a8, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetPersonalViewPrintSettings(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x5a8, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
LPDISPATCH _Workbook::PivotCaches()
{
LPDISPATCH result;
InvokeHelper(0x5a9, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Workbook::Post(const VARIANT& DestName)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x48e, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&DestName);
}
BOOL _Workbook::GetPrecisionAsDisplayed()
{
BOOL result;
InvokeHelper(0x195, DISPATCH_PROPERTYGET, VT_BOOL, (void?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -