📄 excel.h
字号:
double GetUsableHeight();
double GetUsableWidth();
BOOL GetUserControl();
void SetUserControl(BOOL bNewValue);
CString GetUserName_();
void SetUserName(LPCTSTR lpszNewValue);
CString GetValue();
LPDISPATCH GetVbe();
CString GetVersion();
BOOL GetVisible();
void SetVisible(BOOL bNewValue);
void Volatile(const VARIANT& Volatile);
double GetWidth();
void SetWidth(double newValue);
BOOL GetWindowsForPens();
long GetWindowState();
void SetWindowState(long nNewValue);
long GetDefaultSheetDirection();
void SetDefaultSheetDirection(long nNewValue);
long GetCursorMovement();
void SetCursorMovement(long nNewValue);
BOOL GetControlCharacters();
void SetControlCharacters(BOOL bNewValue);
BOOL GetEnableEvents();
void SetEnableEvents(BOOL bNewValue);
BOOL Wait(const VARIANT& Time);
BOOL GetExtendList();
void SetExtendList(BOOL bNewValue);
LPDISPATCH GetOLEDBErrors();
CString GetPhonetic(const VARIANT& Text);
LPDISPATCH GetCOMAddIns();
LPDISPATCH GetDefaultWebOptions();
CString GetProductCode();
CString GetUserLibraryPath();
BOOL GetAutoPercentEntry();
void SetAutoPercentEntry(BOOL bNewValue);
LPDISPATCH GetLanguageSettings();
LPDISPATCH GetAnswerWizard();
void CalculateFull();
BOOL FindFile();
long GetCalculationVersion();
BOOL GetShowWindowsInTaskbar();
void SetShowWindowsInTaskbar(BOOL bNewValue);
long GetFeatureInstall();
void SetFeatureInstall(long nNewValue);
BOOL GetReady();
LPDISPATCH GetFindFormat();
void SetRefFindFormat(LPDISPATCH newValue);
LPDISPATCH GetReplaceFormat();
void SetRefReplaceFormat(LPDISPATCH newValue);
LPDISPATCH GetUsedObjects();
long GetCalculationState();
long GetCalculationInterruptKey();
void SetCalculationInterruptKey(long nNewValue);
LPDISPATCH GetWatches();
BOOL GetDisplayFunctionToolTips();
void SetDisplayFunctionToolTips(BOOL bNewValue);
long GetAutomationSecurity();
void SetAutomationSecurity(long nNewValue);
LPDISPATCH GetFileDialog(long fileDialogType);
void CalculateFullRebuild();
BOOL GetDisplayPasteOptions();
void SetDisplayPasteOptions(BOOL bNewValue);
BOOL GetDisplayInsertOptions();
void SetDisplayInsertOptions(BOOL bNewValue);
BOOL GetGenerateGetPivotData();
void SetGenerateGetPivotData(BOOL bNewValue);
LPDISPATCH GetAutoRecover();
long GetHwnd();
long GetHinstance();
void CheckAbort(const VARIANT& KeepAbort);
LPDISPATCH GetErrorCheckingOptions();
BOOL GetAutoFormatAsYouTypeReplaceHyperlinks();
void SetAutoFormatAsYouTypeReplaceHyperlinks(BOOL bNewValue);
LPDISPATCH GetSmartTagRecognizers();
LPDISPATCH GetNewWorkbook();
LPDISPATCH GetSpellingOptions();
LPDISPATCH GetSpeech();
BOOL GetMapPaperSize();
void SetMapPaperSize(BOOL bNewValue);
BOOL GetShowStartupDialog();
void SetShowStartupDialog(BOOL bNewValue);
CString GetDecimalSeparator();
void SetDecimalSeparator(LPCTSTR lpszNewValue);
CString GetThousandsSeparator();
void SetThousandsSeparator(LPCTSTR lpszNewValue);
BOOL GetUseSystemSeparators();
void SetUseSystemSeparators(BOOL bNewValue);
LPDISPATCH GetThisCell();
LPDISPATCH GetRtd();
};
/////////////////////////////////////////////////////////////////////////////
// xlsSheets wrapper class
class xlsSheets : public COleDispatchDriver
{
public:
xlsSheets() {} // Calls COleDispatchDriver default constructor
xlsSheets(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
xlsSheets(const xlsSheets& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
// Attributes
public:
// Operations
public:
LPDISPATCH GetApplication();
long GetCreator();
LPDISPATCH GetParent();
LPDISPATCH Add(const VARIANT& Before, const VARIANT& After, const VARIANT& Count, const VARIANT& Type);
void Copy(const VARIANT& Before, const VARIANT& After);
long GetCount();
void Delete();
void FillAcrossSheets(LPDISPATCH Range, long Type);
LPDISPATCH GetItem(const VARIANT& Index);
void Move(const VARIANT& Before, const VARIANT& After);
LPUNKNOWN Get_NewEnum();
void PrintPreview(const VARIANT& EnableChanges);
void Select(const VARIANT& Replace);
LPDISPATCH GetHPageBreaks();
LPDISPATCH GetVPageBreaks();
VARIANT GetVisible();
void SetVisible(const VARIANT& newValue);
LPDISPATCH Get_Default(const VARIANT& Index);
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);
};
/////////////////////////////////////////////////////////////////////////////
// _xlsWorksheet wrapper class
class _xlsWorksheet : public COleDispatchDriver
{
public:
_xlsWorksheet() {} // Calls COleDispatchDriver default constructor
_xlsWorksheet(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
_xlsWorksheet(const _xlsWorksheet& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
// Attributes
public:
// Operations
public:
LPDISPATCH GetApplication();
long GetCreator();
LPDISPATCH GetParent();
void Activate();
void Copy(const VARIANT& Before, const VARIANT& After);
void Delete();
CString GetCodeName();
CString Get_CodeName();
void Set_CodeName(LPCTSTR lpszNewValue);
long GetIndex();
void Move(const VARIANT& Before, const VARIANT& After);
CString GetName();
void SetName(LPCTSTR lpszNewValue);
LPDISPATCH GetNext();
LPDISPATCH GetPageSetup();
LPDISPATCH GetPrevious();
void PrintPreview(const VARIANT& EnableChanges);
BOOL GetProtectContents();
BOOL GetProtectDrawingObjects();
BOOL GetProtectionMode();
BOOL GetProtectScenarios();
void Select(const VARIANT& Replace);
void Unprotect(const VARIANT& Password);
long GetVisible();
void SetVisible(long nNewValue);
LPDISPATCH GetShapes();
BOOL GetTransitionExpEval();
void SetTransitionExpEval(BOOL bNewValue);
BOOL GetAutoFilterMode();
void SetAutoFilterMode(BOOL bNewValue);
void SetBackgroundPicture(LPCTSTR Filename);
void Calculate();
BOOL GetEnableCalculation();
void SetEnableCalculation(BOOL bNewValue);
LPDISPATCH GetCells();
LPDISPATCH ChartObjects(const VARIANT& Index);
void CheckSpelling(const VARIANT& CustomDictionary, const VARIANT& IgnoreUppercase, const VARIANT& AlwaysSuggest, const VARIANT& SpellLang);
LPDISPATCH GetCircularReference();
void ClearArrows();
LPDISPATCH GetColumns();
long GetConsolidationFunction();
VARIANT GetConsolidationOptions();
VARIANT GetConsolidationSources();
BOOL GetEnableAutoFilter();
void SetEnableAutoFilter(BOOL bNewValue);
long GetEnableSelection();
void SetEnableSelection(long nNewValue);
BOOL GetEnableOutlining();
void SetEnableOutlining(BOOL bNewValue);
BOOL GetEnablePivotTable();
void SetEnablePivotTable(BOOL bNewValue);
VARIANT Evaluate(const VARIANT& Name);
VARIANT _Evaluate(const VARIANT& Name);
BOOL GetFilterMode();
void ResetAllPageBreaks();
LPDISPATCH GetNames();
LPDISPATCH OLEObjects(const VARIANT& Index);
LPDISPATCH GetOutline();
void Paste(const VARIANT& Destination, const VARIANT& Link);
LPDISPATCH PivotTables(const VARIANT& Index);
LPDISPATCH PivotTableWizard(const VARIANT& SourceType, const VARIANT& SourceData, const VARIANT& TableDestination, const VARIANT& TableName, const VARIANT& RowGrand, const VARIANT& ColumnGrand, const VARIANT& SaveData, const VARIANT& HasAutoFormat, const VARIANT& AutoPage, const VARIANT& Reserved, const VARIANT& BackgroundQuery, const VARIANT& OptimizeCache, const VARIANT& PageFieldOrder, const VARIANT& PageFieldWrapCount, const VARIANT& ReadData, const VARIANT& Connection);
LPDISPATCH GetRange(const VARIANT& Cell1, const VARIANT& Cell2);
LPDISPATCH GetRows();
LPDISPATCH Scenarios(const VARIANT& Index);
CString GetScrollArea();
void SetScrollArea(LPCTSTR lpszNewValue);
void ShowAllData();
void ShowDataForm();
double GetStandardHeight();
double GetStandardWidth();
void SetStandardWidth(double newValue);
BOOL GetTransitionFormEntry();
void SetTransitionFormEntry(BOOL bNewValue);
long GetType();
LPDISPATCH GetUsedRange();
LPDISPATCH GetHPageBreaks();
LPDISPATCH GetVPageBreaks();
LPDISPATCH GetQueryTables();
BOOL GetDisplayPageBreaks();
void SetDisplayPageBreaks(BOOL bNewValue);
LPDISPATCH GetComments();
LPDISPATCH GetHyperlinks();
void ClearCircles();
void CircleInvalid();
LPDISPATCH GetAutoFilter();
BOOL GetDisplayRightToLeft();
void SetDisplayRightToLeft(BOOL bNewValue);
LPDISPATCH GetScripts();
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);
LPDISPATCH GetTab();
LPDISPATCH GetMailEnvelope();
void SaveAs(LPCTSTR Filename, const VARIANT& FileFormat, const VARIANT& Password, const VARIANT& WriteResPassword, const VARIANT& ReadOnlyRecommended, const VARIANT& CreateBackup, const VARIANT& AddToMru, const VARIANT& TextCodepage, const VARIANT& TextVisualLayout, const VARIANT& Local);
LPDISPATCH GetCustomProperties();
LPDISPATCH GetSmartTags();
LPDISPATCH GetProtection();
void PasteSpecial(const VARIANT& Format, const VARIANT& Link, const VARIANT& DisplayAsIcon, const VARIANT& IconFileName, const VARIANT& IconIndex, const VARIANT& IconLabel, const VARIANT& NoHTMLFormatting);
void Protect(const VARIANT& Password, const VARIANT& DrawingObjects, const VARIANT& Contents, const VARIANT& Scenarios, const VARIANT& UserInterfaceOnly, const VARIANT& AllowFormattingCells, const VARIANT& AllowFormattingColumns, const VARIANT& AllowFormattingRows, const VARIANT& AllowInsertingColumns, const VARIANT& AllowInsertingRows, const VARIANT& AllowInsertingHyperlinks, const VARIANT& AllowDeletingColumns, const VARIANT& AllowDeletingRows, const VARIANT& AllowSorting, const VARIANT& AllowFiltering, const VARIANT& AllowUsingPivotTables);
};
/////////////////////////////////////////////////////////////////////////////
// _xlsWorkbook wrapper class
class _xlsWorkbook : public COleDispatchDriver
{
public:
_xlsWorkbook() {} // Calls COleDispatchDriver default constructor
_xlsWorkbook(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
_xlsWorkbook(const _xlsWorkbook& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -