cell2000.h

实现了粗糙集理论的可辨识矩阵的生成

	long MovePrev();
	long MoveNext();
	long GetFieldCount();
	CString GetFieldName(long fieldindex);
	BOOL IsEOF();
	BOOL IsBOF();
	void FindDialog(long withReplaceButton);
	void CloseFindDialog();
	void SetCellImage(long col, long row, long sheet, long imageindex, long style, long halign, long valign);
	long AddImage(LPCTSTR imagefile);
	void SetCellHyperLink(long col, long row, long sheet, LPCTSTR celltext, LPCTSTR url, LPCTSTR tip);
	void SetCellNote(long col, long row, long sheet, LPCTSTR note);
	CString GetCellNote(long col, long row, long sheet);
	long GetTotalSheets();
	void SortCol(long assending, long col, long startcol, long startrow, long endcol, long endrow);
	void SortRow(long assending, long row, long startcol, long startrow, long endcol, long endrow);
	CString GetCellHyperLink(long col, long row, long sheet);
	void ShowSheetLabel(long show, long sheet);
	long GetSheetLabelState(long sheet);
	void ShowTopLabel(long show, long sheet);
	long GetTopLabelState(long sheet);
	void ShowSideLabel(long show, long sheet);
	long GetSideLabelState(long sheet);
	void ShowVScroll(long show, long sheet);
	long GetVScrollState(long sheet);
	void ShowHScroll(long show, long sheet);
	long GetHScrollState(long sheet);
	void ShowGridLine(long show, long sheet);
	long GetGridLineState(long sheet);
	void ShowPageBreak(long show);
	long GetPageBreakState();
	void SetSheetLabel(long sheet, LPCTSTR label);
	CString GetSheetLabel(long sheet);
	long IsModified();
	void SetDefaultRowHeight(long sheet, long type, long height);
	void SetDefaultColWidth(long sheet, long type, long width);
	void SetRowPageBreak(long row, long set);
	long IsRowPageBreak(long row);
	void SetColPageBreak(long col, long set);
	long IsColPageBreak(long col);
	void SetFixedCol(long startcol, long endcol);
	long GetFixedCol(long* startcol, long* endcol);
	void SetFixedRow(long startrow, long endrow);
	long GetFixedRow(long* startrow, long* endrow);
	void SetSelectMode(long sheet, long mode);
	long GetSelectMode(long sheet);
	void DrawGridLine(long startcol, long startrow, long endcol, long endrow, long type, long size, long colorindex);
	void ClearGridLine(long startcol, long startrow, long endcol, long endrow, long type);
	void D(long col, long row, long sheet, double dblValue);
	void S(long col, long row, long sheet, LPCTSTR strValue);
	void Invalidate();
	CString GetFileName();
	void closefile();
	long AppendSheetFromFile(LPCTSTR filename, long start, long count);
	void CopySheet(long dest, long src);
	void SetSheetIndex(long oldindex, long newindex);
	void FormulaWizard(long col, long row);
	void ProtectSheet(long index, LPCTSTR pwd);
	long UnProtectSheet(long index, LPCTSTR pwd);
	long IsSheetProtect(long index);
	void SetScreenScale(long sheetindex, double scale);
	void ResetContent();
	long ImportTextDlg();
	long ImportTextFile(long type, LPCTSTR splitstr, LPCTSTR filename, long maxcols);
	long ImportExcelDlg();
	long BacthExcelDlg();
	long ExportTextDlg();
	long ExportHtmlFile(LPCTSTR filename);
	long ExportTextFile(LPCTSTR splitstr, LPCTSTR filename, long valuestyle);
	long ExportExcelDlg();
	CString InsertSpecialCharDlg();
	BOOL InsertString(long col, long row, LPCTSTR str);
	BOOL GoTo(LPCTSTR Cell, long sheet);
	void Clear(long option);
	void Fill(long option);
	void CellPropertyDlg();
	long BatchInputFormulaDlg();
	void FormulaFillSerial();
	void SetCellFormulaShowDlg();
	void SetCellFormulaColorDlg();
	void FormulaListDlg();
	long SortStyleSheetDlg();
	long SortValueSheetDlg();
	long BlanceDlg();
	long RangeRotateDlg();
	long RangeSortDlg();
	long RangeQueryDlg();
	long RangeClassSumDlg();
	long Range3DSumDlg();
	long Range3DViewDlg();
	long Range3DEasySumDlg();
	long Range3DQueryDlg();
	void Sheet3DQueryDlg();
	void FillSerialDlg();
	long WzdGetDataFromDBDlg();
	long WzdBigFontDlg();
	long WzdLabelDlg();
	void WzdBarCodeDlg();
	long WzdChartDlg();
	void FillBetweenSheet();
	void DrawLineDlg();
	long HyperlinkDlg();
	CString CellToLabel(long col, long row);
	BOOL LabelToCell(LPCTSTR CellLabel, long* col, long* row);
	double GetScreenScale(long sheetindex);
	void DeleteImage(long index);
	void SetRowHidden(long startrow, long endrow);
	void SetRowUnhidden(long startrow, long endrow);
	void SetColHidden(long startcol, long endcol);
	void SetColUnhidden(long startcol, long endcol);
	void FormatPainter();
	void SetBackImage(long imageindex, long option, long sheetindex);
	CString GetFormula(long col, long row, long sheet);
	void SetModified(long flag);
	void DelUserFunction(LPCTSTR name);
	long GetCellDataTypeEx(LPCTSTR filename, long col, long row, long sheet);
	double GetCellDoubleEx(LPCTSTR filename, long col, long row, long sheet);
	CString GetCellStringEx(LPCTSTR filename, long col, long row, long sheet);
	void SetCellImageDlg();
	void SetGridBackImageDlg();
	long SetFormula(long col, long row, long sheet, LPCTSTR text);
	long SaveSheet(long sheetindex, LPCTSTR filename);
	void SetColorExpr(long index, LPCTSTR exprstr);
	CString GetColorExpr(long index);
	void SetCellTextColorExpr(long col, long row, long sheet, long colorexprindex);
	long GetCellTextColorExpr(long col, long row, long sheet);
	void SetCellBackColorExpr(long col, long row, long sheet, long colorexprindex);
	long GetCellBackColorExpr(long col, long row, long sheet);
	void SetMergeRangePrintAttr(long sheetindex, long repeat);
	long GetMergeRangePrintAttr(long sheetindex);
	void SetCellActive(long col, long row, long sheet, long active);
	long GetCellActive(long col, long row, long sheet);
	void SaveEdit();
	void SetShowFormula(long bShow);
	long GetShowFormula();
	long SaveToBuffer(VARIANT* data);
	long ReadFromBuffer(const VARIANT& data);
	void PrintGetTopTitle(long* startrow, long* endrow);
	void PrintGetBottomTitle(long* startrow, long* endrow);
	void PrintGetLeftTitle(long* startcol, long* endcol);
	void PrintGetRightTitle(long* startcol, long* endcol);
	void SetCellTextOrientation(long col, long row, long sheet, long textdir);
	long GetCellTextOrientation(long col, long row, long sheet);
	long GetFirstSelectedCell(long* col, long* row);
	long GetNextSelectedCell(long* col, long* row);
	long Find(LPCTSTR SearchText, long SearchDir, long SearchMode, long SearchRange, long SearchOption);
	long GetPrintPara();
	long GetPrintLabel();
	CString GetPrinter();
	CString PrintGetHeader();
	CString PrintGetFooter();
	void SetCellPrintHide(long col, long row, long sheet, long option);
	long GetCellPrintHide(long col, long row, long sheet);
	void AddRowCompages(long start, long end);
	void DeleteRowCompages(long start, long end);
	void AddColCompages(long start, long end);
	void DeleteColCompages(long start, long end);
	void RemoveRowCompages();
	void RemoveColCompages();
	void RemoveAllCompages();
	BOOL LabelToCellEx(LPCTSTR CellLabel, long* sheet, long* col, long* row);
	CString CellToLabelEx(long sheet, long col, long row);
	BOOL LabelToArea(LPCTSTR AreaLabel, long* col1, long* row1, long* col2, long* row2);
	BOOL LabelToAreaEx(LPCTSTR AreaLabel, long* sheet, long* col1, long* row1, long* col2, long* row2);
	CString AreaToLabel(long col1, long row1, long col2, long row2);
	CString AreaToLabelEx(long sheet, long col1, long row1, long col2, long row2);
	void DefineVariableDlg();
	BOOL DefineCellVar(LPCTSTR name, long col, long row, long sheet);
	BOOL DefineAreaVar(LPCTSTR name, long col1, long row1, long col2, long row2, long sheet);
	BOOL DefineDoubleVar(LPCTSTR name, double value);
	BOOL DefineStringVar(LPCTSTR name, LPCTSTR string);
	BOOL GetCellVar(LPCTSTR name, long* col, long* row, long* sheet);
	BOOL GetAreaVar(LPCTSTR name, long* col1, long* row1, long* col2, long* row2, long* sheet);
	BOOL GetDoubleVar(LPCTSTR name, double* value);
	BOOL GetStringVar(LPCTSTR name, BSTR* string);
	void DeleteVar(long index);
	BOOL EnumVar(long index, BSTR* name, long* type);
	CString FindCellVar(long col, long row, long sheet);
	BOOL FindAreaVar(long col1, long row1, long col2, long row2, long sheet, BSTR* name);
	long GetVarCount();
	long GetIndex(LPCTSTR name);
	BOOL SetChartType(long nType, long index, long sheet);
	long GetChartType(long index, long sheet);
	BOOL CreateChart(long col1, long row1, long col2, long row2, long sheet);
	BOOL DeleteChart(long index, long sheet);
	BOOL ReDrawChart(long index, long sheet);
	BOOL SetChartDataArea(long col1, long row1, long col2, long row2, long index, long sheet);
	BOOL GetChartDataArea(long* col1, long* row1, long* col2, long* row2, long index, long sheet);
	long GetChartCount(long sheet);
	BOOL SetSeriesOri(long nOri, long index, long sheet);
	long GetSeriesOri(long index, long sheet);
	BOOL SetSeriesName(LPCTSTR name, long seriesindex, long index, long sheet);
	BOOL GetSeriesName(BSTR* name, long seriesindex, long index, long sheet);
	long GetSeriesCount(long index, long sheet);
	BOOL SetXLabelArea(long col1, long row1, long col2, long row2, long index, long sheet);
	BOOL GetXLabelArea(long* col1, long* row1, long* col2, long* row2, long index, long sheet);
	void SetChartTittle(LPCTSTR strTittle, long index, long sheet);
	BOOL GetChartTittle(BSTR* strTittle, long index, long sheet);
	void SetXAxisTittle(LPCTSTR strTittle, long index, long sheet);
	BOOL GetXAxisTittle(BSTR* strTittle, long index, long sheet);
	void SetYAxisTittle(LPCTSTR strTittle, long index, long sheet);
	BOOL GetYAxisTittle(BSTR* strTittle, long index, long sheet);
	void ShowChartTittle(BOOL bShow, long index, long sheet);
	void ShowXAxisTittle(BOOL bShow, long index, long sheet);
	void ShowYAxisTittle(BOOL bShow, long index, long sheet);
	void ShowXAxis(BOOL bShow, long index, long sheet);
	void ShowYAxis(BOOL bShow, long index, long sheet);
	void ShowChartMainGrid(BOOL bShow, long index, long sheet);
	void ShowChartHypGrid(BOOL bShow, long index, long sheet);
	void ShowLegend(BOOL bShow, long index, long sheet);
	void ShowDataSign(BOOL bShow, long index, long sheet);
	void SetChartFont(LPCTSTR fontname, long fontsize, long index, long sheet);
	BOOL GetChartFont(BSTR* fontname, long* fontsize, long index, long sheet);
	void SetChartFontColor(long rgb, long index, long sheet);
	void GetChartFontColor(long* rgb, long index, long sheet);
	void MoveChartOnArea(long col1, long row1, long col2, long row2, long index, long sheet);
	void FillGridWithChart(long index, long sheet);
	void SetChartElementFont(LPCTSTR fontname, long fontsize, long elementtype, long index, long sheet);
	void GetChartElementFont(BSTR* fontname, long* fontsize, long elementtype, long index, long sheet);
	void GetChartElementFontStyle(long* underline, long* italic, long* bold, long* strikeout, long elementtype, long index, long sheet);
	void SetChartElementFontColor(long rgb, long elementtype, long index, long sheet);
	void GetChartElementFontColor(long* rgb, long elementtype, long index, long sheet);
	void SetChartBorderColor(long rgb, long elementtype, long index, long sheet);
	void GetChartBorderColor(long* rgb, long elementtype, long index, long sheet);
	void SetChartBkColor(long rgb, long elementtype, long index, long sheet);
	void GetChartBkColor(long* rgb, long elementtype, long index, long sheet);
	long SaveChartAsBitmapFile(LPCTSTR filename, long index, long sheet);
	void SetChartElementFontStyle(long underline, long italic, long bold, long strikeout, long elementtype, long index, long sheet);
	long GetTopChartIndex(long sheet);
	void PrintSetSheetOpt(long para);
	long PrintGetSheetOpt();
	void SetDataSign(LPCTSTR label, long pointIndex, long seriesindex, long chartIndex, long sheet);
	void GetDataSign(BSTR* label, long pointIndex, long seriesindex, long chartIndex, long sheet);
	BOOL ExportPdfFile(LPCTSTR filename, long sheet, long start, long count);
	BOOL ExportCSVFile(LPCTSTR filename, long sheet);
	BOOL ImportCSVFile(LPCTSTR filename, long sheet);
	void SetUseInDephi(BOOL bDephi);
	BOOL IsRowHidden(long row, long sheet);
	BOOL IsColHidden(long col, long sheet);
	BOOL InputFormulaToBar(LPCTSTR strFormula);
	long PrintGetPages(long sheet);
	BOOL OnIdle();
	long PrintGetMargin(long SideFlag);
	CString GetDroplistCellItemString(long col, long row, long sheet);
	void SetFilePassword(LPCTSTR strPassword);
	void PrintSetPaperStartNo(long StartNo);
	void PrintSetPrintCopies(short Copies);
	long PrintSetPrintRange(long PrintType, LPCTSTR PrintRange);
	void PrintPreviewEx(BOOL bCanPageSet, long valuesheet, BOOL bEmbed);
	void FindDialogEx(long withReplaceButton, LPCTSTR strFind);
	void ReplaceDialog(LPCTSTR strFind, LPCTSTR strReplace);
	void GetCellRect(long col, long row, long* left, long* top, long* right, long* bottom, BOOL bWithJoin, BOOL bIntersect);
	void ClearArea(long startcol, long startrow, long endcol, long endrow, long sheet, long option);
	void PrintRangeEx(long col1, long row1, long col2, long row2, long sheet);
	void GetPrintRangeEx(long sheet, long* col1, long* row1, long* col2, long* row2);
	void PrintPageSetupEx(long sheet, long iSelectPage);
	long GetVarType(LPCTSTR name);
	void SetCurSheetEx(LPCTSTR SheetName);
	long GetSheetIndex(LPCTSTR SheetName);
	long InsertSheetFromFile(LPCTSTR filename, long start, long count, long IntStart);
	long InsertSheetToFile(long start, long count, LPCTSTR filename, short IntStart);
	long AppendSheetToFile(long start, long count, LPCTSTR filename);
	BOOL CopySheetFromFile(LPCTSTR filename, long sheetFrom, long sheetTo);
	void SetGridCursor(long Section, long TypeCursor);
	CString GetCellTip(long col, long row, long sheet);
	void SetCellTip(long col, long row, long sheet, LPCTSTR strTip);
	void StartEdit(long col, long row);
	BOOL CopySheetToFile(LPCTSTR filename, long sheetFrom, long sheetTo);
	BOOL SaveImageFile(long imageindex, LPCTSTR imagefile);
	void ShowFixedLines(long show, long sheet);
	long GetFixedLinesState(long sheet);
	BOOL PrintSetDefaultPrinter();
	CString GetDefaultFontName();
	long GetDefaultFontSize();
	long GetCellImageIndex(long col, long row, long sheet);
	CString SaveToExcelXML();
	long PrintGetHAlign(long sheet);
	long PrintGetVAlign(long sheet);
	long PrintGetPaperStartNo(long sheet);
	long PrintGetPageBreak(long sheet);
	long PrintGetPrintArea(long tagSide, long sheet);
	long PrintGetAdjustPageLen(long sheet);
	BOOL ReadDBFFile(LPCTSTR filename);
	long PrintGetPaperWidth(long sheet);
	long PrintGetPaperHeight(long sheet);
	void PrintSetCustomPaper(long width, long height, long sheet);
	void AboutBox();
};

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

#endif // !defined(AFX_CELL2000_H__036D70BA_ECC1_4C00_BC5B_E9B7B59F1904__INCLUDED_)