excel.h
来自「vc调用电子表格实现xls文件的程序化读写操作」· C头文件 代码 · 共 1,642 行 · 第 1/5 页
H
1,642 行
void SetExtrusionColorType(long nNewValue);
long GetPerspective();
void SetPerspective(long nNewValue);
long GetPresetExtrusionDirection();
long GetPresetLightingDirection();
void SetPresetLightingDirection(long nNewValue);
long GetPresetLightingSoftness();
void SetPresetLightingSoftness(long nNewValue);
long GetPresetMaterial();
void SetPresetMaterial(long nNewValue);
long GetPresetThreeDFormat();
float GetRotationX();
void SetRotationX(float newValue);
float GetRotationY();
void SetRotationY(float newValue);
long GetVisible();
void SetVisible(long nNewValue);
};
/////////////////////////////////////////////////////////////////////////////
// FillFormat wrapper class
class FillFormat : public COleDispatchDriver
{
public:
FillFormat() {} // Calls COleDispatchDriver default constructor
FillFormat(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
FillFormat(const FillFormat& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
// Attributes
public:
// Operations
public:
LPDISPATCH GetApplication();
long GetCreator();
LPDISPATCH GetParent();
void OneColorGradient(long Style, long Variant, float Degree);
void Patterned(long Pattern);
void PresetGradient(long Style, long Variant, long PresetGradientType);
void PresetTextured(long PresetTexture);
void Solid();
void TwoColorGradient(long Style, long Variant);
void UserPicture(LPCTSTR PictureFile);
void UserTextured(LPCTSTR TextureFile);
LPDISPATCH GetBackColor();
void SetBackColor(LPDISPATCH newValue);
LPDISPATCH GetForeColor();
void SetForeColor(LPDISPATCH newValue);
long GetGradientColorType();
float GetGradientDegree();
long GetGradientStyle();
long GetGradientVariant();
long GetPattern();
long GetPresetGradientType();
long GetPresetTexture();
CString GetTextureName();
long GetTextureType();
float GetTransparency();
void SetTransparency(float newValue);
long GetType();
long GetVisible();
void SetVisible(long nNewValue);
};
/////////////////////////////////////////////////////////////////////////////
// DiagramNodes wrapper class
class DiagramNodes : public COleDispatchDriver
{
public:
DiagramNodes() {} // Calls COleDispatchDriver default constructor
DiagramNodes(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
DiagramNodes(const DiagramNodes& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
// Attributes
public:
// Operations
public:
LPDISPATCH GetApplication();
long GetCreator();
LPUNKNOWN Get_NewEnum();
LPDISPATCH Item(const VARIANT& Index);
void SelectAll();
LPDISPATCH GetParent();
long GetCount();
};
/////////////////////////////////////////////////////////////////////////////
// DiagramNodeChildren wrapper class
class DiagramNodeChildren : public COleDispatchDriver
{
public:
DiagramNodeChildren() {} // Calls COleDispatchDriver default constructor
DiagramNodeChildren(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
DiagramNodeChildren(const DiagramNodeChildren& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
// Attributes
public:
// Operations
public:
LPDISPATCH GetApplication();
long GetCreator();
LPUNKNOWN Get_NewEnum();
LPDISPATCH Item(const VARIANT& Index);
LPDISPATCH AddNode(const VARIANT& Index, long nodeType);
void SelectAll();
LPDISPATCH GetParent();
long GetCount();
LPDISPATCH GetFirstChild();
LPDISPATCH GetLastChild();
};
/////////////////////////////////////////////////////////////////////////////
// DiagramNode wrapper class
class DiagramNode : public COleDispatchDriver
{
public:
DiagramNode() {} // Calls COleDispatchDriver default constructor
DiagramNode(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
DiagramNode(const DiagramNode& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
// Attributes
public:
// Operations
public:
LPDISPATCH GetApplication();
long GetCreator();
LPDISPATCH AddNode(long pos, long nodeType);
void Delete();
void MoveNode(LPDISPATCH pTargetNode, long pos);
void ReplaceNode(LPDISPATCH pTargetNode);
void SwapNode(LPDISPATCH pTargetNode, BOOL swapChildren);
LPDISPATCH CloneNode(BOOL copyChildren, LPDISPATCH pTargetNode, long pos);
void TransferChildren(LPDISPATCH pReceivingNode);
LPDISPATCH NextNode();
LPDISPATCH PrevNode();
LPDISPATCH GetParent();
LPDISPATCH GetChildren();
LPDISPATCH GetShape();
LPDISPATCH GetRoot();
LPDISPATCH GetDiagram();
long GetLayout();
void SetLayout(long nNewValue);
LPDISPATCH GetTextShape();
};
/////////////////////////////////////////////////////////////////////////////
// IRTDUpdateEvent wrapper class
class IRTDUpdateEvent : public COleDispatchDriver
{
public:
IRTDUpdateEvent() {} // Calls COleDispatchDriver default constructor
IRTDUpdateEvent(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
IRTDUpdateEvent(const IRTDUpdateEvent& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
// Attributes
public:
// Operations
public:
void UpdateNotify();
long GetHeartbeatInterval();
void SetHeartbeatInterval(long nNewValue);
void Disconnect();
};
/////////////////////////////////////////////////////////////////////////////
// IRtdServer wrapper class
class IRtdServer : public COleDispatchDriver
{
public:
IRtdServer() {} // Calls COleDispatchDriver default constructor
IRtdServer(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
IRtdServer(const IRtdServer& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
// Attributes
public:
// Operations
public:
long ServerStart(LPDISPATCH CallbackObject);
// method 'ConnectData' not emitted because of invalid return type or parameter type
// method 'RefreshData' not emitted because of invalid return type or parameter type
void DisconnectData(long TopicID);
long Heartbeat();
void ServerTerminate();
};
/////////////////////////////////////////////////////////////////////////////
// _Application wrapper class
class _Application : public COleDispatchDriver
{
public:
_Application() {} // Calls COleDispatchDriver default constructor
_Application(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
_Application(const _Application& 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();
void Calculate();
LPDISPATCH GetCells();
LPDISPATCH GetCharts();
LPDISPATCH GetColumns();
LPDISPATCH GetCommandBars();
long GetDDEAppReturnCode();
void DDEExecute(long Channel, LPCTSTR String);
long DDEInitiate(LPCTSTR App, LPCTSTR Topic);
void DDEPoke(long Channel, const VARIANT& Item, const VARIANT& Data);
VARIANT DDERequest(long Channel, LPCTSTR Item);
void DDETerminate(long Channel);
VARIANT Evaluate(const VARIANT& Name);
VARIANT _Evaluate(const VARIANT& Name);
VARIANT ExecuteExcel4Macro(LPCTSTR String);
LPDISPATCH Intersect(LPDISPATCH Arg1, LPDISPATCH Arg2, const VARIANT& Arg3, const VARIANT& Arg4, const VARIANT& Arg5, const VARIANT& Arg6, const VARIANT& Arg7, const VARIANT& Arg8, const VARIANT& Arg9, const VARIANT& Arg10, const VARIANT& Arg11, const VARIANT& Arg12, const VARIANT& Arg13, const VARIANT& Arg14, const VARIANT& Arg15, const VARIANT& Arg16, const VARIANT& Arg17, const VARIANT& Arg18, const VARIANT& Arg19, const VARIANT& Arg20, const VARIANT& Arg21, const VARIANT& Arg22, const VARIANT& Arg23, const VARIANT& Arg24, const VARIANT& Arg25, const VARIANT& Arg26, const VARIANT& Arg27, const VARIANT& Arg28, const VARIANT& Arg29, const VARIANT& Arg30);
LPDISPATCH GetNames();
LPDISPATCH GetRange(const VARIANT& Cell1, const VARIANT& Cell2);
LPDISPATCH GetRows();
VARIANT Run(const VARIANT& Macro, const VARIANT& Arg1, const VARIANT& Arg2, const VARIANT& Arg3, const VARIANT& Arg4, const VARIANT& Arg5, const VARIANT& Arg6, const VARIANT& Arg7, const VARIANT& Arg8, const VARIANT& Arg9, const VARIANT& Arg10, const VARIANT& Arg11, const VARIANT& Arg12, const VARIANT& Arg13, const VARIANT& Arg14, const VARIANT& Arg15, const VARIANT& Arg16, const VARIANT& Arg17, const VARIANT& Arg18, const VARIANT& Arg19, const VARIANT& Arg20, const VARIANT& Arg21, const VARIANT& Arg22, const VARIANT& Arg23, const VARIANT& Arg24, const VARIANT& Arg25, const VARIANT& Arg26, const VARIANT& Arg27, const VARIANT& Arg28, const VARIANT& Arg29, const VARIANT& Arg30);
VARIANT _Run2(const VARIANT& Macro, const VARIANT& Arg1, const VARIANT& Arg2, const VARIANT& Arg3, const VARIANT& Arg4, const VARIANT& Arg5, const VARIANT& Arg6, const VARIANT& Arg7, const VARIANT& Arg8, const VARIANT& Arg9, const VARIANT& Arg10, const VARIANT& Arg11, const VARIANT& Arg12, const VARIANT& Arg13, const VARIANT& Arg14, const VARIANT& Arg15, const VARIANT& Arg16, const VARIANT& Arg17, const VARIANT& Arg18, const VARIANT& Arg19, const VARIANT& Arg20, const VARIANT& Arg21, const VARIANT& Arg22, const VARIANT& Arg23, const VARIANT& Arg24, const VARIANT& Arg25, const VARIANT& Arg26, const VARIANT& Arg27, const VARIANT& Arg28, const VARIANT& Arg29, const VARIANT& Arg30);
LPDISPATCH GetSelection();
void SendKeys(const VARIANT& Keys, const VARIANT& Wait);
LPDISPATCH GetSheets();
LPDISPATCH GetThisWorkbook();
LPDISPATCH Union(LPDISPATCH Arg1, LPDISPATCH Arg2, const VARIANT& Arg3, const VARIANT& Arg4, const VARIANT& Arg5, const VARIANT& Arg6, const VARIANT& Arg7, const VARIANT& Arg8, const VARIANT& Arg9, const VARIANT& Arg10, const VARIANT& Arg11, const VARIANT& Arg12, const VARIANT& Arg13, const VARIANT& Arg14, const VARIANT& Arg15, const VARIANT& Arg16, const VARIANT& Arg17, const VARIANT& Arg18, const VARIANT& Arg19, const VARIANT& Arg20, const VARIANT& Arg21, const VARIANT& Arg22, const VARIANT& Arg23, const VARIANT& Arg24, const VARIANT& Arg25, const VARIANT& Arg26, const VARIANT& Arg27, const VARIANT& Arg28, const VARIANT& Arg29, const VARIANT& Arg30);
LPDISPATCH GetWindows();
LPDISPATCH GetWorkbooks();
LPDISPATCH GetWorksheetFunction();
LPDISPATCH GetWorksheets();
LPDISPATCH GetExcel4IntlMacroSheets();
LPDISPATCH GetExcel4MacroSheets();
void ActivateMicrosoftApp(long Index);
void AddChartAutoFormat(const VARIANT& Chart, LPCTSTR Name, const VARIANT& Description);
void AddCustomList(const VARIANT& ListArray, const VARIANT& ByRow);
BOOL GetAlertBeforeOverwriting();
void SetAlertBeforeOverwriting(BOOL bNewValue);
CString GetAltStartupPath();
void SetAltStartupPath(LPCTSTR lpszNewValue);
BOOL GetAskToUpdateLinks();
void SetAskToUpdateLinks(BOOL bNewValue);
BOOL GetEnableAnimations();
void SetEnableAnimations(BOOL bNewValue);
LPDISPATCH GetAutoCorrect();
long GetBuild();
BOOL GetCalculateBeforeSave();
void SetCalculateBeforeSave(BOOL bNewValue);
long GetCalculation();
void SetCalculation(long nNewValue);
VARIANT GetCaller(const VARIANT& Index);
BOOL GetCanPlaySounds();
BOOL GetCanRecordSounds();
CString GetCaption();
void SetCaption(LPCTSTR lpszNewValue);
BOOL GetCellDragAndDrop();
void SetCellDragAndDrop(BOOL bNewValue);
double CentimetersToPoints(double Centimeters);
BOOL CheckSpelling(LPCTSTR Word, const VARIANT& CustomDictionary, const VARIANT& IgnoreUppercase);
VARIANT GetClipboardFormats(const VARIANT& Index);
BOOL GetDisplayClipboardWindow();
void SetDisplayClipboardWindow(BOOL bNewValue);
long GetCommandUnderlines();
void SetCommandUnderlines(long nNewValue);
BOOL GetConstrainNumeric();
void SetConstrainNumeric(BOOL bNewValue);
VARIANT ConvertFormula(const VARIANT& Formula, long FromReferenceStyle, const VARIANT& ToReferenceStyle, const VARIANT& ToAbsolute, const VARIANT& RelativeTo);
BOOL GetCopyObjectsWithCells();
void SetCopyObjectsWithCells(BOOL bNewValue);
long GetCursor();
void SetCursor(long nNewValue);
long GetCustomListCount();
long GetCutCopyMode();
void SetCutCopyMode(long nNewValue);
long GetDataEntryMode();
void SetDataEntryMode(long nNewValue);
CString Get_Default();
CString GetDefaultFilePath();
void SetDefaultFilePath(LPCTSTR lpszNewValue);
void DeleteChartAutoFormat(LPCTSTR Name);
void DeleteCustomList(long ListNum);
LPDISPATCH GetDialogs();
BOOL GetDisplayAlerts();
void SetDisplayAlerts(BOOL bNewValue);
BOOL GetDisplayFormulaBar();
void SetDisplayFormulaBar(BOOL bNewValue);
BOOL GetDisplayFullScreen();
void SetDisplayFullScreen(BOOL bNewValue);
BOOL GetDisplayNoteIndicator();
void SetDisplayNoteIndicator(BOOL bNewValue);
long GetDisplayCommentIndicator();
void SetDisplayCommentIndicator(long nNewValue);
BOOL GetDisplayExcel4Menus();
void SetDisplayExcel4Menus(BOOL bNewValue);
BOOL GetDisplayRecentFiles();
void SetDisplayRecentFiles(BOOL bNewValue);
BOOL GetDisplayScrollBars();
void SetDisplayScrollBars(BOOL bNewValue);
BOOL GetDisplayStatusBar();
void SetDisplayStatusBar(BOOL bNewValue);
void DoubleClick();
BOOL GetEditDirectlyInCell();
void SetEditDirectlyInCell(BOOL bNewValue);
BOOL GetEnableAutoComplete();
void SetEnableAutoComplete(BOOL bNewValue);
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?