📄 cell2000.h
字号:
#if !defined(AFX_CELL2000_H__036D70BA_ECC1_4C00_BC5B_E9B7B59F1904__INCLUDED_)
#define AFX_CELL2000_H__036D70BA_ECC1_4C00_BC5B_E9B7B59F1904__INCLUDED_
#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
// Machine generated IDispatch wrapper class(es) created by Microsoft Visual C++
// NOTE: Do not modify the contents of this file. If this class is regenerated by
// Microsoft Visual C++, your modifications will be overwritten.
/////////////////////////////////////////////////////////////////////////////
// CCell2000 wrapper class
class CCell2000 : public CWnd
{
protected:
DECLARE_DYNCREATE(CCell2000)
public:
CLSID const& GetClsid()
{
static CLSID const clsid
= { 0x1e85c96, 0x576, 0x423c, { 0xaa, 0x35, 0x4d, 0xe0, 0x78, 0x41, 0x20, 0x88 } };
return clsid;
}
virtual BOOL Create(LPCTSTR lpszClassName,
LPCTSTR lpszWindowName, DWORD dwStyle,
const RECT& rect,
CWnd* pParentWnd, UINT nID,
CCreateContext* pContext = NULL)
{ return CreateControl(GetClsid(), lpszWindowName, dwStyle, rect, pParentWnd, nID); }
BOOL Create(LPCTSTR lpszWindowName, DWORD dwStyle,
const RECT& rect, CWnd* pParentWnd, UINT nID,
CFile* pPersist = NULL, BOOL bStorage = FALSE,
BSTR bstrLicKey = NULL)
{ return CreateControl(GetClsid(), lpszWindowName, dwStyle, rect, pParentWnd, nID,
pPersist, bStorage, bstrLicKey); }
// Attributes
public:
long GetBorder();
void SetBorder(long);
BOOL GetAllowDragdrop();
void SetAllowDragdrop(BOOL);
BOOL GetWorkbookReadonly();
void SetWorkbookReadonly(BOOL);
long GetMergecell();
void SetMergecell(long);
BOOL GetShowCellTip();
void SetShowCellTip(BOOL);
long GetNumCellColor();
void SetNumCellColor(long);
long GetStrCellColor();
void SetStrCellColor(long);
long GetFormulaCellColor();
void SetFormulaCellColor(long);
long GetRdonlyCellColor();
void SetRdonlyCellColor(long);
long GetWndBkColor();
void SetWndBkColor(long);
long GetSelectedCellColor();
void SetSelectedCellColor(long);
BOOL GetCalcManaually();
void SetCalcManaually(BOOL);
BOOL GetProtectFormula();
void SetProtectFormula(BOOL);
long GetCurCellMoveDir();
void SetCurCellMoveDir(long);
long GetExtendPaste();
void SetExtendPaste(long);
BOOL GetAllowSizeColInGrid();
void SetAllowSizeColInGrid(BOOL);
BOOL GetAllowSizeRowInGrid();
void SetAllowSizeRowInGrid(BOOL);
BOOL GetAllowCut();
void SetAllowCut(BOOL);
BOOL GetAllowCopy();
void SetAllowCopy(BOOL);
BOOL GetAllowPaste();
void SetAllowPaste(BOOL);
long GetP21();
void SetP21(long);
long GetP22();
void SetP22(long);
long GetP23();
void SetP23(long);
long GetP24();
void SetP24(long);
long GetP25();
void SetP25(long);
long GetP26();
void SetP26(long);
long GetP27();
void SetP27(long);
long GetP28();
void SetP28(long);
long GetP29();
void SetP29(long);
long GetP30();
void SetP30(long);
BOOL GetAllowExtend();
void SetAllowExtend(BOOL);
long GetVScrollWidth();
void SetVScrollWidth(long);
long GetHScrollHeight();
void SetHScrollHeight(long);
BOOL GetAllowDragChart();
void SetAllowDragChart(BOOL);
BOOL GetAllowDbClickTopLabel();
void SetAllowDbClickTopLabel(BOOL);
BOOL GetAllowDbClickSideLabel();
void SetAllowDbClickSideLabel(BOOL);
// Operations
public:
void SetCols(long cols, long sheetindex);
long GetCols(long sheetindex);
void SetRows(long rows, long sheetindex);
long GetRows(long sheetindex);
void InsertCol(long startcol, long count, long sheetindex);
void InsertRow(long startrow, long count, long sheetindex);
void DeleteCol(long startcol, long count, long sheetindex);
void DeleteRow(long startrow, long count, long sheetindex);
void InsertSheet(long start, long counts);
void DeleteSheet(long start, long count);
void SetCellString(long col, long row, long sheet, LPCTSTR strValue);
void SetCellDouble(long col, long row, long sheet, double dblValue);
CString GetCellString(long col, long row, long sheet);
double GetCellDouble(long col, long row, long sheet);
long GetCellDataType(long col, long row, long sheet);
void SetCellAlign(long col, long row, long sheet, long para);
long GetCellAlign(long col, long row, long sheet);
void SetCellTextStyle(long col, long row, long sheet, long para);
long GetCellTextStyle(long col, long row, long sheet);
void SetCellNumType(long col, long row, long sheet, long para);
long GetCellNumType(long col, long row, long sheet);
void SetCellDigital(long col, long row, long sheet, long para);
long GetCellDigital(long col, long row, long sheet);
void SetCellHideZero(long col, long row, long sheet, long para);
long GetCellHideZero(long col, long row, long sheet);
void SetCellSeparator(long col, long row, long sheet, long para);
long GetCellSeparator(long col, long row, long sheet);
void SetCellMinus(long col, long row, long sheet, long para);
long GetCellMinus(long col, long row, long sheet);
void SetCellCurrency(long col, long row, long sheet, long para);
long GetCellCurrency(long col, long row, long sheet);
void SetCellDateStyle(long col, long row, long sheet, long para);
long GetCellDateStyle(long col, long row, long sheet);
void SetCellTimeStyle(long col, long row, long sheet, long para);
long GetCellTimeStyle(long col, long row, long sheet);
void SetCellSpecial(long col, long row, long sheet, long para);
long GetCellSpecial(long col, long row, long sheet);
void SetCellTextColor(long col, long row, long sheet, long para);
long GetCellTextColor(long col, long row, long sheet);
void SetCellBackColor(long col, long row, long sheet, long para);
long GetCellBackColor(long col, long row, long sheet);
void SetCellFont(long col, long row, long sheet, long para);
long GetCellFont(long col, long row, long sheet);
void SetCellFontStyle(long col, long row, long sheet, long para);
long GetCellFontStyle(long col, long row, long sheet);
void SetCellFontSize(long col, long row, long sheet, float para);
float GetCellFontSize(long col, long row, long sheet);
void SetCellBorder(long col, long row, long sheet, long pos, long para);
long GetCellBorder(long col, long row, long sheet, long pos);
void SetCellBorderClr(long col, long row, long sheet, long pos, long para);
long GetCellBorderClr(long col, long row, long sheet, long pos);
void SetCellInput(long col, long row, long sheet, long para);
long GetCellInput(long col, long row, long sheet);
void SetCellValidChars(long col, long row, long sheet, long para);
long GetCellValidChars(long col, long row, long sheet);
void SetCellCase(long col, long row, long sheet, long para);
long GetCellCase(long col, long row, long sheet);
void SetCellNextPos(long col, long row, long sheet, long nextcol, long nextrow);
void SetCellIME(long col, long row, long sheet, long para);
long GetCellIME(long col, long row, long sheet);
void SetRowHeight(long type, long h, long row, long sheet);
void SetColWidth(long type, long w, long col, long sheet);
long GetRowHeight(long type, long row, long sheet);
long GetColWidth(long type, long col, long sheet);
long GetColBestWidth(long col);
long GetRowBestHeight(long row);
long GetLeftCol();
long GetTopRow();
void SetLeftCol(long col);
void SetTopRow(long row);
long GetCurrentCol();
long GetCurrentRow();
void MoveToCell(long col, long row);
void SetCurSheet(long sheet);
long GetCurSheet();
void CopyRange(long col1, long row1, long col2, long row2);
void CutRange(long col1, long row1, long col2, long row2);
void Paste(long col, long row, long type, long samesize, long skipblank);
void SelectRange(long col1, long row1, long col2, long row2);
void GetSelectRange(long* col1, long* row1, long* col2, long* row2);
void ClearSelection();
long IsCellSelected(long col, long row);
void CalculateAll();
void CalculateSheet(long sheet);
long IsFormulaCell(long col, long row, long sheet);
CString CalcStrFormula(LPCTSTR text, long col, long row, long sheet, long* type);
double CalcNumFormula(LPCTSTR text, long col, long row, long sheet, long* type);
void MergeCells(long col1, long row1, long col2, long row2);
void UnmergeCells(long col1, long row1, long col2, long row2);
long GetMergeRange(long col, long row, long* col1, long* row1, long* col2, long* row2);
CString GetOcxFileName();
long ImportExcelFile(LPCTSTR filename);
long ExportExcelFile(LPCTSTR filename);
long OpenFile(LPCTSTR filename, LPCTSTR password);
long SaveFile(LPCTSTR filename, long closefile);
void PrintSheet(long withdlg, long valuesheet);
void PrintPreview(long pageset, long valuesheet);
void PrintPageSetup();
long PrintSetPaper(long papersize);
long PrintGetPaper();
void PrintSetScale(double scale);
double PrintGetScale();
void PrintSetOrient(long orient);
long PrintGetOrient();
void PrintSetHead(LPCTSTR left, LPCTSTR mid, LPCTSTR right);
void PrintSetFoot(LPCTSTR left, LPCTSTR mid, LPCTSTR right);
void SetPrinter(LPCTSTR printername);
void PrintRange(long col1, long row1, long col2, long row2);
void PrintSetAlign(long horiz, long vert);
void PrintSetHeaderFont(long font, long size, long style, long color);
void PrintSetMargin(long top, long left, long bottom, long right);
void PrintSetTopTitle(long startrow, long endrow);
void PrintSetBottomTitle(long startrow, long endrow);
void PrintSetLeftTitle(long startcol, long endcol);
void PrintSetRightTitle(long startcol, long endcol);
void PrintLabel(long toplabel, long sidelabel);
void PrintPara(long Border, long singlecolor, long extendcell, long printall);
void PrintPageBreak(long breakatstart);
void PrintAdjustPageLen(long len);
void Undo();
void Redo();
void DiscardUndo();
long GetUndoState();
long GetRedoState();
void EnableUndo(long EnableUndo);
long Login(LPCTSTR username, LPCTSTR productid, LPCTSTR password);
void SetDefaultFont(long font, long size);
void ReDraw();
CString GetFontName(long fontindex);
long FindFontIndex(LPCTSTR name, long add);
long GetColor(long colorindex);
long FindColorIndex(long color, long add);
void AddPopMenu(long id, LPCTSTR text, long flags);
long OpenDatabase(LPCTSTR connectstr);
CString GetTables();
CString GetTableFields(LPCTSTR tablename);
long OpenRowset(LPCTSTR sqlstr, long type, long option);
long MoveFirst();
long MoveLast();
long GetFieldDataType(long fieldindex);
double GetFieldFloat(long fieldindex);
CString GetFieldString(long fieldindex);
long SetFieldFloat(long fieldindex, double value);
long SetFieldString(long fieldindex, LPCTSTR string);
long AddRecord();
long DeleteRecord();
long Commit();
void CloseDatabase();
void CloseRowset();
void Localize(LPCTSTR language);
void SetButtonCell(long col, long row, long sheet, LPCTSTR btntext, long action, LPCTSTR strpara, long option);
void SetRadioCell(long col, long row, long sheet, LPCTSTR list);
void SetDroplistCell(long col, long row, long sheet, LPCTSTR list, long option);
void SetDroplistCell2(long col, long row, long sheet, long recordset, long option);
void SetCheckCell(long col, long row, long sheet, LPCTSTR text, long option);
void SetSpinCell(long col, long row, long sheet, double min, double max, double step);
void SetDropwndCell(long col, long row, long sheet, long recordset, long keycol, long option);
void SetNormalCell(long col, long row, long sheet);
long GetCellType(long col, long row, long sheet);
void SetBarCodeCell(long col, long row, long sheet, long codetype, LPCTSTR codetext, long top, long left, long bottom, long right);
long RSDefCellSet(LPCTSTR name, LPCTSTR filename, LPCTSTR rangestr);
long RSDefDBSet(LPCTSTR name, LPCTSTR connectstr, LPCTSTR sqlstr);
void RSDeleteSet(long rssetindex);
long RSLinkSet(long col, long row, long sheet, long rssetindex, long linktype, long cols, long rows, long option);
void RSAccess(long col, long row, long sheet, long action);
long RSGetSetIndex(LPCTSTR rssetname);
void RSDelLink(long col, long row, long sheet);
void ChartGuide(long col1, long row1, long col2, long row2);
void SetChartCell(long col, long row, long sheet, long datac1, long datar1, long datac2, long datar2, long axisdatadir);
void SetChartAxisDir(long col, long row, long sheet, long dir);
long GetChartAxisDir(long col, long row, long sheet);
void SetChartGeneralData(long col, long row, long sheet, long ChartType, long xAxisAttr, LPCTSTR Title, LPCTSTR Foot, LPCTSTR yAxisTitle);
long GetChartDataRange(long col, long row, long sheet, long* col1, long* row1, long* col2, long* row2);
long DefineFunctions(LPCTSTR deftext);
void SetFuncGuide(LPCTSTR guidestr, long cursorpos);
void SetFuncResult(double floatvalue, LPCTSTR strValue, long type);
CString GetFuncStringPara(long index, long* isdefault);
double GetFuncDoublePara(long index, long* isdefault);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -