📄 etcell.cpp
字号:
return result;
}
BOOL CEtCell::RunCellScript(short row, short col)
{
BOOL result;
static BYTE parms[] =
VTS_I2 VTS_I2;
InvokeHelper(0x30, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
row, col);
return result;
}
CString CEtCell::SumDirFile(LPCTSTR sRootDir, LPCTSTR etFileName, short nRow, short nCol)
{
CString result;
static BYTE parms[] =
VTS_BSTR VTS_BSTR VTS_I2 VTS_I2;
InvokeHelper(0x31, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
sRootDir, etFileName, nRow, nCol);
return result;
}
CString CEtCell::SumDirFile2(LPCTSTR sRootDir, LPCTSTR etFileName, LPCTSTR sRowCol)
{
CString result;
static BYTE parms[] =
VTS_BSTR VTS_BSTR VTS_BSTR;
InvokeHelper(0x32, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
sRootDir, etFileName, sRowCol);
return result;
}
BOOL CEtCell::SetCellFromDB(short row, short col, LPCTSTR cellStr)
{
BOOL result;
static BYTE parms[] =
VTS_I2 VTS_I2 VTS_BSTR;
InvokeHelper(0x33, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
row, col, cellStr);
return result;
}
void CEtCell::AppendRow()
{
InvokeHelper(0x34, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
short CEtCell::InsertCol(short col)
{
short result;
static BYTE parms[] =
VTS_I2;
InvokeHelper(0x35, DISPATCH_METHOD, VT_I2, (void*)&result, parms,
col);
return result;
}
void CEtCell::Redraw()
{
InvokeHelper(0x36, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CEtCell::Print(BOOL bDisplayDlg)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x37, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
bDisplayDlg);
}
void CEtCell::InsertCellImage(short nRow, short nCol, LPCTSTR ImageName, short nDisplayType)
{
static BYTE parms[] =
VTS_I2 VTS_I2 VTS_BSTR VTS_I2;
InvokeHelper(0x38, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nRow, nCol, ImageName, nDisplayType);
}
void CEtCell::InsertCellChart(short nRow, short nCol, short nChartType)
{
static BYTE parms[] =
VTS_I2 VTS_I2 VTS_I2;
InvokeHelper(0x39, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nRow, nCol, nChartType);
}
BOOL CEtCell::SetCellScript(short row, short col, LPCTSTR sScript)
{
BOOL result;
static BYTE parms[] =
VTS_I2 VTS_I2 VTS_BSTR;
InvokeHelper(0x3a, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
row, col, sScript);
return result;
}
CString CEtCell::GetCellScript(short row, short col)
{
CString result;
static BYTE parms[] =
VTS_I2 VTS_I2;
InvokeHelper(0x3b, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
row, col);
return result;
}
void CEtCell::MergeCells(short FromRow, short FromCol, short ToRow, short ToCol)
{
static BYTE parms[] =
VTS_I2 VTS_I2 VTS_I2 VTS_I2;
InvokeHelper(0x3c, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
FromRow, FromCol, ToRow, ToCol);
}
void CEtCell::MergeSelectedRange()
{
InvokeHelper(0x3d, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CEtCell::SetTableBkColor(unsigned long nColor)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x3e, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nColor);
}
void CEtCell::SetCellFinancialDetail(short row, short col)
{
static BYTE parms[] =
VTS_I2 VTS_I2;
InvokeHelper(0x3f, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
row, col);
}
void CEtCell::SetCellFinancialHead(short row, short col)
{
static BYTE parms[] =
VTS_I2 VTS_I2;
InvokeHelper(0x40, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
row, col);
}
void CEtCell::SetCellFinancialMoneyUp(short row, short col)
{
static BYTE parms[] =
VTS_I2 VTS_I2;
InvokeHelper(0x41, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
row, col);
}
void CEtCell::SetCellFormula(short row, short col, LPCTSTR sFormula)
{
static BYTE parms[] =
VTS_I2 VTS_I2 VTS_BSTR;
InvokeHelper(0x42, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
row, col, sFormula);
}
CString CEtCell::GetCellFormula(short row, short col)
{
CString result;
static BYTE parms[] =
VTS_I2 VTS_I2;
InvokeHelper(0x43, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
row, col);
return result;
}
BOOL CEtCell::Save()
{
BOOL result;
InvokeHelper(0x44, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL CEtCell::SaveAs(LPCTSTR etFileName)
{
BOOL result;
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x45, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
etFileName);
return result;
}
BOOL CEtCell::SetTableScript(LPCTSTR sScript)
{
BOOL result;
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x46, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
sScript);
return result;
}
CString CEtCell::GetTableScript()
{
CString result;
InvokeHelper(0x47, DISPATCH_METHOD, VT_BSTR, (void*)&result, NULL);
return result;
}
BOOL CEtCell::CreateTable(short nRows, short nCols)
{
BOOL result;
static BYTE parms[] =
VTS_I2 VTS_I2;
InvokeHelper(0x48, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
nRows, nCols);
return result;
}
BOOL CEtCell::DeleteRow(short row)
{
BOOL result;
static BYTE parms[] =
VTS_I2;
InvokeHelper(0x49, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
row);
return result;
}
BOOL CEtCell::DeleteCol(short col)
{
BOOL result;
static BYTE parms[] =
VTS_I2;
InvokeHelper(0x4a, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
col);
return result;
}
BOOL CEtCell::SetCellEnable(short minRow, short minCol, short maxRow, short maxCol, BOOL bEnable)
{
BOOL result;
static BYTE parms[] =
VTS_I2 VTS_I2 VTS_I2 VTS_I2 VTS_BOOL;
InvokeHelper(0x4b, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
minRow, minCol, maxRow, maxCol, bEnable);
return result;
}
BOOL CEtCell::SetCellFixed(short minRow, short minCol, short maxRow, short maxCol, BOOL bFixed)
{
BOOL result;
static BYTE parms[] =
VTS_I2 VTS_I2 VTS_I2 VTS_I2 VTS_BOOL;
InvokeHelper(0x4c, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
minRow, minCol, maxRow, maxCol, bFixed);
return result;
}
CString CEtCell::ChRowColStr(short nRow, short nCol)
{
CString result;
static BYTE parms[] =
VTS_I2 VTS_I2;
InvokeHelper(0x4d, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
nRow, nCol);
return result;
}
BOOL CEtCell::ChToRowCol(LPCTSTR sRowCol, short* nRow, short* nCol)
{
BOOL result;
static BYTE parms[] =
VTS_BSTR VTS_PI2 VTS_PI2;
InvokeHelper(0x4e, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
sRowCol, nRow, nCol);
return result;
}
BOOL CEtCell::AddCellLinkNode(short nRow, short nCol, short nFatherRow, short nFatherCol, BOOL bAdd)
{
BOOL result;
static BYTE parms[] =
VTS_I2 VTS_I2 VTS_I2 VTS_I2 VTS_BOOL;
InvokeHelper(0x4f, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
nRow, nCol, nFatherRow, nFatherCol, bAdd);
return result;
}
void CEtCell::DelCellFinancial(short nRow, short nCol)
{
static BYTE parms[] =
VTS_I2 VTS_I2;
InvokeHelper(0x50, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
nRow, nCol);
}
BOOL CEtCell::SetCellReadOnly(short nRow, short nCol, BOOL bReadOnly)
{
BOOL result;
static BYTE parms[] =
VTS_I2 VTS_I2 VTS_BOOL;
InvokeHelper(0x51, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
nRow, nCol, bReadOnly);
return result;
}
CString CEtCell::GetCellMask(short nRow, short nCol)
{
CString result;
static BYTE parms[] =
VTS_I2 VTS_I2;
InvokeHelper(0x52, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
nRow, nCol);
return result;
}
BOOL CEtCell::SetCellMask(short nRow, short nCol, LPCTSTR sMask)
{
BOOL result;
static BYTE parms[] =
VTS_I2 VTS_I2 VTS_BSTR;
InvokeHelper(0x53, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
nRow, nCol, sMask);
return result;
}
BOOL CEtCell::SetCellFocus(short row, short col)
{
BOOL result;
static BYTE parms[] =
VTS_I2 VTS_I2;
InvokeHelper(0x54, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
row, col);
return result;
}
BOOL CEtCell::ClickedInCellPlaceButton()
{
BOOL result;
InvokeHelper(0x55, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
return result;
}
CString CEtCell::GetCell2(LPCTSTR strRowCol)
{
CString result;
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x56, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
strRowCol);
return result;
}
BOOL CEtCell::SetCell2(LPCTSTR strRowCol, LPCTSTR cellStr)
{
BOOL result;
static BYTE parms[] =
VTS_BSTR VTS_BSTR;
InvokeHelper(0x57, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
strRowCol, cellStr);
return result;
}
CString CEtCell::GetAliasCell(LPCTSTR sCellAlias)
{
CString result;
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x58, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
sCellAlias);
return result;
}
BOOL CEtCell::SetAliasCell(LPCTSTR sCellAlias, LPCTSTR sCellValue)
{
BOOL result;
static BYTE parms[] =
VTS_BSTR VTS_BSTR;
InvokeHelper(0x59, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
sCellAlias, sCellValue);
return result;
}
short CEtCell::GetRecordCount()
{
short result;
InvokeHelper(0x5b, DISPATCH_METHOD, VT_I2, (void*)&result, NULL);
return result;
}
short CEtCell::GetFieldCount()
{
short result;
InvokeHelper(0x5c, DISPATCH_METHOD, VT_I2, (void*)&result, NULL);
return result;
}
BOOL CEtCell::IsRecordCell(short row, short col)
{
BOOL result;
static BYTE parms[] =
VTS_I2 VTS_I2;
InvokeHelper(0x5a, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
row, col);
return result;
}
BOOL CEtCell::IsBof()
{
BOOL result;
InvokeHelper(0x5d, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL CEtCell::IsEof()
{
BOOL result;
InvokeHelper(0x5e, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
return result;
}
CString CEtCell::GetFieldName(short Index)
{
CString result;
static BYTE parms[] =
VTS_I2;
InvokeHelper(0x5f, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
Index);
return result;
}
CString CEtCell::GetFieldValue(LPCTSTR sFieldName)
{
CString result;
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x60, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
sFieldName);
return result;
}
BOOL CEtCell::SetFieldValue(LPCTSTR sFieldName, LPCTSTR sCellValue)
{
BOOL result;
static BYTE parms[] =
VTS_BSTR VTS_BSTR;
InvokeHelper(0x61, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
sFieldName, sCellValue);
return result;
}
BOOL CEtCell::MoveFirst()
{
BOOL result;
InvokeHelper(0x62, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL CEtCell::MoveNext()
{
BOOL result;
InvokeHelper(0x63, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL CEtCell::MovePrev()
{
BOOL result;
InvokeHelper(0x64, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL CEtCell::MoveLast()
{
BOOL result;
InvokeHelper(0x65, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL CEtCell::AppendRecord()
{
BOOL result;
InvokeHelper(0x66, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL CEtCell::DeleteRecord()
{
BOOL result;
InvokeHelper(0x67, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL CEtCell::FindFirst(LPCTSTR sFind)
{
BOOL result;
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x68, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
sFind);
return result;
}
BOOL CEtCell::InsertRecord()
{
BOOL result;
InvokeHelper(0x69, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL CEtCell::SetColHeader(short col, LPCTSTR sColHeader)
{
BOOL result;
static BYTE parms[] =
VTS_I2 VTS_BSTR;
InvokeHelper(0x6a, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
col, sColHeader);
return result;
}
BOOL CEtCell::AddCellAlias(LPCTSTR strRowCol, LPCTSTR strCellAliasName, LPCTSTR strAliasDemo)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -