excel9.h

用于既有线纵坡拟合的工具,可以准确的通过最小二乘法拟合出具有最小抬落道量的坡度线

	long GetScreenSize();
	void SetScreenSize(long nNewValue);
	long GetPixelsPerInch();
	void SetPixelsPerInch(long nNewValue);
	CString GetLocationOfComponents();
	void SetLocationOfComponents(LPCTSTR lpszNewValue);
	long GetEncoding();
	void SetEncoding(long nNewValue);
	CString GetFolderSuffix();
	void UseDefaultFolderSuffix();
};
/////////////////////////////////////////////////////////////////////////////
// TreeviewControl wrapper class

class TreeviewControl : public COleDispatchDriver
{
public:
	TreeviewControl() {}		// Calls COleDispatchDriver default constructor
	TreeviewControl(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
	TreeviewControl(const TreeviewControl& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}

	// Attributes
public:

	// Operations
public:
	LPDISPATCH GetApplication();
	long GetCreator();
	LPDISPATCH GetParent();
	VARIANT GetHidden();
	void SetHidden(const VARIANT& newValue);
	VARIANT GetDrilled();
	void SetDrilled(const VARIANT& newValue);
};
/////////////////////////////////////////////////////////////////////////////
// CubeField wrapper class

class CubeField : public COleDispatchDriver
{
public:
	CubeField() {}		// Calls COleDispatchDriver default constructor
	CubeField(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
	CubeField(const CubeField& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}

	// Attributes
public:

	// Operations
public:
	LPDISPATCH GetApplication();
	long GetCreator();
	LPDISPATCH GetParent();
	long GetCubeFieldType();
	CString GetCaption();
	CString GetName();
	CString GetValue();
	long GetOrientation();
	void SetOrientation(long nNewValue);
	long GetPosition();
	void SetPosition(long nNewValue);
	LPDISPATCH GetTreeviewControl();
	BOOL GetDragToColumn();
	void SetDragToColumn(BOOL bNewValue);
	BOOL GetDragToHide();
	void SetDragToHide(BOOL bNewValue);
	BOOL GetDragToPage();
	void SetDragToPage(BOOL bNewValue);
	BOOL GetDragToRow();
	void SetDragToRow(BOOL bNewValue);
	BOOL GetDragToData();
	void SetDragToData(BOOL bNewValue);
	long GetHiddenLevels();
	void SetHiddenLevels(long nNewValue);
};
/////////////////////////////////////////////////////////////////////////////
// CubeFields wrapper class

class CubeFields : public COleDispatchDriver
{
public:
	CubeFields() {}		// Calls COleDispatchDriver default constructor
	CubeFields(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
	CubeFields(const CubeFields& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}

	// Attributes
public:

	// Operations
public:
	LPDISPATCH GetApplication();
	long GetCreator();
	LPDISPATCH GetParent();
	long GetCount();
	LPDISPATCH GetItem(const VARIANT& Index);
	LPDISPATCH Get_Default(const VARIANT& Index);
	LPUNKNOWN Get_NewEnum();
};
/////////////////////////////////////////////////////////////////////////////
// FontForExcel wrapper class

class FontForExcel : public COleDispatchDriver
{
public:
	FontForExcel() {}		// Calls COleDispatchDriver default constructor
	FontForExcel(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
	FontForExcel(const FontForExcel& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}

	// Attributes
public:

	// Operations
public:
	LPDISPATCH GetApplication();
	long GetCreator();
	LPDISPATCH GetParent();
	VARIANT GetBackground();
	void SetBackground(const VARIANT& newValue);
	VARIANT GetBold();
	void SetBold(const VARIANT& newValue);
	VARIANT GetColor();
	void SetColor(const VARIANT& newValue);
	VARIANT GetColorIndex();
	void SetColorIndex(const VARIANT& newValue);
	VARIANT GetFontStyle();
	void SetFontStyle(const VARIANT& newValue);
	VARIANT GetItalic();
	void SetItalic(const VARIANT& newValue);
	VARIANT GetName();
	void SetName(const VARIANT& newValue);
	VARIANT GetOutlineFont();
	void SetOutlineFont(const VARIANT& newValue);
	VARIANT GetShadow();
	void SetShadow(const VARIANT& newValue);
	VARIANT GetSize();
	void SetSize(const VARIANT& newValue);
	VARIANT GetStrikethrough();
	void SetStrikethrough(const VARIANT& newValue);
	VARIANT GetSubscript();
	void SetSubscript(const VARIANT& newValue);
	VARIANT GetSuperscript();
	void SetSuperscript(const VARIANT& newValue);
	VARIANT GetUnderline();
	void SetUnderline(const VARIANT& newValue);
};
/////////////////////////////////////////////////////////////////////////////
// Window wrapper class

class Window : public COleDispatchDriver
{
public:
	Window() {}		// Calls COleDispatchDriver default constructor
	Window(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
	Window(const Window& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}

	// Attributes
public:

	// Operations
public:
	LPDISPATCH GetApplication();
	long GetCreator();
	LPDISPATCH GetParent();
	VARIANT Activate();
	VARIANT ActivateNext();
	VARIANT ActivatePrevious();
	LPDISPATCH GetActiveCell();
	LPDISPATCH GetActiveChart();
	LPDISPATCH GetActivePane();
	LPDISPATCH GetActiveSheet();
	VARIANT GetCaption();
	void SetCaption(const VARIANT& newValue);
	BOOL Close(const VARIANT& SaveChanges, const VARIANT& Filename, const VARIANT& RouteWorkbook);
	BOOL GetDisplayFormulas();
	void SetDisplayFormulas(BOOL bNewValue);
	BOOL GetDisplayGridlines();
	void SetDisplayGridlines(BOOL bNewValue);
	BOOL GetDisplayHeadings();
	void SetDisplayHeadings(BOOL bNewValue);
	BOOL GetDisplayHorizontalScrollBar();
	void SetDisplayHorizontalScrollBar(BOOL bNewValue);
	BOOL GetDisplayOutline();
	void SetDisplayOutline(BOOL bNewValue);
	BOOL GetDisplayVerticalScrollBar();
	void SetDisplayVerticalScrollBar(BOOL bNewValue);
	BOOL GetDisplayWorkbookTabs();
	void SetDisplayWorkbookTabs(BOOL bNewValue);
	BOOL GetDisplayZeros();
	void SetDisplayZeros(BOOL bNewValue);
	BOOL GetEnableResize();
	void SetEnableResize(BOOL bNewValue);
	BOOL GetFreezePanes();
	void SetFreezePanes(BOOL bNewValue);
	long GetGridlineColor();
	void SetGridlineColor(long nNewValue);
	long GetGridlineColorIndex();
	void SetGridlineColorIndex(long nNewValue);
	double GetHeight();
	void SetHeight(double newValue);
	long GetIndex();
	VARIANT LargeScroll(const VARIANT& Down, const VARIANT& Up, const VARIANT& ToRight, const VARIANT& ToLeft);
	double GetLeft();
	void SetLeft(double newValue);
	LPDISPATCH NewWindow();
	CString GetOnWindow();
	void SetOnWindow(LPCTSTR lpszNewValue);
	LPDISPATCH GetPanes();
	VARIANT PrintOut(const VARIANT& From, const VARIANT& To, const VARIANT& Copies, const VARIANT& Preview, const VARIANT& ActivePrinter, const VARIANT& PrintToFile, const VARIANT& Collate, const VARIANT& PrToFileName);
	VARIANT PrintPreview(const VARIANT& EnableChanges);
	LPDISPATCH GetRangeSelection();
	long GetScrollColumn();
	void SetScrollColumn(long nNewValue);
	long GetScrollRow();
	void SetScrollRow(long nNewValue);
	VARIANT ScrollWorkbookTabs(const VARIANT& Sheets, const VARIANT& Position);
	LPDISPATCH GetSelectedSheets();
	LPDISPATCH GetSelection();
	VARIANT SmallScroll(const VARIANT& Down, const VARIANT& Up, const VARIANT& ToRight, const VARIANT& ToLeft);
	BOOL GetSplit();
	void SetSplit(BOOL bNewValue);
	long GetSplitColumn();
	void SetSplitColumn(long nNewValue);
	double GetSplitHorizontal();
	void SetSplitHorizontal(double newValue);
	long GetSplitRow();
	void SetSplitRow(long nNewValue);
	double GetSplitVertical();
	void SetSplitVertical(double newValue);
	double GetTabRatio();
	void SetTabRatio(double newValue);
	double GetTop();
	void SetTop(double newValue);
	long GetType();
	double GetUsableHeight();
	double GetUsableWidth();
	BOOL GetVisible();
	void SetVisible(BOOL bNewValue);
	LPDISPATCH GetVisibleRange();
	double GetWidth();
	void SetWidth(double newValue);
	long GetWindowNumber();
	long GetWindowState();
	void SetWindowState(long nNewValue);
	VARIANT GetZoom();
	void SetZoom(const VARIANT& newValue);
	long GetView();
	void SetView(long nNewValue);
	BOOL GetDisplayRightToLeft();
	void SetDisplayRightToLeft(BOOL bNewValue);
	long PointsToScreenPixelsX(long Points);
	long PointsToScreenPixelsY(long Points);
	LPDISPATCH RangeFromPoint(long x, long y);
	void ScrollIntoView(long Left, long Top, long Width, long Height, const VARIANT& Start);
};
/////////////////////////////////////////////////////////////////////////////
// Windows wrapper class

class Windows : public COleDispatchDriver
{
public:
	Windows() {}		// Calls COleDispatchDriver default constructor
	Windows(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
	Windows(const Windows& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}

	// Attributes
public:

	// Operations
public:
	LPDISPATCH GetApplication();
	long GetCreator();
	LPDISPATCH GetParent();
	VARIANT Arrange(long ArrangeStyle, const VARIANT& ActiveWorkbook, const VARIANT& SyncHorizontal, const VARIANT& SyncVertical);
	long GetCount();
	LPDISPATCH GetItem(const VARIANT& Index);
	LPUNKNOWN Get_NewEnum();
	LPDISPATCH Get_Default(const VARIANT& Index);
};
/////////////////////////////////////////////////////////////////////////////
// AppEvents wrapper class

class AppEvents : public COleDispatchDriver
{
public:
	AppEvents() {}		// Calls COleDispatchDriver default constructor
	AppEvents(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
	AppEvents(const AppEvents& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}

	// Attributes
public:

	// Operations
public:
	void NewWorkbook(LPDISPATCH Wb);
	void SheetSelectionChange(LPDISPATCH Sh, LPDISPATCH Target);
	void SheetBeforeDoubleClick(LPDISPATCH Sh, LPDISPATCH Target, BOOL* Cancel);
	void SheetBeforeRightClick(LPDISPATCH Sh, LPDISPATCH Target, BOOL* Cancel);
	void SheetActivate(LPDISPATCH Sh);
	void SheetDeactivate(LPDISPATCH Sh);
	void SheetCalculate(LPDISPATCH Sh);
	void SheetChange(LPDISPATCH Sh, LPDISPATCH Target);
	void WorkbookOpen(LPDISPATCH Wb);
	void WorkbookActivate(LPDISPATCH Wb);
	void WorkbookDeactivate(LPDISPATCH Wb);
	void WorkbookBeforeClose(LPDISPATCH Wb, BOOL* Cancel);
	void WorkbookBeforeSave(LPDISPATCH Wb, BOOL SaveAsUI, BOOL* Cancel);
	void WorkbookBeforePrint(LPDISPATCH Wb, BOOL* Cancel);
	void WorkbookNewSheet(LPDISPATCH Wb, LPDISPATCH Sh);
	void WorkbookAddinInstall(LPDISPATCH Wb);
	void WorkbookAddinUninstall(LPDISPATCH Wb);
	void WindowResize(LPDISPATCH Wb, LPDISPATCH Wn);
	void WindowActivate(LPDISPATCH Wb, LPDISPATCH Wn);
	void WindowDeactivate(LPDISPATCH Wb, LPDISPATCH Wn);
	void SheetFollowHyperlink(LPDISPATCH Sh, LPDISPATCH Target);
};
/////////////////////////////////////////////////////////////////////////////
// WorksheetFunction wrapper class

class WorksheetFunction : public COleDispatchDriver
{
public:
	WorksheetFunction() {}		// Calls COleDispatchDriver default constructor
	WorksheetFunction(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
	WorksheetFunction(const WorksheetFunction& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}

	// Attributes
public:

	// Operations
public:
	LPDISPATCH GetApplication();
	long GetCreator();
	LPDISPATCH GetParent();
	double Count(const VARIANT& Arg1, const VARIANT& Arg2, const VARIANT& Arg3, const VARIANT& Arg4, const VARIANT& Arg5, const VARIANT& Arg6, co