📄 vcf1.cpp
字号:
void CVCF1::SetRowHeightAuto(long nR1, long nC1, long nR2, long nC2, BOOL bSetDefaults)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_BOOL;
InvokeHelper(0xe3, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nR1, nC1, nR2, nC2, bSetDefaults);
}
void CVCF1::SetSelection(long nR1, long nC1, long nR2, long nC2)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4 VTS_I4;
InvokeHelper(0xe4, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nR1, nC1, nR2, nC2);
}
void CVCF1::ShowActiveCell()
{
InvokeHelper(0xe5, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CVCF1::Sort3(long nR1, long nC1, long nR2, long nC2, BOOL bSortByRows, long nKey1, long nKey2, long nKey3)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_BOOL VTS_I4 VTS_I4 VTS_I4;
InvokeHelper(0xe6, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nR1, nC1, nR2, nC2, bSortByRows, nKey1, nKey2, nKey3);
}
void CVCF1::SortDlg()
{
InvokeHelper(0xe7, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CVCF1::StartEdit(BOOL bClear, BOOL bInCellEditFocus, BOOL bArrowsExitEditMode)
{
static BYTE parms[] =
VTS_BOOL VTS_BOOL VTS_BOOL;
InvokeHelper(0xe8, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
bClear, bInCellEditFocus, bArrowsExitEditMode);
}
void CVCF1::SwapTables(long hSS2)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0xe9, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
hSS2);
}
void CVCF1::TransactCommit()
{
InvokeHelper(0xea, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CVCF1::TransactRollback()
{
InvokeHelper(0xeb, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CVCF1::TransactStart()
{
InvokeHelper(0xec, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CVCF1::TwipsToRC(long x, long y, long* pRow, long* pCol)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_PI4 VTS_PI4;
InvokeHelper(0xed, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
x, y, pRow, pCol);
}
void CVCF1::SSUpdate()
{
InvokeHelper(0xee, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
short CVCF1::SSVersion()
{
short result;
InvokeHelper(0xef, DISPATCH_METHOD, VT_I2, (void*)&result, NULL);
return result;
}
void CVCF1::Write(LPCTSTR pPathName, short FileType)
{
static BYTE parms[] =
VTS_BSTR VTS_I2;
InvokeHelper(0xf0, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
pPathName, FileType);
}
void CVCF1::WriteToBlob(long* phBlob, short nReservedBytes)
{
static BYTE parms[] =
VTS_PI4 VTS_I2;
InvokeHelper(0xf1, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
phBlob, nReservedBytes);
}
void CVCF1::SetRowHidden(long nRow1, long nRow2, BOOL bHidden)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_BOOL;
InvokeHelper(0xf2, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nRow1, nRow2, bHidden);
}
void CVCF1::SetColHidden(long nCol1, long nCol2, BOOL bHidden)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_BOOL;
InvokeHelper(0xf3, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nCol1, nCol2, bHidden);
}
void CVCF1::SetColWidthTwips(long nCol1, long nCol2, long nWidth, BOOL bDefColWidth)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4 VTS_BOOL;
InvokeHelper(0xf4, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nCol1, nCol2, nWidth, bDefColWidth);
}
CString CVCF1::GetDefinedNameByIndex(long nName)
{
CString result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x11d, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, parms,
nName);
return result;
}
void CVCF1::SetDefinedNameByIndex(long nName, LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_BSTR;
InvokeHelper(0x11d, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nName, lpszNewValue);
}
CString CVCF1::GetSheetName(long nSheet)
{
CString result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x11e, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, parms,
nSheet);
return result;
}
void CVCF1::SetSheetName(long nSheet, LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_BSTR;
InvokeHelper(0x11e, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nSheet, lpszNewValue);
}
unsigned long CVCF1::GetPaletteEntry(long nEntry)
{
unsigned long result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x11f, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, parms,
nEntry);
return result;
}
void CVCF1::SetPaletteEntry(long nEntry, unsigned long newValue)
{
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0x11f, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nEntry, newValue);
}
void CVCF1::EditInsertSheets()
{
InvokeHelper(0xf5, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CVCF1::EditDeleteSheets()
{
InvokeHelper(0xf6, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CVCF1::InsertSheets(long nSheet, long nSheets)
{
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0xf7, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nSheet, nSheets);
}
void CVCF1::DeleteSheets(long nSheet, long nSheets)
{
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0xf8, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nSheet, nSheets);
}
void CVCF1::Refresh()
{
InvokeHelper(DISPID_REFRESH, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
short CVCF1::GetColWidthTwips(long Col)
{
short result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x120, DISPATCH_PROPERTYGET, VT_I2, (void*)&result, parms,
Col);
return result;
}
void CVCF1::SetColWidthTwips(long Col, short nNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_I2;
InvokeHelper(0x120, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
Col, nNewValue);
}
long CVCF1::NextColPageBreak(long Col)
{
long result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0xf9, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
Col);
return result;
}
long CVCF1::NextRowPageBreak(long Row)
{
long result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0xfa, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
Row);
return result;
}
long CVCF1::ObjFirstID()
{
long result;
InvokeHelper(0xfb, DISPATCH_METHOD, VT_I4, (void*)&result, NULL);
return result;
}
long CVCF1::ObjNextID(long ID)
{
long result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0xfc, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
ID);
return result;
}
short CVCF1::ObjGetItemCount(long ID)
{
short result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0xfd, DISPATCH_METHOD, VT_I2, (void*)&result, parms,
ID);
return result;
}
short CVCF1::ObjGetType(long ID)
{
short result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0xfe, DISPATCH_METHOD, VT_I2, (void*)&result, parms,
ID);
return result;
}
short CVCF1::ObjGetSelectionCount()
{
short result;
InvokeHelper(0xff, DISPATCH_METHOD, VT_I2, (void*)&result, NULL);
return result;
}
CString CVCF1::FormatRCNr(long Row, long Col, BOOL DoAbsolute)
{
CString result;
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_BOOL;
InvokeHelper(0x100, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
Row, Col, DoAbsolute);
return result;
}
long CVCF1::SS()
{
long result;
InvokeHelper(0x101, DISPATCH_METHOD, VT_I4, (void*)&result, NULL);
return result;
}
CString CVCF1::ErrorNumberToText(long SSError)
{
CString result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x102, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
SSError);
return result;
}
CString CVCF1::GetObjItem(long ID, short Item)
{
CString result;
static BYTE parms[] =
VTS_I4 VTS_I2;
InvokeHelper(0x121, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, parms,
ID, Item);
return result;
}
void CVCF1::SetObjItem(long ID, short Item, LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_I2 VTS_BSTR;
InvokeHelper(0x121, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
ID, Item, lpszNewValue);
}
CString CVCF1::GetObjItems(long ID)
{
CString result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x122, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, parms,
ID);
return result;
}
void CVCF1::SetObjItems(long ID, LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_BSTR;
InvokeHelper(0x122, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
ID, lpszNewValue);
}
CString CVCF1::GetObjName(long ID)
{
CString result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x123, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, parms,
ID);
return result;
}
void CVCF1::SetObjName(long ID, LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_BSTR;
InvokeHelper(0x123, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
ID, lpszNewValue);
}
CString CVCF1::GetObjText(long ID)
{
CString result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x124, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, parms,
ID);
return result;
}
void CVCF1::SetObjText(long ID, LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_BSTR;
InvokeHelper(0x124, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
ID, lpszNewValue);
}
short CVCF1::GetObjValue(long ID)
{
short result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x125, DISPATCH_PROPERTYGET, VT_I2, (void*)&result, parms,
ID);
return result;
}
void CVCF1::SetObjValue(long ID, short nNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_I2;
InvokeHelper(0x125, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
ID, nNewValue);
}
BOOL CVCF1::GetObjVisible(long ID)
{
BOOL result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x126, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, parms,
ID);
return result;
}
void CVCF1::SetObjVisible(long ID, BOOL bNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_BOOL;
InvokeHelper(0x126, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
ID, bNewValue);
}
long CVCF1::ObjNameToID(LPCTSTR Name)
{
long result;
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x103, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
Name);
return result;
}
long CVCF1::DefinedNameCount()
{
long result;
InvokeHelper(0x104, DISPATCH_METHOD, VT_I4, (void*)&result, NULL);
return result;
}
CString CVCF1::GetAutoFillItems(short Index)
{
CString result;
static BYTE parms[] =
VTS_I2;
InvokeHelper(0x127, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, parms,
Index);
return result;
}
void CVCF1::SetAutoFillItems(short Index, LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_I2 VTS_BSTR;
InvokeHelper(0x127, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
Index, lpszNewValue);
}
void CVCF1::ValidationRuleDlg()
{
InvokeHelper(0x105, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CVCF1::SetValidationRule(LPCTSTR Rule, LPCTSTR Text)
{
static BYTE parms[] =
VTS_BSTR VTS_BSTR;
InvokeHelper(0x106, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Rule, Text);
}
void CVCF1::GetValidationRule(BSTR* Rule, BSTR* Text)
{
static BYTE parms[] =
VTS_PBSTR VTS_PBSTR;
InvokeHelper(0x107, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Rule, Text);
}
short CVCF1::AutoFillItemsCount()
{
short result;
InvokeHelper(0x108, DISPATCH_METHOD, VT_I2, (void*)&result, NULL);
return result;
}
void CVCF1::CopyRangeEx(long nDstSheet, long nDstR1, long nDstC1, long nDstR2, long nDstC2, long hSrcSS, long nSrcSheet, long nSrcR1, long nSrcC1, long nSrcR2, long nSrcC2)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4;
InvokeHelper(0x109, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nDstSheet, nDstR1, nDstC1, nDstR2, nDstC2, hSrcSS, nSrcSheet, nSrcR1, nSrcC1, nSrcR2, nSrcC2);
}
void CVCF1::Sort(long nR1, long nC1, long nR2, long nC2, BOOL bSortByRows, const VARIANT& Keys)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_BOOL VTS_VARIANT;
InvokeHelper(0x10a, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nR1, nC1, nR2, nC2, bSortByRows, &Keys);
}
BOOL CVCF1::GetColHidden(long nCol)
{
BOOL result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x128, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, parms,
nCol);
return result;
}
void CVCF1::SetColHidden(long nCol, BOOL bNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_BOOL;
InvokeHelper(0x128, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nCol, bNewValue);
}
BOOL CVCF1::GetRowHidden(long nRow)
{
BOOL result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x129, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, parms,
nRow);
return result;
}
void CVCF1::SetRowHidden(long nRow, BOOL bNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_BOOL;
InvokeHelper(0x129, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nRow, bNewValue);
}
void CVCF1::DeleteAutoFillItems(short nIndex)
{
static BYTE parms[] =
VTS_I2;
InvokeHelper(0x10b, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nIndex);
}
void CVCF1::ODBCConnect(BSTR* pConnect, BOOL bShowErrors, short* pRetCode)
{
static BYTE parms[] =
VTS_PBSTR VTS_BOOL VTS_PI2;
InvokeHelper(0x10c, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
pConnect, bShowErrors, pRetCode);
}
void CVCF1::ODBCDisconnect()
{
InvokeHelper(0x10d, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CVCF1::ODBCQuery(BSTR* pQuery, long nRow, long nCol, BOOL bForceShowDlg, BOOL* pSetColNames, BOOL* pSetColFormats, BOOL* pSetColWidths, BOOL* pSetMaxRC, short* pRetCode)
{
static BYTE parms[] =
VTS_PBSTR VTS_I4 VTS_I4 VTS_BOOL VTS_PBOOL VTS_PBOOL VTS_PBOOL VTS_PBOOL VTS_PI2;
InvokeHelper(0x10e, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
pQuery, nRow, nCol, bForceShowDlg, pSetColNames, pSetColFormats, pSetColWidths, pSetMaxRC, pRetCode);
}
BOOL CVCF1::GetSheetSelected(long nSheet)
{
BOOL result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x12a, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, parms,
nSheet);
return result;
}
void CVCF1::SetSheetSelected(long nSheet, BOOL bNewValue)
{
static BYTE parms[] =
VTS_I4 VTS_BOOL;
InvokeHelper(0x12a, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nSheet, bNewValue);
}
void CVCF1::LaunchDesigner()
{
InvokeHelper(0x10f, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CVCF1::AboutBox()
{
InvokeHelper(0xfffffdd8, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -