📄 cell2000.cpp
字号:
VTS_I4 VTS_I4 VTS_I4 VTS_I4;
InvokeHelper(0x71, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
col1, row1, col2, row2);
}
void CCell2000::Paste(long col, long row, long type, long samesize, long skipblank)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4;
InvokeHelper(0x72, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
col, row, type, samesize, skipblank);
}
void CCell2000::SelectRange(long col1, long row1, long col2, long row2)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4 VTS_I4;
InvokeHelper(0x73, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
col1, row1, col2, row2);
}
void CCell2000::GetSelectRange(long* col1, long* row1, long* col2, long* row2)
{
static BYTE parms[] =
VTS_PI4 VTS_PI4 VTS_PI4 VTS_PI4;
InvokeHelper(0x74, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
col1, row1, col2, row2);
}
void CCell2000::ClearSelection()
{
InvokeHelper(0x75, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
long CCell2000::IsCellSelected(long col, long row)
{
long result;
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0x76, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
col, row);
return result;
}
void CCell2000::CalculateAll()
{
InvokeHelper(0x77, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CCell2000::CalculateSheet(long sheet)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x78, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
sheet);
}
long CCell2000::IsFormulaCell(long col, long row, long sheet)
{
long result;
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4;
InvokeHelper(0x79, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
col, row, sheet);
return result;
}
CString CCell2000::CalcStrFormula(LPCTSTR text, long col, long row, long sheet, long* type)
{
CString result;
static BYTE parms[] =
VTS_BSTR VTS_I4 VTS_I4 VTS_I4 VTS_PI4;
InvokeHelper(0x7a, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
text, col, row, sheet, type);
return result;
}
double CCell2000::CalcNumFormula(LPCTSTR text, long col, long row, long sheet, long* type)
{
double result;
static BYTE parms[] =
VTS_BSTR VTS_I4 VTS_I4 VTS_I4 VTS_PI4;
InvokeHelper(0x7b, DISPATCH_METHOD, VT_R8, (void*)&result, parms,
text, col, row, sheet, type);
return result;
}
void CCell2000::MergeCells(long col1, long row1, long col2, long row2)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4 VTS_I4;
InvokeHelper(0x7c, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
col1, row1, col2, row2);
}
void CCell2000::UnmergeCells(long col1, long row1, long col2, long row2)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4 VTS_I4;
InvokeHelper(0x7d, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
col1, row1, col2, row2);
}
long CCell2000::GetMergeRange(long col, long row, long* col1, long* row1, long* col2, long* row2)
{
long result;
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_PI4 VTS_PI4 VTS_PI4 VTS_PI4;
InvokeHelper(0x7e, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
col, row, col1, row1, col2, row2);
return result;
}
CString CCell2000::GetOcxFileName()
{
CString result;
InvokeHelper(0x7f, DISPATCH_METHOD, VT_BSTR, (void*)&result, NULL);
return result;
}
long CCell2000::ImportExcelFile(LPCTSTR filename)
{
long result;
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x80, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
filename);
return result;
}
long CCell2000::ExportExcelFile(LPCTSTR filename)
{
long result;
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x81, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
filename);
return result;
}
long CCell2000::OpenFile(LPCTSTR filename, LPCTSTR password)
{
long result;
static BYTE parms[] =
VTS_BSTR VTS_BSTR;
InvokeHelper(0x82, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
filename, password);
return result;
}
long CCell2000::SaveFile(LPCTSTR filename, long closefile)
{
long result;
static BYTE parms[] =
VTS_BSTR VTS_I4;
InvokeHelper(0x83, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
filename, closefile);
return result;
}
void CCell2000::PrintSheet(long withdlg, long valuesheet)
{
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0x84, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
withdlg, valuesheet);
}
void CCell2000::PrintPreview(long pageset, long valuesheet)
{
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0x85, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
pageset, valuesheet);
}
void CCell2000::PrintPageSetup()
{
InvokeHelper(0x86, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
long CCell2000::PrintSetPaper(long papersize)
{
long result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x87, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
papersize);
return result;
}
long CCell2000::PrintGetPaper()
{
long result;
InvokeHelper(0x88, DISPATCH_METHOD, VT_I4, (void*)&result, NULL);
return result;
}
void CCell2000::PrintSetScale(double scale)
{
static BYTE parms[] =
VTS_R8;
InvokeHelper(0x89, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
scale);
}
double CCell2000::PrintGetScale()
{
double result;
InvokeHelper(0x8a, DISPATCH_METHOD, VT_R8, (void*)&result, NULL);
return result;
}
void CCell2000::PrintSetOrient(long orient)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x8b, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
orient);
}
long CCell2000::PrintGetOrient()
{
long result;
InvokeHelper(0x8c, DISPATCH_METHOD, VT_I4, (void*)&result, NULL);
return result;
}
void CCell2000::PrintSetHead(LPCTSTR left, LPCTSTR mid, LPCTSTR right)
{
static BYTE parms[] =
VTS_BSTR VTS_BSTR VTS_BSTR;
InvokeHelper(0x8d, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
left, mid, right);
}
void CCell2000::PrintSetFoot(LPCTSTR left, LPCTSTR mid, LPCTSTR right)
{
static BYTE parms[] =
VTS_BSTR VTS_BSTR VTS_BSTR;
InvokeHelper(0x8e, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
left, mid, right);
}
void CCell2000::SetPrinter(LPCTSTR printername)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x8f, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
printername);
}
void CCell2000::PrintRange(long col1, long row1, long col2, long row2)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4 VTS_I4;
InvokeHelper(0x90, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
col1, row1, col2, row2);
}
void CCell2000::PrintSetAlign(long horiz, long vert)
{
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0x91, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
horiz, vert);
}
void CCell2000::PrintSetHeaderFont(long font, long size, long style, long color)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4 VTS_I4;
InvokeHelper(0x92, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
font, size, style, color);
}
void CCell2000::PrintSetMargin(long top, long left, long bottom, long right)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4 VTS_I4;
InvokeHelper(0x93, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
top, left, bottom, right);
}
void CCell2000::PrintSetTopTitle(long startrow, long endrow)
{
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0x94, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
startrow, endrow);
}
void CCell2000::PrintSetBottomTitle(long startrow, long endrow)
{
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0x95, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
startrow, endrow);
}
void CCell2000::PrintSetLeftTitle(long startcol, long endcol)
{
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0x96, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
startcol, endcol);
}
void CCell2000::PrintSetRightTitle(long startcol, long endcol)
{
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0x97, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
startcol, endcol);
}
void CCell2000::PrintLabel(long toplabel, long sidelabel)
{
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0x98, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
toplabel, sidelabel);
}
void CCell2000::PrintPara(long Border, long singlecolor, long extendcell, long printall)
{
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_I4 VTS_I4;
InvokeHelper(0x99, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Border, singlecolor, extendcell, printall);
}
void CCell2000::PrintPageBreak(long breakatstart)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x9a, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
breakatstart);
}
void CCell2000::PrintAdjustPageLen(long len)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x9b, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
len);
}
void CCell2000::Undo()
{
InvokeHelper(0x9c, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CCell2000::Redo()
{
InvokeHelper(0x9d, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void CCell2000::DiscardUndo()
{
InvokeHelper(0x9e, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
long CCell2000::GetUndoState()
{
long result;
InvokeHelper(0x9f, DISPATCH_METHOD, VT_I4, (void*)&result, NULL);
return result;
}
long CCell2000::GetRedoState()
{
long result;
InvokeHelper(0xa0, DISPATCH_METHOD, VT_I4, (void*)&result, NULL);
return result;
}
void CCell2000::EnableUndo(long EnableUndo)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0xa1, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
EnableUndo);
}
long CCell2000::Login(LPCTSTR username, LPCTSTR productid, LPCTSTR password)
{
long result;
static BYTE parms[] =
VTS_BSTR VTS_BSTR VTS_BSTR;
InvokeHelper(0xa2, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
username, productid, password);
return result;
}
void CCell2000::SetDefaultFont(long font, long size)
{
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0xa3, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
font, size);
}
void CCell2000::ReDraw()
{
InvokeHelper(0xa4, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
CString CCell2000::GetFontName(long fontindex)
{
CString result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0xa5, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
fontindex);
return result;
}
long CCell2000::FindFontIndex(LPCTSTR name, long add)
{
long result;
static BYTE parms[] =
VTS_BSTR VTS_I4;
InvokeHelper(0xa6, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
name, add);
return result;
}
long CCell2000::GetColor(long colorindex)
{
long result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0xa7, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
colorindex);
return result;
}
long CCell2000::FindColorIndex(long color, long add)
{
long result;
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0xa8, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
color, add);
return result;
}
void CCell2000::AddPopMenu(long id, LPCTSTR text, long flags)
{
static BYTE parms[] =
VTS_I4 VTS_BSTR VTS_I4;
InvokeHelper(0xa9, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
id, text, flags);
}
long CCell2000::OpenDatabase(LPCTSTR connectstr)
{
long result;
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0xaa, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
connectstr);
return result;
}
CString CCell2000::GetTables()
{
CString result;
InvokeHelper(0xab, DISPATCH_METHOD, VT_BSTR, (void*)&result, NULL);
return result;
}
CString CCell2000::GetTableFields(LPCTSTR tablename)
{
CString result;
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0xac, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
tablename);
return result;
}
long CCell2000::OpenRowset(LPCTSTR sqlstr, long type, long option)
{
long result;
static BYTE parms[] =
VTS_BSTR VTS_I4 VTS_I4;
InvokeHelper(0xad, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
sqlstr, type, option);
return result;
}
long CCell2000::MoveFirst()
{
long result;
InvokeHelper(0xae, DISPATCH_METHOD, VT_I4, (void*)&result, NULL);
return result;
}
long CCell2000::MoveLast()
{
long result;
InvokeHelper(0xaf, DISPATCH_METHOD, VT_I4, (void*)&result, NULL);
return result;
}
long CCell2000::GetFieldDataType(long fieldindex)
{
long result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0xb0, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
fieldindex);
return result;
}
double CCell2000::GetFieldFloat(long fieldindex)
{
double result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0xb1, DISPATCH_METHOD, VT_R8, (void*)&result, parms,
fieldindex);
return result;
}
CString CCell2000::GetFieldString(long fieldindex)
{
CString result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0xb2, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
fieldindex);
return result;
}
long CCell2000::SetFieldFloat(long fieldindex, double value)
{
long result;
static BYTE parms[] =
VTS_I4 VTS_R8;
InvokeHelper(0xb3, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
fieldindex, value);
return result;
}
long CCell2000::SetFieldString(long fieldindex, LPCTSTR string)
{
long result;
static BYTE parms[] =
VTS_I4 VTS_BSTR;
InvokeHelper(0xb4, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
fieldindex, string);
return result;
}
long CCell2000::AddRecord()
{
long result;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -