#if !defined(AFX_ETCELL_H__18A7C0D1_2A0B_45E3_A06C_1EA4863FC8A7__INCLUDED_)
#define AFX_ETCELL_H__18A7C0D1_2A0B_45E3_A06C_1EA4863FC8A7__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.


// Dispatch interfaces referenced by this interface
class COleFont;

/////////////////////////////////////////////////////////////////////////////
// CEtCell wrapper class

class CEtCell : public CWnd
{
protected:
	DECLARE_DYNCREATE(CEtCell)
public:
	CLSID const& GetClsid()
	{
		static CLSID const clsid
			= { 0x20423c49, 0x2276, 0x43d5, { 0xbc, 0x6d, 0x53, 0x82, 0x9c, 0x41, 0xae, 0xad } };
		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:
	CString GetFileName();
	void SetFileName(LPCTSTR);
	BOOL GetCanSizeRow();
	void SetCanSizeRow(BOOL);
	BOOL GetCanSizeCol();
	void SetCanSizeCol(BOOL);
	BOOL GetRuler();
	void SetRuler(BOOL);
	short GetRows();
	void SetRows(short);
	short GetCols();
	void SetCols(short);
	short GetNotScrollRows();
	void SetNotScrollRows(short);
	short GetNotScrollCols();
	void SetNotScrollCols(short);
	CString GetScript();
	void SetScript(LPCTSTR);
	BOOL GetPrintCellBackColor();
	void SetPrintCellBackColor(BOOL);
	BOOL GetFixedCellSelect();
	void SetFixedCellSelect(BOOL);
	BOOL GetMultiSelect();
	void SetMultiSelect(BOOL);
	CString GetPrintHeaderText();
	void SetPrintHeaderText(LPCTSTR);
	BOOL GetPrintHeaderLine();
	void SetPrintHeaderLine(BOOL);
	CString GetPrintFooterText();
	void SetPrintFooterText(LPCTSTR);
	BOOL GetPrintFooterLine();
	void SetPrintFooterLine(BOOL);
	BOOL GetPrintPageNo();
	void SetPrintPageNo(BOOL);
	BOOL GetPrintEtCellBackColor();
	void SetPrintEtCellBackColor(BOOL);
	BOOL GetDatabaseActive();
	void SetDatabaseActive(BOOL);
	CString GetConnectionString();
	void SetConnectionString(LPCTSTR);
	CString GetDatabaseTableName();
	void SetDatabaseTableName(LPCTSTR);
	BOOL GetBorder3D();
	void SetBorder3D(BOOL);
	BOOL GetReadOnly();
	void SetReadOnly(BOOL);
	BOOL GetRunStartScript();
	void SetRunStartScript(BOOL);
	CString GetDefaultLibFileName();
	void SetDefaultLibFileName(LPCTSTR);
	BOOL GetPrintDirectH();
	void SetPrintDirectH(BOOL);
	BOOL GetPrintFullPage();
	void SetPrintFullPage(BOOL);
	short GetFocusCellShape();
	void SetFocusCellShape(short);
	COleFont GetDefaultFont();
	void SetDefaultFont(LPDISPATCH);

// Operations
public:
	BOOL PrintPreview();
	short InsertRow(short row);
	BOOL SetCell(short row, short col, LPCTSTR cellStr);
	CString GetCell(short row, short col);
	BOOL SetCellColor(short row, short col, unsigned long nColor);
	BOOL SetCellBkColor(short row, short col, unsigned long nColor);
	short GetRowCount();
	short GetColCount();
	BOOL ShellExec(LPCTSTR exeFileName, LPCTSTR sParam);
	BOOL ShellWeb(LPCTSTR webHost);
	BOOL OpenDoc(LPCTSTR FileName);
	CString GetCurFileName();
	short GetCurRow();
	short GetCurCol();
	BOOL OpenFileCell(LPCTSTR FileName);
	CString GetFileCell(short row, short col);
	BOOL CloseFileCell();
	BOOL RunCellScript(short row, short col);
	CString SumDirFile(LPCTSTR sRootDir, LPCTSTR etFileName, short nRow, short nCol);
	CString SumDirFile2(LPCTSTR sRootDir, LPCTSTR etFileName, LPCTSTR sRowCol);
	BOOL SetCellFromDB(short row, short col, LPCTSTR cellStr);
	void AppendRow();
	short InsertCol(short col);
	void Redraw();
	void Print(BOOL bDisplayDlg);
	void InsertCellImage(short nRow, short nCol, LPCTSTR ImageName, short nDisplayType);
	void InsertCellChart(short nRow, short nCol, short nChartType);
	BOOL SetCellScript(short row, short col, LPCTSTR sScript);
	CString GetCellScript(short row, short col);
	void MergeCells(short FromRow, short FromCol, short ToRow, short ToCol);
	void MergeSelectedRange();
	void SetTableBkColor(unsigned long nColor);
	void SetCellFinancialDetail(short row, short col);
	void SetCellFinancialHead(short row, short col);
	void SetCellFinancialMoneyUp(short row, short col);
	void SetCellFormula(short row, short col, LPCTSTR sFormula);
	CString GetCellFormula(short row, short col);
	BOOL Save();
	BOOL SaveAs(LPCTSTR etFileName);
	BOOL SetTableScript(LPCTSTR sScript);
	CString GetTableScript();
	BOOL CreateTable(short nRows, short nCols);
	BOOL DeleteRow(short row);
	BOOL DeleteCol(short col);
	BOOL SetCellEnable(short minRow, short minCol, short maxRow, short maxCol, BOOL bEnable);
	BOOL SetCellFixed(short minRow, short minCol, short maxRow, short maxCol, BOOL bFixed);
	CString ChRowColStr(short nRow, short nCol);
	BOOL ChToRowCol(LPCTSTR sRowCol, short* nRow, short* nCol);
	BOOL AddCellLinkNode(short nRow, short nCol, short nFatherRow, short nFatherCol, BOOL bAdd);
	void DelCellFinancial(short nRow, short nCol);
	BOOL SetCellReadOnly(short nRow, short nCol, BOOL bReadOnly);
	CString GetCellMask(short nRow, short nCol);
	BOOL SetCellMask(short nRow, short nCol, LPCTSTR sMask);
	BOOL SetCellFocus(short row, short col);
	BOOL ClickedInCellPlaceButton();
	CString GetCell2(LPCTSTR strRowCol);
	BOOL SetCell2(LPCTSTR strRowCol, LPCTSTR cellStr);
	CString GetAliasCell(LPCTSTR sCellAlias);
	BOOL SetAliasCell(LPCTSTR sCellAlias, LPCTSTR sCellValue);
	short GetRecordCount();
	short GetFieldCount();
	BOOL IsRecordCell(short row, short col);
	BOOL IsBof();
	BOOL IsEof();
	CString GetFieldName(short Index);
	CString GetFieldValue(LPCTSTR sFieldName);
	BOOL SetFieldValue(LPCTSTR sFieldName, LPCTSTR sCellValue);
	BOOL MoveFirst();
	BOOL MoveNext();
	BOOL MovePrev();
	BOOL MoveLast();
	BOOL AppendRecord();
	BOOL DeleteRecord();
	BOOL FindFirst(LPCTSTR sFind);
	BOOL InsertRecord();
	BOOL SetColHeader(short col, LPCTSTR sColHeader);
	BOOL AddCellAlias(LPCTSTR strRowCol, LPCTSTR strCellAliasName, LPCTSTR strAliasDemo);
	CString GetCellAlias(short row, short col);
	BOOL DeleteCellAlias(LPCTSTR strCellAliasName);
	BOOL SetEtRecordRange(LPCTSTR strStartRowCol, LPCTSTR strEndRowCol);
	BOOL AddFieldName(short nCol, LPCTSTR strFieldName, LPCTSTR strFieldDemo);
	BOOL DeleteFieldName(LPCTSTR strFieldName);
	BOOL SetAliasCellTransParent(LPCTSTR strCellAliasName);
	BOOL SetCellTransParent(LPCTSTR strRowCol);
	BOOL SetCellTransParent1(short row, short col);
	BOOL EditCellAlias(LPCTSTR strCellAliasName, LPCTSTR strNewCellAliasName);
	BOOL EditFieldName(LPCTSTR strFieldName, LPCTSTR strNewFieldName);
	BOOL Update();
	BOOL Login(LPCTSTR UserID, LPCTSTR ProductID, LPCTSTR Password);
	BOOL GetCellRect(short row, short col, short* x, short* y, short* width, short* height);
	BOOL ADOFieldLinkToEtField(LPCTSTR ADOFieldName, LPCTSTR EtFieldName);
	BOOL MoveTo(short nRecordID);
	BOOL UnMergedCell(short row, short col);
	BOOL UnMergedAliasCell(LPCTSTR sAliasName);
	short GetCellType(short row, short col);
	BOOL SetCellRightLineWidth(short row, short col, short width);
	BOOL SetCellRightLineColor(short row, short col, unsigned long color);
	BOOL SetCellBottomLineWidth(short row, short col, short width);
	BOOL SetCellBottomLineColor(short row, short col, unsigned long color);
	BOOL SetCellLineWidth(short row, short col, short width);
	BOOL SetCellLineColor(short row, short col, unsigned long color);
	BOOL RunLibFunction(LPCTSTR sFunctionName);
	BOOL SetRangeBorder(LPCTSTR sStartRowCol, LPCTSTR sEndRowCol, short nType);
	BOOL SetCellAlign(short row, short col, short Align);
	BOOL LoadLib(LPCTSTR sLibFileName);
	BOOL GetSelectRange(BSTR* spStartRowCol, BSTR* spEndRowCol);
	CString GetSelectStartCell();
	CString GetSelectEndCell();
	BOOL AddLinkChartCell(LPCTSTR sChartCell, LPCTSTR sLinkChartCell, LPCTSTR sDisplayLable);
	double CalcFormula(LPCTSTR sFormula);
	BOOL DeleteLinkChartCell(LPCTSTR sChartCell, LPCTSTR sLinkChartCell);
	CString GetChartLinkCells(LPCTSTR sChartCell);
	BOOL EditLinkChartCellLable(LPCTSTR sChartCell, LPCTSTR sLinkChartCell, LPCTSTR sDisplayLable);
	BOOL SetPrintZoom(short nPrintZoomPerNum);
	BOOL SetCellFont(short row, short col, LPCTSTR sFontName, short nSize);
	BOOL SetCellFontStyle(short row, short col, short nStyle);
	CString GetAliasRowColStr(LPCTSTR sAliasName);
	BOOL HttpGetFile(LPCTSTR sURL, LPCTSTR sSaveFile);
	CString HttpPost(LPCTSTR sURL, LPCTSTR sFormData);
	BOOL HttpPostSaveToFile(LPCTSTR sURL, LPCTSTR sFormData, LPCTSTR sSaveFileName);
	BOOL HttpPutFile(LPCTSTR sLocalFile, LPCTSTR sHost, LPCTSTR sHostFileName);
	BOOL RunScript(LPCTSTR sScript);
	short GetFieldCol(LPCTSTR sFieldName);
	short GetColWidth(short nCol);
	void SetColWidth(short nCol, short nNewWidth);
	short GetRowHeight(short nRow);
	void SetRowHeight(short nRow, short nNewHeight);
	BOOL AddInCellListButton(short row, short col);
	BOOL DeleteInCellListButton(short row, short col);
	BOOL SetCellType(short row, short col, short nType);
	void EditCopy();
	void EditCut();
	void EditPaste();
	short ChToRow(LPCTSTR sRowCol);
	short ChToCol(LPCTSTR sRowCol);
	unsigned long ShowDlgColor(unsigned long defColor);
	BOOL ShowDlgFont(LPCTSTR sFontName, short nFontSize, unsigned long cFontColor);
	CString GetDlgFontName();
	short GetDlgFontSize();
	unsigned long GetDlgFontColor();
	BOOL GetDlgFontBold();
	CString GetSystemAllFontName();
	unsigned long GetTableBkColor();
	unsigned long GetCellBkColor(short row, short col);
	short GetCellFontStyle(short row, short col);
	BOOL GetCellFixed(short row, short col);
	BOOL ImportXML(LPCTSTR lpXML);
	CString ExportXML(short nExportType);
	BOOL RunWebScriptFunc(LPCTSTR strFunctionName, LPCTSTR strParam);
	short GetAliasCount();
	CString GetAliasName(short Index);
	CString GetAliasRowCol(short Index);
	CString GetFieldColStr(short Index);
	CString GetEtRecordRangeStartCell();
	CString GetEtRecordRangeEndCell();
	BOOL DeleteLinkToEtField(LPCTSTR EtFieldName);
	CString ChToColStr(short col);
	CString ShowDlgOpenFile(LPCTSTR lpFilePath, LPCTSTR szFilters, BOOL bOpenOrSave);
	void SetSingleRowSelection(BOOL m_bSingleRowSelection);
	CString GetItemString(short nIndex, short nColumn);
	void SetPrintMargin(short nLeft, short nTop, short nRight, short nBottom);
	void SetPrintLine(BOOL bPrintLine);
	void SetPrintPaperSize(short dmPaperSize, short nPaperHeight, short nPaperWidth);
	BOOL FindNext();
	BOOL FindPrevious();
	BOOL FindLast();
	CString HttpGetText(LPCTSTR sURL);
	unsigned long GetCellColor(short row, short col);
	BOOL AddNotPrintCell(short row, short col);
	BOOL DeleteAllNotPrintCell();
	void SetCellNumType(short row, short col, short nType, short nDotNum, LPCTSTR sParam);
	BOOL SetSupportNotPrint(BOOL bSupported);
	BOOL SetGroupRange(short nStartRow, short nEndRow);
	BOOL GetGroupRange(short* nStartRow, short* nEndRow);
	BOOL SetGroupPrintStyle(long nPrintStyle);
	long GetGroupPrintStyle();
	BOOL SetCellURLScript(short row, short col, LPCTSTR strScript, short nScriptType);
	BOOL SetCellURL(short row, short col, LPCTSTR strURL, LPCTSTR strTip);
	CString GetCellURL(short row, short col);
	CString GetCellURLScript(short row, short col);
	BOOL SetCellURLWindow(short row, short col, short nOpenIEType, short nOpenIEStyle, short nIETop, short nIELeft, short nIEHeight, short nIEWidth);
	short GetCurRecordRow();
	BOOL PopupMenu();
	BOOL AddMenu(LPCTSTR strName, LPCTSTR strScript, short nType);
	void DeleteAllMenu();
	BOOL EnableMenu(LPCTSTR strName, BOOL bEnabled);
	BOOL IsCellMerge(short row, short col);
	BOOL SetAutoAdjustTable(short bAutoRowColSize);
	void AboutBox();
};

//{{AFX_INSERT_LOCATION}}
// Microsoft Visual C++ will insert additional declarations immediately before the previous line.

#endif // !defined(AFX_ETCELL_H__18A7C0D1_2A0B_45E3_A06C_1EA4863FC8A7__INCLUDED_)