excel.h

vc调用电子表格实现xls文件的程序化读写操作

	void Reply();
	void ReplyAll();
	void RemoveUser(long Index);
	long GetRevisionNumber();
	void Route();
	BOOL GetRouted();
	LPDISPATCH GetRoutingSlip();
	void RunAutoMacros(long Which);
	void Save();
	void SaveCopyAs(const VARIANT& Filename);
	BOOL GetSaved();
	void SetSaved(BOOL bNewValue);
	BOOL GetSaveLinkValues();
	void SetSaveLinkValues(BOOL bNewValue);
	void SendMail(const VARIANT& Recipients, const VARIANT& Subject, const VARIANT& ReturnReceipt);
	void SendMailer(const VARIANT& FileFormat, long Priority);
	void SetLinkOnData(LPCTSTR Name, const VARIANT& Procedure);
	LPDISPATCH GetSheets();
	BOOL GetShowConflictHistory();
	void SetShowConflictHistory(BOOL bNewValue);
	LPDISPATCH GetStyles();
	void Unprotect(const VARIANT& Password);
	void UnprotectSharing(const VARIANT& SharingPassword);
	void UpdateFromFile();
	void UpdateLink(const VARIANT& Name, const VARIANT& Type);
	BOOL GetUpdateRemoteReferences();
	void SetUpdateRemoteReferences(BOOL bNewValue);
	VARIANT GetUserStatus();
	LPDISPATCH GetCustomViews();
	LPDISPATCH GetWindows();
	LPDISPATCH GetWorksheets();
	BOOL GetWriteReserved();
	CString GetWriteReservedBy();
	LPDISPATCH GetExcel4IntlMacroSheets();
	LPDISPATCH GetExcel4MacroSheets();
	BOOL GetTemplateRemoveExtData();
	void SetTemplateRemoveExtData(BOOL bNewValue);
	void HighlightChangesOptions(const VARIANT& When, const VARIANT& Who, const VARIANT& Where);
	BOOL GetHighlightChangesOnScreen();
	void SetHighlightChangesOnScreen(BOOL bNewValue);
	BOOL GetKeepChangeHistory();
	void SetKeepChangeHistory(BOOL bNewValue);
	BOOL GetListChangesOnNewSheet();
	void SetListChangesOnNewSheet(BOOL bNewValue);
	void PurgeChangeHistoryNow(long Days, const VARIANT& SharingPassword);
	void AcceptAllChanges(const VARIANT& When, const VARIANT& Who, const VARIANT& Where);
	void RejectAllChanges(const VARIANT& When, const VARIANT& Who, const VARIANT& Where);
	void ResetColors();
	LPDISPATCH GetVBProject();
	void FollowHyperlink(LPCTSTR Address, const VARIANT& SubAddress, const VARIANT& NewWindow, const VARIANT& AddHistory, const VARIANT& ExtraInfo, const VARIANT& Method, const VARIANT& HeaderInfo);
	void AddToFavorites();
	BOOL GetIsInplace();
	void 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);
	void WebPagePreview();
	LPDISPATCH GetPublishObjects();
	LPDISPATCH GetWebOptions();
	void ReloadAs(long Encoding);
	LPDISPATCH GetHTMLProject();
	BOOL GetEnvelopeVisible();
	void SetEnvelopeVisible(BOOL bNewValue);
	long GetCalculationVersion();
	BOOL GetVBASigned();
	BOOL GetShowPivotTableFieldList();
	void SetShowPivotTableFieldList(BOOL bNewValue);
	long GetUpdateLinks();
	void SetUpdateLinks(long nNewValue);
	void BreakLink(LPCTSTR Name, long Type);
	void SaveAs(const VARIANT& Filename, const VARIANT& FileFormat, const VARIANT& Password, const VARIANT& WriteResPassword, const VARIANT& ReadOnlyRecommended, const VARIANT& CreateBackup, long AccessMode, const VARIANT& ConflictResolution, 
		const VARIANT& AddToMru, const VARIANT& TextCodepage, const VARIANT& TextVisualLayout, const VARIANT& Local);
	BOOL GetEnableAutoRecover();
	void SetEnableAutoRecover(BOOL bNewValue);
	BOOL GetRemovePersonalInformation();
	void SetRemovePersonalInformation(BOOL bNewValue);
	CString GetFullNameURLEncoded();
	void CheckIn(const VARIANT& SaveChanges, const VARIANT& Comments, const VARIANT& MakePublic);
	BOOL CanCheckIn();
	void SendForReview(const VARIANT& Recipients, const VARIANT& Subject, const VARIANT& ShowMessage, const VARIANT& IncludeAttachment);
	void ReplyWithChanges(const VARIANT& ShowMessage);
	void EndReview();
	CString GetPassword();
	void SetPassword(LPCTSTR lpszNewValue);
	CString GetWritePassword();
	void SetWritePassword(LPCTSTR lpszNewValue);
	CString GetPasswordEncryptionProvider();
	CString GetPasswordEncryptionAlgorithm();
	long GetPasswordEncryptionKeyLength();
	void SetPasswordEncryptionOptions(const VARIANT& PasswordEncryptionProvider, const VARIANT& PasswordEncryptionAlgorithm, const VARIANT& PasswordEncryptionKeyLength, const VARIANT& PasswordEncryptionFileProperties);
	BOOL GetPasswordEncryptionFileProperties();
	BOOL GetReadOnlyRecommended();
	void SetReadOnlyRecommended(BOOL bNewValue);
	void Protect(const VARIANT& Password, const VARIANT& Structure, const VARIANT& Windows);
	LPDISPATCH GetSmartTagOptions();
	void RecheckSmartTags();
	LPDISPATCH GetPermission();
	LPDISPATCH GetSharedWorkspace();
	LPDISPATCH GetSync();
	void SendFaxOverInternet(const VARIANT& Recipients, const VARIANT& Subject, const VARIANT& ShowMessage);
	LPDISPATCH GetXmlNamespaces();
	LPDISPATCH GetXmlMaps();
	long XmlImport(LPCTSTR Url, LPDISPATCH* ImportMap, const VARIANT& Overwrite, const VARIANT& Destination);
	LPDISPATCH GetSmartDocument();
	LPDISPATCH GetDocumentLibraryVersions();
	BOOL GetInactiveListBorderVisible();
	void SetInactiveListBorderVisible(BOOL bNewValue);
	BOOL GetDisplayInkComments();
	void SetDisplayInkComments(BOOL bNewValue);
	long XmlImportXml(LPCTSTR Data, LPDISPATCH* ImportMap, const VARIANT& Overwrite, const VARIANT& Destination);
	void SaveAsXMLData(LPCTSTR Filename, LPDISPATCH Map);
	void ToggleFormsDesign();
};
/////////////////////////////////////////////////////////////////////////////
// Workbooks wrapper class

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

// Attributes
public:

// Operations
public:
	LPDISPATCH GetApplication();
	long GetCreator();
	LPDISPATCH GetParent();
	LPDISPATCH Add(const VARIANT& Template);
	void Close();
	long GetCount();
	LPDISPATCH GetItem(const VARIANT& Index);
	LPUNKNOWN Get_NewEnum();
	LPDISPATCH Get_Default(const VARIANT& Index);
	LPDISPATCH Open(LPCTSTR Filename, const VARIANT& UpdateLinks, const VARIANT& ReadOnly, const VARIANT& Format, const VARIANT& Password, const VARIANT& WriteResPassword, const VARIANT& IgnoreReadOnlyRecommended, const VARIANT& Origin, 
		const VARIANT& Delimiter, const VARIANT& Editable, const VARIANT& Notify, const VARIANT& Converter, const VARIANT& AddToMru, const VARIANT& Local, const VARIANT& CorruptLoad);
	void OpenText(LPCTSTR Filename, const VARIANT& Origin, const VARIANT& StartRow, const VARIANT& DataType, long TextQualifier, const VARIANT& ConsecutiveDelimiter, const VARIANT& Tab, const VARIANT& Semicolon, const VARIANT& Comma, 
		const VARIANT& Space, const VARIANT& Other, const VARIANT& OtherChar, const VARIANT& FieldInfo, const VARIANT& TextVisualLayout, const VARIANT& DecimalSeparator, const VARIANT& ThousandsSeparator, const VARIANT& TrailingMinusNumbers, 
		const VARIANT& Local);
	LPDISPATCH OpenDatabase(LPCTSTR Filename, const VARIANT& CommandText, const VARIANT& CommandType, const VARIANT& BackgroundQuery, const VARIANT& ImportDataAs);
	void CheckOut(LPCTSTR Filename);
	BOOL CanCheckOut(LPCTSTR Filename);
	LPDISPATCH OpenXML(LPCTSTR Filename, const VARIANT& Stylesheets, const VARIANT& LoadOption);
};
/////////////////////////////////////////////////////////////////////////////
// PublishObject wrapper class

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

// Attributes
public:

// Operations
public:
	LPDISPATCH GetApplication();
	long GetCreator();
	LPDISPATCH GetParent();
	void Delete();
	void Publish(const VARIANT& Create);
	CString GetDivID();
	CString GetSheet();
	long GetSourceType();
	CString GetSource();
	long GetHtmlType();
	void SetHtmlType(long nNewValue);
	CString GetTitle();
	void SetTitle(LPCTSTR lpszNewValue);
	CString GetFilename();
	void SetFilename(LPCTSTR lpszNewValue);
	BOOL GetAutoRepublish();
	void SetAutoRepublish(BOOL bNewValue);
};
/////////////////////////////////////////////////////////////////////////////
// DefaultWebOptions wrapper class

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

// Attributes
public:

// Operations
public:
	LPDISPATCH GetApplication();
	long GetCreator();
	LPDISPATCH GetParent();
	BOOL GetRelyOnCSS();
	void SetRelyOnCSS(BOOL bNewValue);
	BOOL GetSaveHiddenData();
	void SetSaveHiddenData(BOOL bNewValue);
	BOOL GetLoadPictures();
	void SetLoadPictures(BOOL bNewValue);
	BOOL GetOrganizeInFolder();
	void SetOrganizeInFolder(BOOL bNewValue);
	BOOL GetUpdateLinksOnSave();
	void SetUpdateLinksOnSave(BOOL bNewValue);
	BOOL GetUseLongFileNames();
	void SetUseLongFileNames(BOOL bNewValue);
	BOOL GetCheckIfOfficeIsHTMLEditor();
	void SetCheckIfOfficeIsHTMLEditor(BOOL bNewValue);
	BOOL GetDownloadComponents();
	void SetDownloadComponents(BOOL bNewValue);
	BOOL GetRelyOnVML();
	void SetRelyOnVML(BOOL bNewValue);
	BOOL GetAllowPNG();
	void SetAllowPNG(BOOL bNewValue);
	long GetScreenSize();
	void SetScreenSize(long nNewValue);
	long GetPixelsPerInch();
	void SetPixelsPerInch(long nNewValue);
	CString GetLocationOfComponents();
	void SetLocationOfComponents(LPCTSTR lpszNewValue);
	long GetEncoding();
	void SetEncoding(long nNewValue);
	BOOL GetAlwaysSaveInDefaultEncoding();
	void SetAlwaysSaveInDefaultEncoding(BOOL bNewValue);
	LPDISPATCH GetFonts();
	CString GetFolderSuffix();
	long GetTargetBrowser();
	void SetTargetBrowser(long nNewValue);
	BOOL GetSaveNewWebPagesAsWebArchives();
	void SetSaveNewWebPagesAsWebArchives(BOOL bNewValue);
};
/////////////////////////////////////////////////////////////////////////////
// WebOptions wrapper class

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

// Attributes
public:

// Operations
public:
	LPDISPATCH GetApplication();
	long GetCreator();
	LPDISPATCH GetParent();
	BOOL GetRelyOnCSS();
	void SetRelyOnCSS(BOOL bNewValue);
	BOOL GetOrganizeInFolder();
	void SetOrganizeInFolder(BOOL bNewValue);
	BOOL GetUseLongFileNames();
	void SetUseLongFileNames(BOOL bNewValue);
	BOOL GetDownloadComponents();
	void SetDownloadComponents(BOOL bNewValue);
	BOOL GetRelyOnVML();
	void SetRelyOnVML(BOOL bNewValue);
	BOOL GetAllowPNG();
	void SetAllowPNG(BOOL bNewValue);
	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();
	long GetTargetBrowser();
	void SetTargetBrowser(long nNewValue);
};
/////////////////////////////////////////////////////////////////////////////
// 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 GetDragToC