📄 excel9.h
字号:
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);
};
/////////////////////////////////////////////////////////////////////////////
// _Chart wrapper class
class _Chart : public COleDispatchDriver
{
public:
_Chart() {} // Calls COleDispatchDriver default constructor
_Chart(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
_Chart(const _Chart& 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);
void Protect(const VARIANT& Password, const VARIANT& DrawingObjects, const VARIANT& Contents, const VARIANT& Scenarios, const VARIANT& UserInterfaceOnly);
BOOL GetProtectContents();
BOOL GetProtectDrawingObjects();
BOOL GetProtectionMode();
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);
void Select(const VARIANT& Replace);
void Unprotect(const VARIANT& Password);
long GetVisible();
void SetVisible(long nNewValue);
LPDISPATCH GetShapes();
void ApplyDataLabels(long Type, const VARIANT& LegendKey, const VARIANT& AutoText, const VARIANT& HasLeaderLines);
LPDISPATCH GetArea3DGroup();
LPDISPATCH AreaGroups(const VARIANT& Index);
BOOL GetAutoScaling();
void SetAutoScaling(BOOL bNewValue);
LPDISPATCH Axes(const VARIANT& Type, long AxisGroup);
void SetBackgroundPicture(LPCTSTR Filename);
LPDISPATCH GetBar3DGroup();
LPDISPATCH BarGroups(const VARIANT& Index);
LPDISPATCH GetChartArea();
LPDISPATCH ChartGroups(const VARIANT& Index);
LPDISPATCH ChartObjects(const VARIANT& Index);
LPDISPATCH GetChartTitle();
void ChartWizard(const VARIANT& Source, const VARIANT& Gallery, const VARIANT& Format, const VARIANT& PlotBy, const VARIANT& CategoryLabels, const VARIANT& SeriesLabels, const VARIANT& HasLegend, const VARIANT& Title, const VARIANT& CategoryTitle, const VARIANT& ValueTitle, const VARIANT& ExtraTitle);
void CheckSpelling(const VARIANT& CustomDictionary, const VARIANT& IgnoreUppercase, const VARIANT& AlwaysSuggest, const VARIANT& SpellLang);
LPDISPATCH GetColumn3DGroup();
LPDISPATCH ColumnGroups(const VARIANT& Index);
void CopyPicture(long Appearance, long Format, long Size);
LPDISPATCH GetCorners();
void CreatePublisher(const VARIANT& Edition, long Appearance, long Size, const VARIANT& ContainsPICT, const VARIANT& ContainsBIFF, const VARIANT& ContainsRTF, const VARIANT& ContainsVALU);
LPDISPATCH GetDataTable();
long GetDepthPercent();
void SetDepthPercent(long nNewValue);
void Deselect();
long GetDisplayBlanksAs();
void SetDisplayBlanksAs(long nNewValue);
LPDISPATCH DoughnutGroups(const VARIANT& Index);
long GetElevation();
void SetElevation(long nNewValue);
VARIANT Evaluate(const VARIANT& Name);
VARIANT _Evaluate(const VARIANT& Name);
LPDISPATCH GetFloor();
long GetGapDepth();
void SetGapDepth(long nNewValue);
VARIANT GetHasAxis(const VARIANT& Index1, const VARIANT& Index2);
void SetHasAxis(const VARIANT& Index1, const VARIANT& Index2, const VARIANT& newValue);
BOOL GetHasDataTable();
void SetHasDataTable(BOOL bNewValue);
BOOL GetHasLegend();
void SetHasLegend(BOOL bNewValue);
BOOL GetHasTitle();
void SetHasTitle(BOOL bNewValue);
long GetHeightPercent();
void SetHeightPercent(long nNewValue);
LPDISPATCH GetHyperlinks();
LPDISPATCH GetLegend();
LPDISPATCH GetLine3DGroup();
LPDISPATCH LineGroups(const VARIANT& Index);
LPDISPATCH Location(long Where, const VARIANT& Name);
LPDISPATCH OLEObjects(const VARIANT& Index);
void Paste(const VARIANT& Type);
long GetPerspective();
void SetPerspective(long nNewValue);
LPDISPATCH GetPie3DGroup();
LPDISPATCH PieGroups(const VARIANT& Index);
LPDISPATCH GetPlotArea();
BOOL GetPlotVisibleOnly();
void SetPlotVisibleOnly(BOOL bNewValue);
LPDISPATCH RadarGroups(const VARIANT& Index);
VARIANT GetRightAngleAxes();
void SetRightAngleAxes(const VARIANT& newValue);
VARIANT GetRotation();
void SetRotation(const VARIANT& newValue);
LPDISPATCH SeriesCollection(const VARIANT& Index);
BOOL GetSizeWithWindow();
void SetSizeWithWindow(BOOL bNewValue);
BOOL GetShowWindow();
void SetShowWindow(BOOL bNewValue);
LPDISPATCH GetSurfaceGroup();
long GetChartType();
void SetChartType(long nNewValue);
void ApplyCustomType(long ChartType, const VARIANT& TypeName);
LPDISPATCH GetWalls();
BOOL GetWallsAndGridlines2D();
void SetWallsAndGridlines2D(BOOL bNewValue);
LPDISPATCH XYGroups(const VARIANT& Index);
long GetBarShape();
void SetBarShape(long nNewValue);
long GetPlotBy();
void SetPlotBy(long nNewValue);
BOOL GetProtectFormatting();
void SetProtectFormatting(BOOL bNewValue);
BOOL GetProtectData();
void SetProtectData(BOOL bNewValue);
BOOL GetProtectGoalSeek();
void SetProtectGoalSeek(BOOL bNewValue);
BOOL GetProtectSelection();
void SetProtectSelection(BOOL bNewValue);
void GetChartElement(long x, long y, long* ElementID, long* Arg1, long* Arg2);
void SetSourceData(LPDISPATCH Source, const VARIANT& PlotBy);
BOOL Export(LPCTSTR Filename, const VARIANT& FilterName, const VARIANT& Interactive);
void Refresh();
LPDISPATCH GetPivotLayout();
BOOL GetHasPivotFields();
void SetHasPivotFields(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);
};
/////////////////////////////////////////////////////////////////////////////
// Sheets wrapper class
class Sheets : public COleDispatchDriver
{
public:
Sheets() {} // Calls COleDispatchDriver default constructor
Sheets(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
Sheets(const Sheets& 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);
};
/////////////////////////////////////////////////////////////////////////////
// _Worksheet wrapper class
class _Worksheet : public COleDispatchDriver
{
public:
_Worksheet() {} // Calls COleDispatchDriver default constructor
_Worksheet(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
_Worksheet(const _Worksheet& 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);
void Protect(const VARIANT& Password, const VARIANT& DrawingObjects, const VARIANT& Contents, const VARIANT& Scenarios, const VARIANT& UserInterfaceOnly);
BOOL GetProtectContents();
BOOL GetProtectDrawingObjects();
BOOL GetProtectionMode();
BOOL GetProtectScenarios();
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);
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);
void PasteSpecial(const VARIANT& Format, const VARIANT& Link, const VARIANT& DisplayAsIcon, const VARIANT& IconFileName, const VARIANT& IconIndex, const VARIANT& IconLabel);
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);
};
/////////////////////////////////////////////////////////////////////////////
// _Global wrapper class
class _Global : public COleDispatchDriver
{
public:
_Global() {} // Calls COleDispatchDriver default constructor
_Global(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
_Global(const _Global& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
// Attributes
public:
// Operations
public:
LPDISPATCH GetApplication();
long GetCreator();
LPDISPATCH GetParent();
LPDISPATCH GetActiveCell();
LPDISPATCH GetActiveChart();
CString GetActivePrinter();
void SetActivePrinter(LPCTSTR lpszNewValue);
LPDISPATCH GetActiveSheet();
LPDISPATCH GetActiveWindow();
LPDISPATCH GetActiveWorkbook();
LPDISPATCH GetAddIns();
LPDISPATCH GetAssistant();
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -