因为用ODBC连接Excel,不能处理任意创建的Excel文件,于是我决定另写一个版本,用Automation技术。其实就是用Excel自己的类库,进行操作。我在实习的时候,用过这种方法,开发AutoCAD图纸签名程序。
说Automation技术,只不过是随着别人叫而已,具体是什么东西,我还不太清楚。慢慢理解吧。
程序参考自:http://blog.youkuaiyun.com/bodybo/archive/2009/05/27/4219242.aspx
开发过程如下:
还是用支持MFC的控制台程序来试验
1、创建一个支持MFC的控制台工程。工程名为ExcelTest。
2、加入Excel组件。菜单选择View ->ClassWizard,添加Excel类库

进入到Office的安装目录:.

文件类型选择为All Files(*.*)。选择EXCEL.EXE:

点“打开”,然后选择要引入的类,_Application、Worksheets、_Worksheet、Workbooks、_Workbook、Range这五个类(其中Worksheets不好找,可以先在键盘上按“W”键,找到Worksheets,然后找到其余几个类,按住ctrl键,将其选中)

点OK按钮,将这几个类引入到工程中。这时工程里面就会多了两个文件,Excel.h和Excel.cpp,以及引入的六个类:

3、在ExcelTest.cpp中引入Excel头文件。
#include "excel.h"
4、在_tmain()函数前面声明一个函数,用来处理Excel。
void CalculateExcel(CString strFile);
5、编写CalculateExcel()函数。
void CalculateExcel(CString strFile)
{
_Application app;
_Workbook book;
_Worksheet sheet;
Workbooks books;
Worksheets sheets;
Range range;
LPDISPATCH lpDisp;
COleVariant vResult;
COleVariant covTrue((short)TRUE);
COleVariant covFalse((short)FALSE);
COleVariant covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR);
//创建Excel服务器(启动Excel)
if(!app.CreateDispatch("Excel.Application"))
{
AfxMessageBox("无法启动Excel服务器!");
return;
}
app.SetVisible(FALSE); //使Excel不可见
//打开demo.xls
books.AttachDispatch(app.GetWorkbooks());
lpDisp = books.Open(strFile,
covOptional, covFalse, covOptional, covOptional, covOptional,
covOptional, covOptional, covOptional, covOptional, covOptional,
covOptional, covOptional, covOptional, covOptional);
//得到Workbook
book.AttachDispatch(lpDisp);
//得到Worksheets
sheets.AttachDispatch(book.GetWorksheets());
//得到当前活跃sheet
//如果有单元格正处于编辑状态中,此操作不能返回,会一直等待
lpDisp=book.GetActiveSheet();
sheet.AttachDispatch(lpDisp);
//读取已经使用区域的信息,包括已经使用的行数、列数、起始行、起始列
Range usedRange;
usedRange.AttachDispatch(sheet.GetUsedRange());
range.AttachDispatch(usedRange.GetRows());
long iRowNum=range.GetCount(); //已经使用的行数
long iStartRow=usedRange.GetRow(); //已使用区域的起始行,从1开始
//读取每一行的内容
CString strValue1; // 第一个单元格内容
double dValue2; // 第二个单元格内容
CString strTmp; // 临时存储字符串
double dResult = 0.0; // 计算结果
double dRowIndex; // 目标行
for (int i=iStartRow; i<=iRowNum; i++)
{
// 得到本行第一个单元格的内容(字符串)
range.AttachDispatch(usedRange.GetItem(COleVariant((long)i), COleVariant((long)1)).pdispVal);
vResult = range.GetText();
strValue1 = vResult.bstrVal;
// 得到本行第二个单元格的内容(double)
range.AttachDispatch(usedRange.GetItem(COleVariant((long)i), COleVariant((long)2)).pdispVal);
vResult = range.GetText();
strTmp = vResult.bstrVal;
dValue2 = atof(strTmp);
// 判断本行是不是应该写入计算结果的那一行
if (strValue1 == "call price")
{
dRowIndex = i;
break;
}
strTmp.Format("%d\t%s\t\t%.2f\n", i, strValue1, dValue2);
printf(strTmp);
// 求和
dResult += dValue2;
}
strTmp.Format("\nthe result:\n%s\t%.2f\n", strValue1, dResult);
printf(strTmp);
// 写入计算结果
usedRange.SetItem(COleVariant((long)dRowIndex), COleVariant((long)2), COleVariant((double)dResult));
// 保存
book.Save();
//关闭所有的book,退出Excel
book.Close (covOptional,COleVariant(strFile),covOptional);
books.Close();
app.Quit();
}
6、然后在_tmain()函数中添加如下代码,来调用CalculateExcel函数:
::CoInitialize(NULL);
//初始化COM的动态连接库
if(!AfxOleInit())
{
AfxMessageBox("无法初始化COM的动态连接库!");
return 0;
}
char szCurrPath[300];
::GetCurrentDirectoryA(300, szCurrPath);// 得到程序所在目录
CalculateExcel((CString)szCurrPath + "\\demo.xls");
::CoUninitialize();
7、在工程根目录下,新建一个Excel文件,命名为demo.xls,随便添加几个数据,但是要有一个单元格为call price,以便将计算结果写入到该单元格后面:

8、编译、执行程序,运行界面如下:

打开demo.xls文件,如下:

// Machine generated IDispatch wrapper class(es) created with ClassWizard
/////////////////////////////////////////////////////////////////////////////
// _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 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 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);
long GetEnableCancelKey();
void SetEnableCancelKey(long nNewValue);
BOOL GetEnableSound();
void SetEnableSound(BOOL bNewValue);
VARIANT GetFileConverters(const VARIANT& Index1, const VARIANT& Index2);
BOOL GetFixedDecimal();
void SetFixedDecimal(BOOL bNewValue);
long GetFixedDecimalPlaces();
void SetFixedDecimalPlaces(long nNewValue);
VARIANT GetCustomListContents(long ListNum);
long GetCustomListNum(const VARIANT& ListArray);
VARIANT GetOpenFilename(const VARIANT& FileFilter, const VARIANT& FilterIndex, const VARIANT& Title, const VARIANT& ButtonText, const VARIANT& MultiSelect);
VARIANT GetSaveAsFilename(const VARIANT& InitialFilename, const VARIANT& FileFilter, const VARIANT& FilterIndex, const VARIANT& Title, const VARIANT& ButtonText);
void Goto(const VARIANT& Reference, const VARIANT& Scroll);
double GetHeight();
void SetHeight(double newValue);
void Help(const VARIANT& HelpFile, const VARIANT& HelpContextID);
BOOL GetIgnoreRemoteRequests();
void SetIgnoreRemoteRequests(BOOL bNewValue);
double InchesToPoints(double Inches);
VARIANT InputBox(LPCTSTR Prompt, const VARIANT& Title, const VARIANT& Default, const VARIANT& Left, const VARIANT& Top, const VARIANT& HelpFile, const VARIANT& HelpContextID, const VARIANT& Type);
BOOL GetInteractive();
void SetInteractive(BOOL bNewValue);
VARIANT GetInternational(const VARIANT& Index);
BOOL GetIteration();
void SetIteration(BOOL bNewValue);
double GetLeft();
void SetLeft(double newValue);
CString GetLibraryPath();
void MacroOptions(const VARIANT& Macro, const VARIANT& Description, const VARIANT& HasMenu, const VARIANT& MenuText, const VARIANT& HasShortcutKey, const VARIANT& ShortcutKey, const VARIANT& Category, const VARIANT& StatusBar,
const VARIANT& HelpContextID, const VARIANT& HelpFile);
void MailLogoff();
void MailLogon(const VARIANT& Name, const VARIANT& Password, const VARIANT& DownloadNewMail);
VARIANT GetMailSession();
long GetMailSystem();
BOOL GetMathCoprocessorAvailable();
double GetMaxChange();
void SetMaxChange(double newValue);
long GetMaxIterations();
void SetMaxIterations(long nNewValue);
BOOL GetMouseAvailable();
BOOL GetMoveAfterReturn();
void SetMoveAfterReturn(BOOL bNewValue);
long GetMoveAfterReturnDirection();
void SetMoveAfterReturnDirection(long nNewValue);
LPDISPATCH GetRecentFiles();
CString GetName();
LPDISPATCH NextLetter();
CString GetNetworkTemplatesPath();
LPDISPATCH GetODBCErrors();
long GetODBCTimeout();
void SetODBCTimeout(long nNewValue);
void OnKey(LPCTSTR Key, const VARIANT& Procedure);
void OnRepeat(LPCTSTR Text, LPCTSTR Procedure);
void OnTime(const VARIANT& EarliestTime, LPCTSTR Procedure, const VARIANT& LatestTime, const VARIANT& Schedule);
void OnUndo(LPCTSTR Text, LPCTSTR Procedure);
CString GetOnWindow();
void SetOnWindow(LPCTSTR lpszNewValue);
CString GetOperatingSystem();
CString GetOrganizationName();
CString GetPath();
CString GetPathSeparator();
VARIANT GetPreviousSelections(const VARIANT& Index);
BOOL GetPivotTableSelection();
void SetPivotTableSelection(BOOL bNewValue);
BOOL GetPromptForSummaryInfo();
void SetPromptForSummaryInfo(BOOL bNewValue);
void Quit();
void RecordMacro(const VARIANT& BasicCode, const VARIANT& XlmCode);
BOOL GetRecordRelative();
long GetReferenceStyle();
void SetReferenceStyle(long nNewValue);
VARIANT GetRegisteredFunctions(const VARIANT& Index1, const VARIANT& Index2);
BOOL RegisterXLL(LPCTSTR Filename);
void Repeat();
BOOL GetRollZoom();
void SetRollZoom(BOOL bNewValue);
void SaveWorkspace(const VARIANT& Filename);
BOOL GetScreenUpdating();
void SetScreenUpdating(BOOL bNewValue);
long GetSheetsInNewWorkbook();
void SetSheetsInNewWorkbook(long nNewValue);
BOOL GetShowChartTipNames();
void SetShowChartTipNames(BOOL bNewValue);
BOOL GetShowChartTipValues();
void SetShowChartTipValues(BOOL bNewValue);
CString GetStandardFont();
void SetStandardFont(LPCTSTR lpszNewValue);
double GetStandardFontSize();
void SetStandardFontSize(double newValue);
CString GetStartupPath();
VARIANT GetStatusBar();
void SetStatusBar(const VARIANT& newValue);
CString GetTemplatesPath();
BOOL GetShowToolTips();
void SetShowToolTips(BOOL bNewValue);
double GetTop();
void SetTop(double newValue);
long GetDefaultSaveFormat();
void SetDefaultSaveFormat(long nNewValue);
CString GetTransitionMenuKey();
void SetTransitionMenuKey(LPCTSTR lpszNewValue);
long GetTransitionMenuKeyAction();
void SetTransitionMenuKeyAction(long nNewValue);
BOOL GetTransitionNavigKeys();
void SetTransitionNavigKeys(BOOL bNewValue);
void Undo();
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();
BOOL GetDisplayDocumentActionTaskPane();
void SetDisplayDocumentActionTaskPane(BOOL bNewValue);
void DisplayXMLSourcePane(const VARIANT& XmlMap);
BOOL GetArbitraryXMLSupportAvailable();
long GetMeasurementUnit();
void SetMeasurementUnit(long nNewValue);
BOOL GetShowSelectionFloaties();
void SetShowSelectionFloaties(BOOL bNewValue);
BOOL GetShowMenuFloaties();
void SetShowMenuFloaties(BOOL bNewValue);
BOOL GetShowDevTools();
void SetShowDevTools(BOOL bNewValue);
BOOL GetEnableLivePreview();
void SetEnableLivePreview(BOOL bNewValue);
BOOL GetDisplayDocumentInformationPanel();
void SetDisplayDocumentInformationPanel(BOOL bNewValue);
BOOL GetAlwaysUseClearType();
void SetAlwaysUseClearType(BOOL bNewValue);
BOOL GetWarnOnFunctionNameConflict();
void SetWarnOnFunctionNameConflict(BOOL bNewValue);
long GetFormulaBarHeight();
void SetFormulaBarHeight(long nNewValue);
BOOL GetDisplayFormulaAutoComplete();
void SetDisplayFormulaAutoComplete(BOOL bNewValue);
long GetGenerateTableRefs();
void SetGenerateTableRefs(long nNewValue);
LPDISPATCH GetAssistance();
void CalculateUntilAsyncQueriesDone();
BOOL GetEnableLargeOperationAlert();
void SetEnableLargeOperationAlert(BOOL bNewValue);
long GetLargeOperationCellThousandCount();
void SetLargeOperationCellThousandCount(long nNewValue);
BOOL GetDeferAsyncQueries();
void SetDeferAsyncQueries(BOOL bNewValue);
LPDISPATCH GetMultiThreadedCalculation();
long SharePointVersion(LPCTSTR bstrUrl);
long GetActiveEncryptionSession();
BOOL GetHighQualityModeForGraphics();
void SetHighQualityModeForGraphics(BOOL bNewValue);
};
/////////////////////////////////////////////////////////////////////////////
// _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);
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 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);
LPDISPATCH GetListObjects();
LPDISPATCH XmlDataQuery(LPCTSTR XPath, const VARIANT& SelectionNamespaces, const VARIANT& Map);
LPDISPATCH XmlMapQuery(LPCTSTR XPath, const VARIANT& SelectionNamespaces, const VARIANT& Map);
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,
const VARIANT& IgnorePrintAreas);
BOOL GetEnableFormatConditionsCalculation();
void SetEnableFormatConditionsCalculation(BOOL bNewValue);
LPDISPATCH GetSort();
void ExportAsFixedFormat(long Type, const VARIANT& Filename, const VARIANT& Quality, const VARIANT& IncludeDocProperties, const VARIANT& IgnorePrintAreas, const VARIANT& From, const VARIANT& To, const VARIANT& OpenAfterPublish,
const VARIANT& FixedFormatExtClassPtr);
};
/////////////////////////////////////////////////////////////////////////////
// _Workbook wrapper class
class _Workbook : public COleDispatchDriver
{
public:
_Workbook() {} // Calls COleDispatchDriver default constructor
_Workbook(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
_Workbook(const _Workbook& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
// Attributes
public:
// Operations
public:
LPDISPATCH GetApplication();
long GetCreator();
LPDISPATCH GetParent();
void Activate();
LPDISPATCH GetActiveChart();
LPDISPATCH GetActiveSheet();
long GetAutoUpdateFrequency();
void SetAutoUpdateFrequency(long nNewValue);
BOOL GetAutoUpdateSaveChanges();
void SetAutoUpdateSaveChanges(BOOL bNewValue);
long GetChangeHistoryDuration();
void SetChangeHistoryDuration(long nNewValue);
LPDISPATCH GetBuiltinDocumentProperties();
void ChangeFileAccess(long Mode, const VARIANT& WritePassword, const VARIANT& Notify);
void ChangeLink(LPCTSTR Name, LPCTSTR NewName, long Type);
LPDISPATCH GetCharts();
void Close(const VARIANT& SaveChanges, const VARIANT& Filename, const VARIANT& RouteWorkbook);
CString GetCodeName();
CString Get_CodeName();
void Set_CodeName(LPCTSTR lpszNewValue);
VARIANT GetColors(const VARIANT& Index);
void SetColors(const VARIANT& Index, const VARIANT& newValue);
LPDISPATCH GetCommandBars();
long GetConflictResolution();
void SetConflictResolution(long nNewValue);
LPDISPATCH GetContainer();
BOOL GetCreateBackup();
LPDISPATCH GetCustomDocumentProperties();
BOOL GetDate1904();
void SetDate1904(BOOL bNewValue);
void DeleteNumberFormat(LPCTSTR NumberFormat);
long GetDisplayDrawingObjects();
void SetDisplayDrawingObjects(long nNewValue);
BOOL ExclusiveAccess();
long GetFileFormat();
void ForwardMailer();
CString GetFullName();
BOOL GetHasPassword();
BOOL GetIsAddin();
void SetIsAddin(BOOL bNewValue);
VARIANT LinkInfo(LPCTSTR Name, long LinkInfo, const VARIANT& Type, const VARIANT& EditionRef);
VARIANT LinkSources(const VARIANT& Type);
LPDISPATCH GetMailer();
void MergeWorkbook(const VARIANT& Filename);
BOOL GetMultiUserEditing();
CString GetName();
LPDISPATCH GetNames();
LPDISPATCH NewWindow();
void OpenLinks(LPCTSTR Name, const VARIANT& ReadOnly, const VARIANT& Type);
CString GetPath();
BOOL GetPersonalViewListSettings();
void SetPersonalViewListSettings(BOOL bNewValue);
BOOL GetPersonalViewPrintSettings();
void SetPersonalViewPrintSettings(BOOL bNewValue);
LPDISPATCH PivotCaches();
void Post(const VARIANT& DestName);
BOOL GetPrecisionAsDisplayed();
void SetPrecisionAsDisplayed(BOOL bNewValue);
void PrintPreview(const VARIANT& EnableChanges);
BOOL GetProtectStructure();
BOOL GetProtectWindows();
BOOL GetReadOnly();
void RefreshAll();
void Reply();
void ReplyAll();
void RemoveUser(long Index);
long GetRevisionNumber();
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 WebPagePreview();
LPDISPATCH GetPublishObjects();
LPDISPATCH GetWebOptions();
void ReloadAs(long Encoding);
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();
LPDISPATCH GetContentTypeProperties();
LPDISPATCH GetConnections();
void RemoveDocumentInformation(long RemoveDocInfoType);
LPDISPATCH GetSignatures();
void CheckInWithVersion(const VARIANT& SaveChanges, const VARIANT& Comments, const VARIANT& MakePublic, const VARIANT& VersionType);
LPDISPATCH GetServerPolicy();
void LockServerFile();
LPDISPATCH GetDocumentInspectors();
LPDISPATCH GetWorkflowTasks();
LPDISPATCH GetWorkflowTemplates();
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,
const VARIANT& IgnorePrintAreas);
LPDISPATCH GetServerViewableItems();
LPDISPATCH GetTableStyles();
VARIANT GetDefaultTableStyle();
void SetDefaultTableStyle(const VARIANT& newValue);
VARIANT GetDefaultPivotTableStyle();
void SetDefaultPivotTableStyle(const VARIANT& newValue);
BOOL GetCheckCompatibility();
void SetCheckCompatibility(BOOL bNewValue);
BOOL GetHasVBProject();
LPDISPATCH GetCustomXMLParts();
BOOL GetFinal();
void SetFinal(BOOL bNewValue);
LPDISPATCH GetResearch();
LPDISPATCH GetTheme();
void ApplyTheme(LPCTSTR Filename);
BOOL GetExcel8CompatibilityMode();
BOOL GetConnectionsDisabled();
void EnableConnections();
BOOL GetShowPivotChartActiveFields();
void SetShowPivotChartActiveFields(BOOL bNewValue);
void ExportAsFixedFormat(long Type, const VARIANT& Filename, const VARIANT& Quality, const VARIANT& IncludeDocProperties, const VARIANT& IgnorePrintAreas, const VARIANT& From, const VARIANT& To, const VARIANT& OpenAfterPublish,
const VARIANT& FixedFormatExtClassPtr);
LPDISPATCH GetIconSets();
CString GetEncryptionProvider();
void SetEncryptionProvider(LPCTSTR lpszNewValue);
BOOL GetDoNotPromptForConvert();
void SetDoNotPromptForConvert(BOOL bNewValue);
BOOL GetForceFullCalculation();
void SetForceFullCalculation(BOOL bNewValue);
void ProtectSharing(const VARIANT& Filename, const VARIANT& Password, const VARIANT& WriteResPassword, const VARIANT& ReadOnlyRecommended, const VARIANT& CreateBackup, const VARIANT& SharingPassword, const VARIANT& FileFormat);
};
/////////////////////////////////////////////////////////////////////////////
// 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);
};
/////////////////////////////////////////////////////////////////////////////
// Range wrapper class
class Range : public COleDispatchDriver
{
public:
Range() {} // Calls COleDispatchDriver default constructor
Range(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
Range(const Range& dispatchSrc) : COleDispatchDriver(dispatchSrc) {}
// Attributes
public:
// Operations
public:
LPDISPATCH GetApplication();
long GetCreator();
LPDISPATCH GetParent();
VARIANT Activate();
VARIANT GetAddIndent();
void SetAddIndent(const VARIANT& newValue);
CString GetAddress(const VARIANT& RowAbsolute, const VARIANT& ColumnAbsolute, long ReferenceStyle, const VARIANT& External, const VARIANT& RelativeTo);
CString GetAddressLocal(const VARIANT& RowAbsolute, const VARIANT& ColumnAbsolute, long ReferenceStyle, const VARIANT& External, const VARIANT& RelativeTo);
VARIANT AdvancedFilter(long Action, const VARIANT& CriteriaRange, const VARIANT& CopyToRange, const VARIANT& Unique);
VARIANT ApplyNames(const VARIANT& Names, const VARIANT& IgnoreRelativeAbsolute, const VARIANT& UseRowColumnNames, const VARIANT& OmitColumn, const VARIANT& OmitRow, long Order, const VARIANT& AppendLast);
VARIANT ApplyOutlineStyles();
LPDISPATCH GetAreas();
CString AutoComplete(LPCTSTR String);
VARIANT AutoFill(LPDISPATCH Destination, long Type);
VARIANT AutoFilter(const VARIANT& Field, const VARIANT& Criteria1, long Operator, const VARIANT& Criteria2, const VARIANT& VisibleDropDown);
VARIANT AutoFit();
VARIANT AutoOutline();
VARIANT BorderAround(const VARIANT& LineStyle, long Weight, long ColorIndex, const VARIANT& Color);
LPDISPATCH GetBorders();
VARIANT Calculate();
LPDISPATCH GetCells();
LPDISPATCH GetCharacters(const VARIANT& Start, const VARIANT& Length);
VARIANT CheckSpelling(const VARIANT& CustomDictionary, const VARIANT& IgnoreUppercase, const VARIANT& AlwaysSuggest, const VARIANT& SpellLang);
VARIANT Clear();
VARIANT ClearContents();
VARIANT ClearFormats();
VARIANT ClearNotes();
VARIANT ClearOutline();
long GetColumn();
LPDISPATCH ColumnDifferences(const VARIANT& Comparison);
LPDISPATCH GetColumns();
VARIANT GetColumnWidth();
void SetColumnWidth(const VARIANT& newValue);
VARIANT Consolidate(const VARIANT& Sources, const VARIANT& Function, const VARIANT& TopRow, const VARIANT& LeftColumn, const VARIANT& CreateLinks);
VARIANT Copy(const VARIANT& Destination);
long CopyFromRecordset(LPUNKNOWN Data, const VARIANT& MaxRows, const VARIANT& MaxColumns);
VARIANT CopyPicture(long Appearance, long Format);
long GetCount();
VARIANT CreateNames(const VARIANT& Top, const VARIANT& Left, const VARIANT& Bottom, const VARIANT& Right);
LPDISPATCH GetCurrentArray();
LPDISPATCH GetCurrentRegion();
VARIANT Cut(const VARIANT& Destination);
VARIANT DataSeries(const VARIANT& Rowcol, long Type, long Date, const VARIANT& Step, const VARIANT& Stop, const VARIANT& Trend);
VARIANT Get_Default(const VARIANT& RowIndex, const VARIANT& ColumnIndex);
void Set_Default(const VARIANT& RowIndex, const VARIANT& ColumnIndex, const VARIANT& newValue);
VARIANT Delete(const VARIANT& Shift);
LPDISPATCH GetDependents();
VARIANT DialogBox_();
LPDISPATCH GetDirectDependents();
LPDISPATCH GetDirectPrecedents();
VARIANT EditionOptions(long Type, long Option, const VARIANT& Name, const VARIANT& Reference, long Appearance, long ChartSize, const VARIANT& Format);
LPDISPATCH GetEnd(long Direction);
LPDISPATCH GetEntireColumn();
LPDISPATCH GetEntireRow();
VARIANT FillDown();
VARIANT FillLeft();
VARIANT FillRight();
VARIANT FillUp();
LPDISPATCH Find(const VARIANT& What, const VARIANT& After, const VARIANT& LookIn, const VARIANT& LookAt, const VARIANT& SearchOrder, long SearchDirection, const VARIANT& MatchCase, const VARIANT& MatchByte, const VARIANT& SearchFormat);
LPDISPATCH FindNext(const VARIANT& After);
LPDISPATCH FindPrevious(const VARIANT& After);
LPDISPATCH GetFont();
VARIANT GetFormula();
void SetFormula(const VARIANT& newValue);
VARIANT GetFormulaArray();
void SetFormulaArray(const VARIANT& newValue);
VARIANT GetFormulaHidden();
void SetFormulaHidden(const VARIANT& newValue);
VARIANT GetFormulaLocal();
void SetFormulaLocal(const VARIANT& newValue);
VARIANT GetFormulaR1C1();
void SetFormulaR1C1(const VARIANT& newValue);
VARIANT GetFormulaR1C1Local();
void SetFormulaR1C1Local(const VARIANT& newValue);
VARIANT FunctionWizard();
VARIANT Group(const VARIANT& Start, const VARIANT& End, const VARIANT& By, const VARIANT& Periods);
VARIANT GetHasArray();
VARIANT GetHasFormula();
VARIANT GetHeight();
VARIANT GetHidden();
void SetHidden(const VARIANT& newValue);
VARIANT GetHorizontalAlignment();
void SetHorizontalAlignment(const VARIANT& newValue);
VARIANT GetIndentLevel();
void SetIndentLevel(const VARIANT& newValue);
void InsertIndent(long InsertAmount);
VARIANT Insert(const VARIANT& Shift, const VARIANT& CopyOrigin);
LPDISPATCH GetInterior();
VARIANT GetItem(const VARIANT& RowIndex, const VARIANT& ColumnIndex);
void SetItem(const VARIANT& RowIndex, const VARIANT& ColumnIndex, const VARIANT& newValue);
VARIANT Justify();
VARIANT GetLeft();
long GetListHeaderRows();
VARIANT ListNames();
long GetLocationInTable();
VARIANT GetLocked();
void SetLocked(const VARIANT& newValue);
void Merge(const VARIANT& Across);
void UnMerge();
LPDISPATCH GetMergeArea();
VARIANT GetMergeCells();
void SetMergeCells(const VARIANT& newValue);
VARIANT GetName();
void SetName(const VARIANT& newValue);
VARIANT NavigateArrow(const VARIANT& TowardPrecedent, const VARIANT& ArrowNumber, const VARIANT& LinkNumber);
LPUNKNOWN Get_NewEnum();
LPDISPATCH GetNext();
CString NoteText(const VARIANT& Text, const VARIANT& Start, const VARIANT& Length);
VARIANT GetNumberFormat();
void SetNumberFormat(const VARIANT& newValue);
VARIANT GetNumberFormatLocal();
void SetNumberFormatLocal(const VARIANT& newValue);
LPDISPATCH GetOffset(const VARIANT& RowOffset, const VARIANT& ColumnOffset);
VARIANT GetOrientation();
void SetOrientation(const VARIANT& newValue);
VARIANT GetOutlineLevel();
void SetOutlineLevel(const VARIANT& newValue);
long GetPageBreak();
void SetPageBreak(long nNewValue);
VARIANT Parse(const VARIANT& ParseLine, const VARIANT& Destination);
LPDISPATCH GetPivotField();
LPDISPATCH GetPivotItem();
LPDISPATCH GetPivotTable();
LPDISPATCH GetPrecedents();
VARIANT GetPrefixCharacter();
LPDISPATCH GetPrevious();
VARIANT PrintPreview(const VARIANT& EnableChanges);
LPDISPATCH GetQueryTable();
LPDISPATCH GetRange(const VARIANT& Cell1, const VARIANT& Cell2);
VARIANT RemoveSubtotal();
BOOL Replace(const VARIANT& What, const VARIANT& Replacement, const VARIANT& LookAt, const VARIANT& SearchOrder, const VARIANT& MatchCase, const VARIANT& MatchByte, const VARIANT& SearchFormat, const VARIANT& ReplaceFormat);
LPDISPATCH GetResize(const VARIANT& RowSize, const VARIANT& ColumnSize);
long GetRow();
LPDISPATCH RowDifferences(const VARIANT& Comparison);
VARIANT GetRowHeight();
void SetRowHeight(const VARIANT& newValue);
LPDISPATCH GetRows();
VARIANT Run(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 Select();
VARIANT Show();
VARIANT ShowDependents(const VARIANT& Remove);
VARIANT GetShowDetail();
void SetShowDetail(const VARIANT& newValue);
VARIANT ShowErrors();
VARIANT ShowPrecedents(const VARIANT& Remove);
VARIANT GetShrinkToFit();
void SetShrinkToFit(const VARIANT& newValue);
VARIANT Sort(const VARIANT& Key1, long Order1, const VARIANT& Key2, const VARIANT& Type, long Order2, const VARIANT& Key3, long Order3, long Header, const VARIANT& OrderCustom, const VARIANT& MatchCase, long Orientation, long SortMethod,
long DataOption1, long DataOption2, long DataOption3);
VARIANT SortSpecial(long SortMethod, const VARIANT& Key1, long Order1, const VARIANT& Type, const VARIANT& Key2, long Order2, const VARIANT& Key3, long Order3, long Header, const VARIANT& OrderCustom, const VARIANT& MatchCase,
long Orientation, long DataOption1, long DataOption2, long DataOption3);
LPDISPATCH GetSoundNote();
LPDISPATCH SpecialCells(long Type, const VARIANT& Value);
VARIANT GetStyle();
void SetStyle(const VARIANT& newValue);
VARIANT SubscribeTo(LPCTSTR Edition, long Format);
VARIANT Subtotal(long GroupBy, long Function, const VARIANT& TotalList, const VARIANT& Replace, const VARIANT& PageBreaks, long SummaryBelowData);
VARIANT GetSummary();
VARIANT Table(const VARIANT& RowInput, const VARIANT& ColumnInput);
VARIANT GetText();
VARIANT TextToColumns(const VARIANT& Destination, long 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& DecimalSeparator, const VARIANT& ThousandsSeparator, const VARIANT& TrailingMinusNumbers);
VARIANT GetTop();
VARIANT Ungroup();
VARIANT GetUseStandardHeight();
void SetUseStandardHeight(const VARIANT& newValue);
VARIANT GetUseStandardWidth();
void SetUseStandardWidth(const VARIANT& newValue);
LPDISPATCH GetValidation();
VARIANT GetValue(const VARIANT& RangeValueDataType);
void SetValue(const VARIANT& RangeValueDataType, const VARIANT& newValue);
VARIANT GetValue2();
void SetValue2(const VARIANT& newValue);
VARIANT GetVerticalAlignment();
void SetVerticalAlignment(const VARIANT& newValue);
VARIANT GetWidth();
LPDISPATCH GetWorksheet();
VARIANT GetWrapText();
void SetWrapText(const VARIANT& newValue);
LPDISPATCH AddComment(const VARIANT& Text);
LPDISPATCH GetComment();
void ClearComments();
LPDISPATCH GetPhonetic();
LPDISPATCH GetFormatConditions();
long GetReadingOrder();
void SetReadingOrder(long nNewValue);
LPDISPATCH GetHyperlinks();
LPDISPATCH GetPhonetics();
void SetPhonetic();
CString GetId();
void SetId(LPCTSTR lpszNewValue);
LPDISPATCH GetPivotCell();
void Dirty();
LPDISPATCH GetErrors();
LPDISPATCH GetSmartTags();
void Speak(const VARIANT& SpeakDirection, const VARIANT& SpeakFormulas);
VARIANT PasteSpecial(long Paste, long Operation, const VARIANT& SkipBlanks, const VARIANT& Transpose);
BOOL GetAllowEdit();
LPDISPATCH GetListObject();
LPDISPATCH GetXPath();
LPDISPATCH GetServerActions();
void RemoveDuplicates(const VARIANT& Columns, long Header);
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);
CString GetMdx();
void ExportAsFixedFormat(long Type, const VARIANT& Filename, const VARIANT& Quality, const VARIANT& IncludeDocProperties, const VARIANT& IgnorePrintAreas, const VARIANT& From, const VARIANT& To, const VARIANT& OpenAfterPublish,
const VARIANT& FixedFormatExtClassPtr);
VARIANT GetCountLarge();
VARIANT CalculateRowMajorOrder();
};
/////////////////////////////////////////////////////////////////////////////
// Worksheets wrapper class
class Worksheets : public COleDispatchDriver
{
public:
Worksheets() {} // Calls COleDispatchDriver default constructor
Worksheets(LPDISPATCH pDispatch) : COleDispatchDriver(pDispatch) {}
Worksheets(const Worksheets& 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,
const VARIANT& IgnorePrintAreas);
};
excel.cpp
// Machine generated IDispatch wrapper class(es) created with ClassWizard
#include "stdafx.h"
#include "excel.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// _Application properties
/////////////////////////////////////////////////////////////////////////////
// _Application operations
LPDISPATCH _Application::GetApplication()
{
LPDISPATCH result;
InvokeHelper(0x94, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long _Application::GetCreator()
{
long result;
InvokeHelper(0x95, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetParent()
{
LPDISPATCH result;
InvokeHelper(0x96, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetActiveCell()
{
LPDISPATCH result;
InvokeHelper(0x131, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetActiveChart()
{
LPDISPATCH result;
InvokeHelper(0xb7, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
CString _Application::GetActivePrinter()
{
CString result;
InvokeHelper(0x132, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Application::SetActivePrinter(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x132, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
LPDISPATCH _Application::GetActiveSheet()
{
LPDISPATCH result;
InvokeHelper(0x133, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetActiveWindow()
{
LPDISPATCH result;
InvokeHelper(0x2f7, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetActiveWorkbook()
{
LPDISPATCH result;
InvokeHelper(0x134, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetAddIns()
{
LPDISPATCH result;
InvokeHelper(0x225, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetAssistant()
{
LPDISPATCH result;
InvokeHelper(0x59e, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Application::Calculate()
{
InvokeHelper(0x117, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
LPDISPATCH _Application::GetCells()
{
LPDISPATCH result;
InvokeHelper(0xee, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetCharts()
{
LPDISPATCH result;
InvokeHelper(0x79, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetColumns()
{
LPDISPATCH result;
InvokeHelper(0xf1, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetCommandBars()
{
LPDISPATCH result;
InvokeHelper(0x59f, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long _Application::GetDDEAppReturnCode()
{
long result;
InvokeHelper(0x14c, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::DDEExecute(long Channel, LPCTSTR String)
{
static BYTE parms[] =
VTS_I4 VTS_BSTR;
InvokeHelper(0x14d, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Channel, String);
}
long _Application::DDEInitiate(LPCTSTR App, LPCTSTR Topic)
{
long result;
static BYTE parms[] =
VTS_BSTR VTS_BSTR;
InvokeHelper(0x14e, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
App, Topic);
return result;
}
void _Application::DDEPoke(long Channel, const VARIANT& Item, const VARIANT& Data)
{
static BYTE parms[] =
VTS_I4 VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x14f, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Channel, &Item, &Data);
}
VARIANT _Application::DDERequest(long Channel, LPCTSTR Item)
{
VARIANT result;
static BYTE parms[] =
VTS_I4 VTS_BSTR;
InvokeHelper(0x150, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
Channel, Item);
return result;
}
void _Application::DDETerminate(long Channel)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x151, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Channel);
}
VARIANT _Application::Evaluate(const VARIANT& Name)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x1, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Name);
return result;
}
VARIANT _Application::_Evaluate(const VARIANT& Name)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0xfffffffb, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Name);
return result;
}
VARIANT _Application::ExecuteExcel4Macro(LPCTSTR String)
{
VARIANT result;
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x15e, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
String);
return result;
}
LPDISPATCH _Application::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 result;
static BYTE parms[] =
VTS_DISPATCH VTS_DISPATCH VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x2fe, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
Arg1, Arg2, &Arg3, &Arg4, &Arg5, &Arg6, &Arg7, &Arg8, &Arg9, &Arg10, &Arg11, &Arg12, &Arg13, &Arg14, &Arg15, &Arg16, &Arg17, &Arg18, &Arg19, &Arg20, &Arg21, &Arg22, &Arg23, &Arg24, &Arg25, &Arg26, &Arg27, &Arg28, &Arg29, &Arg30);
return result;
}
LPDISPATCH _Application::GetNames()
{
LPDISPATCH result;
InvokeHelper(0x1ba, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetRange(const VARIANT& Cell1, const VARIANT& Cell2)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0xc5, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, parms,
&Cell1, &Cell2);
return result;
}
LPDISPATCH _Application::GetRows()
{
LPDISPATCH result;
InvokeHelper(0x102, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
VARIANT _Application::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 result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x103, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Macro, &Arg1, &Arg2, &Arg3, &Arg4, &Arg5, &Arg6, &Arg7, &Arg8, &Arg9, &Arg10, &Arg11, &Arg12, &Arg13, &Arg14, &Arg15, &Arg16, &Arg17, &Arg18, &Arg19, &Arg20, &Arg21, &Arg22, &Arg23, &Arg24, &Arg25, &Arg26, &Arg27, &Arg28, &Arg29, &Arg30);
return result;
}
VARIANT _Application::_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)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x326, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Macro, &Arg1, &Arg2, &Arg3, &Arg4, &Arg5, &Arg6, &Arg7, &Arg8, &Arg9, &Arg10, &Arg11, &Arg12, &Arg13, &Arg14, &Arg15, &Arg16, &Arg17, &Arg18, &Arg19, &Arg20, &Arg21, &Arg22, &Arg23, &Arg24, &Arg25, &Arg26, &Arg27, &Arg28, &Arg29, &Arg30);
return result;
}
LPDISPATCH _Application::GetSelection()
{
LPDISPATCH result;
InvokeHelper(0x93, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Application::SendKeys(const VARIANT& Keys, const VARIANT& Wait)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x17f, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Keys, &Wait);
}
LPDISPATCH _Application::GetSheets()
{
LPDISPATCH result;
InvokeHelper(0x1e5, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetThisWorkbook()
{
LPDISPATCH result;
InvokeHelper(0x30a, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::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 result;
static BYTE parms[] =
VTS_DISPATCH VTS_DISPATCH VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x30b, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
Arg1, Arg2, &Arg3, &Arg4, &Arg5, &Arg6, &Arg7, &Arg8, &Arg9, &Arg10, &Arg11, &Arg12, &Arg13, &Arg14, &Arg15, &Arg16, &Arg17, &Arg18, &Arg19, &Arg20, &Arg21, &Arg22, &Arg23, &Arg24, &Arg25, &Arg26, &Arg27, &Arg28, &Arg29, &Arg30);
return result;
}
LPDISPATCH _Application::GetWindows()
{
LPDISPATCH result;
InvokeHelper(0x1ae, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetWorkbooks()
{
LPDISPATCH result;
InvokeHelper(0x23c, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetWorksheetFunction()
{
LPDISPATCH result;
InvokeHelper(0x5a0, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetWorksheets()
{
LPDISPATCH result;
InvokeHelper(0x1ee, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetExcel4IntlMacroSheets()
{
LPDISPATCH result;
InvokeHelper(0x245, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetExcel4MacroSheets()
{
LPDISPATCH result;
InvokeHelper(0x243, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Application::ActivateMicrosoftApp(long Index)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x447, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Index);
}
void _Application::AddCustomList(const VARIANT& ListArray, const VARIANT& ByRow)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x30c, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&ListArray, &ByRow);
}
BOOL _Application::GetAlertBeforeOverwriting()
{
BOOL result;
InvokeHelper(0x3a2, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetAlertBeforeOverwriting(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x3a2, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
CString _Application::GetAltStartupPath()
{
CString result;
InvokeHelper(0x139, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Application::SetAltStartupPath(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x139, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
BOOL _Application::GetAskToUpdateLinks()
{
BOOL result;
InvokeHelper(0x3e0, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetAskToUpdateLinks(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x3e0, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetEnableAnimations()
{
BOOL result;
InvokeHelper(0x49c, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetEnableAnimations(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x49c, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
LPDISPATCH _Application::GetAutoCorrect()
{
LPDISPATCH result;
InvokeHelper(0x479, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long _Application::GetBuild()
{
long result;
InvokeHelper(0x13a, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
BOOL _Application::GetCalculateBeforeSave()
{
BOOL result;
InvokeHelper(0x13b, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetCalculateBeforeSave(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x13b, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Application::GetCalculation()
{
long result;
InvokeHelper(0x13c, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetCalculation(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x13c, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
VARIANT _Application::GetCaller(const VARIANT& Index)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x13d, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, parms,
&Index);
return result;
}
BOOL _Application::GetCanPlaySounds()
{
BOOL result;
InvokeHelper(0x13e, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL _Application::GetCanRecordSounds()
{
BOOL result;
InvokeHelper(0x13f, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
CString _Application::GetCaption()
{
CString result;
InvokeHelper(0x8b, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Application::SetCaption(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x8b, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
BOOL _Application::GetCellDragAndDrop()
{
BOOL result;
InvokeHelper(0x140, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetCellDragAndDrop(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x140, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
double _Application::CentimetersToPoints(double Centimeters)
{
double result;
static BYTE parms[] =
VTS_R8;
InvokeHelper(0x43e, DISPATCH_METHOD, VT_R8, (void*)&result, parms,
Centimeters);
return result;
}
BOOL _Application::CheckSpelling(LPCTSTR Word, const VARIANT& CustomDictionary, const VARIANT& IgnoreUppercase)
{
BOOL result;
static BYTE parms[] =
VTS_BSTR VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x1f9, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
Word, &CustomDictionary, &IgnoreUppercase);
return result;
}
VARIANT _Application::GetClipboardFormats(const VARIANT& Index)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x141, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, parms,
&Index);
return result;
}
BOOL _Application::GetDisplayClipboardWindow()
{
BOOL result;
InvokeHelper(0x142, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetDisplayClipboardWindow(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x142, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Application::GetCommandUnderlines()
{
long result;
InvokeHelper(0x143, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetCommandUnderlines(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x143, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
BOOL _Application::GetConstrainNumeric()
{
BOOL result;
InvokeHelper(0x144, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetConstrainNumeric(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x144, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
VARIANT _Application::ConvertFormula(const VARIANT& Formula, long FromReferenceStyle, const VARIANT& ToReferenceStyle, const VARIANT& ToAbsolute, const VARIANT& RelativeTo)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_I4 VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x145, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Formula, FromReferenceStyle, &ToReferenceStyle, &ToAbsolute, &RelativeTo);
return result;
}
BOOL _Application::GetCopyObjectsWithCells()
{
BOOL result;
InvokeHelper(0x3df, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetCopyObjectsWithCells(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x3df, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Application::GetCursor()
{
long result;
InvokeHelper(0x489, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetCursor(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x489, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
long _Application::GetCustomListCount()
{
long result;
InvokeHelper(0x313, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
long _Application::GetCutCopyMode()
{
long result;
InvokeHelper(0x14a, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetCutCopyMode(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x14a, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
long _Application::GetDataEntryMode()
{
long result;
InvokeHelper(0x14b, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetDataEntryMode(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x14b, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
CString _Application::Get_Default()
{
CString result;
InvokeHelper(0x0, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
CString _Application::GetDefaultFilePath()
{
CString result;
InvokeHelper(0x40e, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Application::SetDefaultFilePath(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x40e, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
void _Application::DeleteCustomList(long ListNum)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x30f, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
ListNum);
}
LPDISPATCH _Application::GetDialogs()
{
LPDISPATCH result;
InvokeHelper(0x2f9, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
BOOL _Application::GetDisplayAlerts()
{
BOOL result;
InvokeHelper(0x157, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetDisplayAlerts(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x157, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetDisplayFormulaBar()
{
BOOL result;
InvokeHelper(0x158, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetDisplayFormulaBar(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x158, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetDisplayFullScreen()
{
BOOL result;
InvokeHelper(0x425, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetDisplayFullScreen(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x425, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetDisplayNoteIndicator()
{
BOOL result;
InvokeHelper(0x159, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetDisplayNoteIndicator(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x159, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Application::GetDisplayCommentIndicator()
{
long result;
InvokeHelper(0x4ac, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetDisplayCommentIndicator(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x4ac, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
BOOL _Application::GetDisplayExcel4Menus()
{
BOOL result;
InvokeHelper(0x39f, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetDisplayExcel4Menus(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x39f, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetDisplayRecentFiles()
{
BOOL result;
InvokeHelper(0x39e, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetDisplayRecentFiles(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x39e, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetDisplayScrollBars()
{
BOOL result;
InvokeHelper(0x15a, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetDisplayScrollBars(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x15a, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetDisplayStatusBar()
{
BOOL result;
InvokeHelper(0x15b, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetDisplayStatusBar(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x15b, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
void _Application::DoubleClick()
{
InvokeHelper(0x15d, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
BOOL _Application::GetEditDirectlyInCell()
{
BOOL result;
InvokeHelper(0x3a1, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetEditDirectlyInCell(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x3a1, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetEnableAutoComplete()
{
BOOL result;
InvokeHelper(0x49b, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetEnableAutoComplete(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x49b, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Application::GetEnableCancelKey()
{
long result;
InvokeHelper(0x448, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetEnableCancelKey(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x448, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
BOOL _Application::GetEnableSound()
{
BOOL result;
InvokeHelper(0x4ad, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetEnableSound(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x4ad, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
VARIANT _Application::GetFileConverters(const VARIANT& Index1, const VARIANT& Index2)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x3a3, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, parms,
&Index1, &Index2);
return result;
}
BOOL _Application::GetFixedDecimal()
{
BOOL result;
InvokeHelper(0x15f, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetFixedDecimal(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x15f, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Application::GetFixedDecimalPlaces()
{
long result;
InvokeHelper(0x160, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetFixedDecimalPlaces(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x160, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
VARIANT _Application::GetCustomListContents(long ListNum)
{
VARIANT result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x312, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
ListNum);
return result;
}
long _Application::GetCustomListNum(const VARIANT& ListArray)
{
long result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x311, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
&ListArray);
return result;
}
VARIANT _Application::GetOpenFilename(const VARIANT& FileFilter, const VARIANT& FilterIndex, const VARIANT& Title, const VARIANT& ButtonText, const VARIANT& MultiSelect)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x433, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&FileFilter, &FilterIndex, &Title, &ButtonText, &MultiSelect);
return result;
}
VARIANT _Application::GetSaveAsFilename(const VARIANT& InitialFilename, const VARIANT& FileFilter, const VARIANT& FilterIndex, const VARIANT& Title, const VARIANT& ButtonText)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x434, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&InitialFilename, &FileFilter, &FilterIndex, &Title, &ButtonText);
return result;
}
void _Application::Goto(const VARIANT& Reference, const VARIANT& Scroll)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x1db, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Reference, &Scroll);
}
double _Application::GetHeight()
{
double result;
InvokeHelper(0x7b, DISPATCH_PROPERTYGET, VT_R8, (void*)&result, NULL);
return result;
}
void _Application::SetHeight(double newValue)
{
static BYTE parms[] =
VTS_R8;
InvokeHelper(0x7b, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
newValue);
}
void _Application::Help(const VARIANT& HelpFile, const VARIANT& HelpContextID)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x162, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&HelpFile, &HelpContextID);
}
BOOL _Application::GetIgnoreRemoteRequests()
{
BOOL result;
InvokeHelper(0x164, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetIgnoreRemoteRequests(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x164, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
double _Application::InchesToPoints(double Inches)
{
double result;
static BYTE parms[] =
VTS_R8;
InvokeHelper(0x43f, DISPATCH_METHOD, VT_R8, (void*)&result, parms,
Inches);
return result;
}
VARIANT _Application::InputBox(LPCTSTR Prompt, const VARIANT& Title, const VARIANT& Default, const VARIANT& Left, const VARIANT& Top, const VARIANT& HelpFile, const VARIANT& HelpContextID, const VARIANT& Type)
{
VARIANT result;
static BYTE parms[] =
VTS_BSTR VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x165, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
Prompt, &Title, &Default, &Left, &Top, &HelpFile, &HelpContextID, &Type);
return result;
}
BOOL _Application::GetInteractive()
{
BOOL result;
InvokeHelper(0x169, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetInteractive(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x169, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
VARIANT _Application::GetInternational(const VARIANT& Index)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x16a, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, parms,
&Index);
return result;
}
BOOL _Application::GetIteration()
{
BOOL result;
InvokeHelper(0x16b, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetIteration(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x16b, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
double _Application::GetLeft()
{
double result;
InvokeHelper(0x7f, DISPATCH_PROPERTYGET, VT_R8, (void*)&result, NULL);
return result;
}
void _Application::SetLeft(double newValue)
{
static BYTE parms[] =
VTS_R8;
InvokeHelper(0x7f, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
newValue);
}
CString _Application::GetLibraryPath()
{
CString result;
InvokeHelper(0x16e, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Application::MacroOptions(const VARIANT& Macro, const VARIANT& Description, const VARIANT& HasMenu, const VARIANT& MenuText, const VARIANT& HasShortcutKey, const VARIANT& ShortcutKey, const VARIANT& Category, const VARIANT& StatusBar,
const VARIANT& HelpContextID, const VARIANT& HelpFile)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x46f, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Macro, &Description, &HasMenu, &MenuText, &HasShortcutKey, &ShortcutKey, &Category, &StatusBar, &HelpContextID, &HelpFile);
}
void _Application::MailLogoff()
{
InvokeHelper(0x3b1, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void _Application::MailLogon(const VARIANT& Name, const VARIANT& Password, const VARIANT& DownloadNewMail)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x3af, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Name, &Password, &DownloadNewMail);
}
VARIANT _Application::GetMailSession()
{
VARIANT result;
InvokeHelper(0x3ae, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
long _Application::GetMailSystem()
{
long result;
InvokeHelper(0x3cb, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
BOOL _Application::GetMathCoprocessorAvailable()
{
BOOL result;
InvokeHelper(0x16f, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
double _Application::GetMaxChange()
{
double result;
InvokeHelper(0x170, DISPATCH_PROPERTYGET, VT_R8, (void*)&result, NULL);
return result;
}
void _Application::SetMaxChange(double newValue)
{
static BYTE parms[] =
VTS_R8;
InvokeHelper(0x170, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
newValue);
}
long _Application::GetMaxIterations()
{
long result;
InvokeHelper(0x171, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetMaxIterations(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x171, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
BOOL _Application::GetMouseAvailable()
{
BOOL result;
InvokeHelper(0x175, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL _Application::GetMoveAfterReturn()
{
BOOL result;
InvokeHelper(0x176, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetMoveAfterReturn(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x176, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Application::GetMoveAfterReturnDirection()
{
long result;
InvokeHelper(0x478, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetMoveAfterReturnDirection(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x478, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
LPDISPATCH _Application::GetRecentFiles()
{
LPDISPATCH result;
InvokeHelper(0x4b2, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
CString _Application::GetName()
{
CString result;
InvokeHelper(0x6e, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::NextLetter()
{
LPDISPATCH result;
InvokeHelper(0x3cc, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, NULL);
return result;
}
CString _Application::GetNetworkTemplatesPath()
{
CString result;
InvokeHelper(0x184, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetODBCErrors()
{
LPDISPATCH result;
InvokeHelper(0x4b3, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long _Application::GetODBCTimeout()
{
long result;
InvokeHelper(0x4b4, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetODBCTimeout(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x4b4, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
void _Application::OnKey(LPCTSTR Key, const VARIANT& Procedure)
{
static BYTE parms[] =
VTS_BSTR VTS_VARIANT;
InvokeHelper(0x272, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Key, &Procedure);
}
void _Application::OnRepeat(LPCTSTR Text, LPCTSTR Procedure)
{
static BYTE parms[] =
VTS_BSTR VTS_BSTR;
InvokeHelper(0x301, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Text, Procedure);
}
void _Application::OnTime(const VARIANT& EarliestTime, LPCTSTR Procedure, const VARIANT& LatestTime, const VARIANT& Schedule)
{
static BYTE parms[] =
VTS_VARIANT VTS_BSTR VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x270, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&EarliestTime, Procedure, &LatestTime, &Schedule);
}
void _Application::OnUndo(LPCTSTR Text, LPCTSTR Procedure)
{
static BYTE parms[] =
VTS_BSTR VTS_BSTR;
InvokeHelper(0x302, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Text, Procedure);
}
CString _Application::GetOnWindow()
{
CString result;
InvokeHelper(0x26f, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Application::SetOnWindow(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x26f, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
CString _Application::GetOperatingSystem()
{
CString result;
InvokeHelper(0x177, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
CString _Application::GetOrganizationName()
{
CString result;
InvokeHelper(0x178, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
CString _Application::GetPath()
{
CString result;
InvokeHelper(0x123, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
CString _Application::GetPathSeparator()
{
CString result;
InvokeHelper(0x179, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
VARIANT _Application::GetPreviousSelections(const VARIANT& Index)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x17a, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, parms,
&Index);
return result;
}
BOOL _Application::GetPivotTableSelection()
{
BOOL result;
InvokeHelper(0x4b5, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetPivotTableSelection(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x4b5, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetPromptForSummaryInfo()
{
BOOL result;
InvokeHelper(0x426, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetPromptForSummaryInfo(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x426, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
void _Application::Quit()
{
InvokeHelper(0x12e, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void _Application::RecordMacro(const VARIANT& BasicCode, const VARIANT& XlmCode)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x305, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&BasicCode, &XlmCode);
}
BOOL _Application::GetRecordRelative()
{
BOOL result;
InvokeHelper(0x17b, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
long _Application::GetReferenceStyle()
{
long result;
InvokeHelper(0x17c, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetReferenceStyle(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x17c, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
VARIANT _Application::GetRegisteredFunctions(const VARIANT& Index1, const VARIANT& Index2)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x307, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, parms,
&Index1, &Index2);
return result;
}
BOOL _Application::RegisterXLL(LPCTSTR Filename)
{
BOOL result;
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x1e, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
Filename);
return result;
}
void _Application::Repeat()
{
InvokeHelper(0x12d, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
BOOL _Application::GetRollZoom()
{
BOOL result;
InvokeHelper(0x4b6, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetRollZoom(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x4b6, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
void _Application::SaveWorkspace(const VARIANT& Filename)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0xd4, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Filename);
}
BOOL _Application::GetScreenUpdating()
{
BOOL result;
InvokeHelper(0x17e, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetScreenUpdating(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x17e, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Application::GetSheetsInNewWorkbook()
{
long result;
InvokeHelper(0x3e1, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetSheetsInNewWorkbook(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x3e1, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
BOOL _Application::GetShowChartTipNames()
{
BOOL result;
InvokeHelper(0x4b7, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetShowChartTipNames(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x4b7, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetShowChartTipValues()
{
BOOL result;
InvokeHelper(0x4b8, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetShowChartTipValues(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x4b8, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
CString _Application::GetStandardFont()
{
CString result;
InvokeHelper(0x39c, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Application::SetStandardFont(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x39c, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
double _Application::GetStandardFontSize()
{
double result;
InvokeHelper(0x39d, DISPATCH_PROPERTYGET, VT_R8, (void*)&result, NULL);
return result;
}
void _Application::SetStandardFontSize(double newValue)
{
static BYTE parms[] =
VTS_R8;
InvokeHelper(0x39d, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
newValue);
}
CString _Application::GetStartupPath()
{
CString result;
InvokeHelper(0x181, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
VARIANT _Application::GetStatusBar()
{
VARIANT result;
InvokeHelper(0x182, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void _Application::SetStatusBar(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x182, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
CString _Application::GetTemplatesPath()
{
CString result;
InvokeHelper(0x17d, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
BOOL _Application::GetShowToolTips()
{
BOOL result;
InvokeHelper(0x183, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetShowToolTips(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x183, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
double _Application::GetTop()
{
double result;
InvokeHelper(0x7e, DISPATCH_PROPERTYGET, VT_R8, (void*)&result, NULL);
return result;
}
void _Application::SetTop(double newValue)
{
static BYTE parms[] =
VTS_R8;
InvokeHelper(0x7e, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
newValue);
}
long _Application::GetDefaultSaveFormat()
{
long result;
InvokeHelper(0x4b9, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetDefaultSaveFormat(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x4b9, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
CString _Application::GetTransitionMenuKey()
{
CString result;
InvokeHelper(0x136, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Application::SetTransitionMenuKey(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x136, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
long _Application::GetTransitionMenuKeyAction()
{
long result;
InvokeHelper(0x137, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetTransitionMenuKeyAction(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x137, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
BOOL _Application::GetTransitionNavigKeys()
{
BOOL result;
InvokeHelper(0x138, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetTransitionNavigKeys(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x138, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
void _Application::Undo()
{
InvokeHelper(0x12f, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
double _Application::GetUsableHeight()
{
double result;
InvokeHelper(0x185, DISPATCH_PROPERTYGET, VT_R8, (void*)&result, NULL);
return result;
}
double _Application::GetUsableWidth()
{
double result;
InvokeHelper(0x186, DISPATCH_PROPERTYGET, VT_R8, (void*)&result, NULL);
return result;
}
BOOL _Application::GetUserControl()
{
BOOL result;
InvokeHelper(0x4ba, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetUserControl(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x4ba, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
CString _Application::GetUserName_()
{
CString result;
InvokeHelper(0x187, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Application::SetUserName(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x187, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
CString _Application::GetValue()
{
CString result;
InvokeHelper(0x6, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetVbe()
{
LPDISPATCH result;
InvokeHelper(0x4bb, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
CString _Application::GetVersion()
{
CString result;
InvokeHelper(0x188, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
BOOL _Application::GetVisible()
{
BOOL result;
InvokeHelper(0x22e, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetVisible(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x22e, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
void _Application::Volatile(const VARIANT& Volatile)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x314, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Volatile);
}
double _Application::GetWidth()
{
double result;
InvokeHelper(0x7a, DISPATCH_PROPERTYGET, VT_R8, (void*)&result, NULL);
return result;
}
void _Application::SetWidth(double newValue)
{
static BYTE parms[] =
VTS_R8;
InvokeHelper(0x7a, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
newValue);
}
BOOL _Application::GetWindowsForPens()
{
BOOL result;
InvokeHelper(0x18b, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
long _Application::GetWindowState()
{
long result;
InvokeHelper(0x18c, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetWindowState(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x18c, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
long _Application::GetDefaultSheetDirection()
{
long result;
InvokeHelper(0xe5, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetDefaultSheetDirection(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0xe5, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
long _Application::GetCursorMovement()
{
long result;
InvokeHelper(0xe8, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetCursorMovement(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0xe8, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
BOOL _Application::GetControlCharacters()
{
BOOL result;
InvokeHelper(0xe9, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetControlCharacters(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0xe9, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetEnableEvents()
{
BOOL result;
InvokeHelper(0x4bc, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetEnableEvents(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x4bc, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::Wait(const VARIANT& Time)
{
BOOL result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x6ea, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
&Time);
return result;
}
BOOL _Application::GetExtendList()
{
BOOL result;
InvokeHelper(0x701, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetExtendList(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x701, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
LPDISPATCH _Application::GetOLEDBErrors()
{
LPDISPATCH result;
InvokeHelper(0x702, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
CString _Application::GetPhonetic(const VARIANT& Text)
{
CString result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x703, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
&Text);
return result;
}
LPDISPATCH _Application::GetCOMAddIns()
{
LPDISPATCH result;
InvokeHelper(0x704, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetDefaultWebOptions()
{
LPDISPATCH result;
InvokeHelper(0x705, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
CString _Application::GetProductCode()
{
CString result;
InvokeHelper(0x706, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
CString _Application::GetUserLibraryPath()
{
CString result;
InvokeHelper(0x707, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
BOOL _Application::GetAutoPercentEntry()
{
BOOL result;
InvokeHelper(0x708, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetAutoPercentEntry(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x708, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
LPDISPATCH _Application::GetLanguageSettings()
{
LPDISPATCH result;
InvokeHelper(0x709, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetAnswerWizard()
{
LPDISPATCH result;
InvokeHelper(0x70c, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Application::CalculateFull()
{
InvokeHelper(0x70d, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
BOOL _Application::FindFile()
{
BOOL result;
InvokeHelper(0x6eb, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
return result;
}
long _Application::GetCalculationVersion()
{
long result;
InvokeHelper(0x70e, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
BOOL _Application::GetShowWindowsInTaskbar()
{
BOOL result;
InvokeHelper(0x70f, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetShowWindowsInTaskbar(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x70f, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Application::GetFeatureInstall()
{
long result;
InvokeHelper(0x710, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetFeatureInstall(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x710, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
BOOL _Application::GetReady()
{
BOOL result;
InvokeHelper(0x78c, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetFindFormat()
{
LPDISPATCH result;
InvokeHelper(0x78e, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Application::SetRefFindFormat(LPDISPATCH newValue)
{
static BYTE parms[] =
VTS_DISPATCH;
InvokeHelper(0x78e, DISPATCH_PROPERTYPUTREF, VT_EMPTY, NULL, parms,
newValue);
}
LPDISPATCH _Application::GetReplaceFormat()
{
LPDISPATCH result;
InvokeHelper(0x78f, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Application::SetRefReplaceFormat(LPDISPATCH newValue)
{
static BYTE parms[] =
VTS_DISPATCH;
InvokeHelper(0x78f, DISPATCH_PROPERTYPUTREF, VT_EMPTY, NULL, parms,
newValue);
}
LPDISPATCH _Application::GetUsedObjects()
{
LPDISPATCH result;
InvokeHelper(0x790, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long _Application::GetCalculationState()
{
long result;
InvokeHelper(0x791, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
long _Application::GetCalculationInterruptKey()
{
long result;
InvokeHelper(0x792, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetCalculationInterruptKey(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x792, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
LPDISPATCH _Application::GetWatches()
{
LPDISPATCH result;
InvokeHelper(0x793, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
BOOL _Application::GetDisplayFunctionToolTips()
{
BOOL result;
InvokeHelper(0x794, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetDisplayFunctionToolTips(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x794, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Application::GetAutomationSecurity()
{
long result;
InvokeHelper(0x795, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetAutomationSecurity(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x795, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
LPDISPATCH _Application::GetFileDialog(long fileDialogType)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x796, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, parms,
fileDialogType);
return result;
}
void _Application::CalculateFullRebuild()
{
InvokeHelper(0x799, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
BOOL _Application::GetDisplayPasteOptions()
{
BOOL result;
InvokeHelper(0x79a, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetDisplayPasteOptions(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x79a, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetDisplayInsertOptions()
{
BOOL result;
InvokeHelper(0x79b, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetDisplayInsertOptions(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x79b, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetGenerateGetPivotData()
{
BOOL result;
InvokeHelper(0x79c, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetGenerateGetPivotData(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x79c, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
LPDISPATCH _Application::GetAutoRecover()
{
LPDISPATCH result;
InvokeHelper(0x79d, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long _Application::GetHwnd()
{
long result;
InvokeHelper(0x79e, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
long _Application::GetHinstance()
{
long result;
InvokeHelper(0x79f, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::CheckAbort(const VARIANT& KeepAbort)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x7a0, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&KeepAbort);
}
LPDISPATCH _Application::GetErrorCheckingOptions()
{
LPDISPATCH result;
InvokeHelper(0x7a2, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
BOOL _Application::GetAutoFormatAsYouTypeReplaceHyperlinks()
{
BOOL result;
InvokeHelper(0x7a3, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetAutoFormatAsYouTypeReplaceHyperlinks(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x7a3, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
LPDISPATCH _Application::GetSmartTagRecognizers()
{
LPDISPATCH result;
InvokeHelper(0x7a4, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetNewWorkbook()
{
LPDISPATCH result;
InvokeHelper(0x61d, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetSpellingOptions()
{
LPDISPATCH result;
InvokeHelper(0x7a5, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetSpeech()
{
LPDISPATCH result;
InvokeHelper(0x7a6, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
BOOL _Application::GetMapPaperSize()
{
BOOL result;
InvokeHelper(0x7a7, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetMapPaperSize(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x7a7, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetShowStartupDialog()
{
BOOL result;
InvokeHelper(0x7a8, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetShowStartupDialog(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x7a8, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
CString _Application::GetDecimalSeparator()
{
CString result;
InvokeHelper(0x711, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Application::SetDecimalSeparator(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x711, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
CString _Application::GetThousandsSeparator()
{
CString result;
InvokeHelper(0x712, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Application::SetThousandsSeparator(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x712, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
BOOL _Application::GetUseSystemSeparators()
{
BOOL result;
InvokeHelper(0x7a9, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetUseSystemSeparators(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x7a9, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
LPDISPATCH _Application::GetThisCell()
{
LPDISPATCH result;
InvokeHelper(0x7aa, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Application::GetRtd()
{
LPDISPATCH result;
InvokeHelper(0x7ab, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
BOOL _Application::GetDisplayDocumentActionTaskPane()
{
BOOL result;
InvokeHelper(0x8cb, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetDisplayDocumentActionTaskPane(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x8cb, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
void _Application::DisplayXMLSourcePane(const VARIANT& XmlMap)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x8cc, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&XmlMap);
}
BOOL _Application::GetArbitraryXMLSupportAvailable()
{
BOOL result;
InvokeHelper(0x8ce, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
long _Application::GetMeasurementUnit()
{
long result;
InvokeHelper(0x947, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetMeasurementUnit(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x947, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
BOOL _Application::GetShowSelectionFloaties()
{
BOOL result;
InvokeHelper(0x948, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetShowSelectionFloaties(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x948, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetShowMenuFloaties()
{
BOOL result;
InvokeHelper(0x949, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetShowMenuFloaties(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x949, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetShowDevTools()
{
BOOL result;
InvokeHelper(0x94a, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetShowDevTools(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x94a, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetEnableLivePreview()
{
BOOL result;
InvokeHelper(0x94b, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetEnableLivePreview(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x94b, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetDisplayDocumentInformationPanel()
{
BOOL result;
InvokeHelper(0x94c, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetDisplayDocumentInformationPanel(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x94c, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetAlwaysUseClearType()
{
BOOL result;
InvokeHelper(0x94d, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetAlwaysUseClearType(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x94d, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Application::GetWarnOnFunctionNameConflict()
{
BOOL result;
InvokeHelper(0x94e, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetWarnOnFunctionNameConflict(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x94e, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Application::GetFormulaBarHeight()
{
long result;
InvokeHelper(0x94f, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetFormulaBarHeight(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x94f, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
BOOL _Application::GetDisplayFormulaAutoComplete()
{
BOOL result;
InvokeHelper(0x950, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetDisplayFormulaAutoComplete(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x950, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Application::GetGenerateTableRefs()
{
long result;
InvokeHelper(0x951, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetGenerateTableRefs(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x951, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
LPDISPATCH _Application::GetAssistance()
{
LPDISPATCH result;
InvokeHelper(0x952, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Application::CalculateUntilAsyncQueriesDone()
{
InvokeHelper(0x953, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
BOOL _Application::GetEnableLargeOperationAlert()
{
BOOL result;
InvokeHelper(0x954, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetEnableLargeOperationAlert(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x954, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Application::GetLargeOperationCellThousandCount()
{
long result;
InvokeHelper(0x955, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Application::SetLargeOperationCellThousandCount(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x955, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
BOOL _Application::GetDeferAsyncQueries()
{
BOOL result;
InvokeHelper(0x956, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetDeferAsyncQueries(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x956, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
LPDISPATCH _Application::GetMultiThreadedCalculation()
{
LPDISPATCH result;
InvokeHelper(0x957, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long _Application::SharePointVersion(LPCTSTR bstrUrl)
{
long result;
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x958, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
bstrUrl);
return result;
}
long _Application::GetActiveEncryptionSession()
{
long result;
InvokeHelper(0x95a, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
BOOL _Application::GetHighQualityModeForGraphics()
{
BOOL result;
InvokeHelper(0x95b, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Application::SetHighQualityModeForGraphics(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x95b, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
/////////////////////////////////////////////////////////////////////////////
// _Worksheet properties
/////////////////////////////////////////////////////////////////////////////
// _Worksheet operations
LPDISPATCH _Worksheet::GetApplication()
{
LPDISPATCH result;
InvokeHelper(0x94, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long _Worksheet::GetCreator()
{
long result;
InvokeHelper(0x95, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
LPDISPATCH _Worksheet::GetParent()
{
LPDISPATCH result;
InvokeHelper(0x96, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Worksheet::Activate()
{
InvokeHelper(0x130, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void _Worksheet::Copy(const VARIANT& Before, const VARIANT& After)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x227, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Before, &After);
}
void _Worksheet::Delete()
{
InvokeHelper(0x75, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
CString _Worksheet::GetCodeName()
{
CString result;
InvokeHelper(0x55d, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
CString _Worksheet::Get_CodeName()
{
CString result;
InvokeHelper(0x80010000, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Worksheet::Set_CodeName(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x80010000, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
long _Worksheet::GetIndex()
{
long result;
InvokeHelper(0x1e6, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Worksheet::Move(const VARIANT& Before, const VARIANT& After)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x27d, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Before, &After);
}
CString _Worksheet::GetName()
{
CString result;
InvokeHelper(0x6e, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Worksheet::SetName(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x6e, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
LPDISPATCH _Worksheet::GetNext()
{
LPDISPATCH result;
InvokeHelper(0x1f6, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Worksheet::GetPageSetup()
{
LPDISPATCH result;
InvokeHelper(0x3e6, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Worksheet::GetPrevious()
{
LPDISPATCH result;
InvokeHelper(0x1f7, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Worksheet::PrintPreview(const VARIANT& EnableChanges)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x119, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&EnableChanges);
}
BOOL _Worksheet::GetProtectContents()
{
BOOL result;
InvokeHelper(0x124, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL _Worksheet::GetProtectDrawingObjects()
{
BOOL result;
InvokeHelper(0x125, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL _Worksheet::GetProtectionMode()
{
BOOL result;
InvokeHelper(0x487, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL _Worksheet::GetProtectScenarios()
{
BOOL result;
InvokeHelper(0x126, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Worksheet::Select(const VARIANT& Replace)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0xeb, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Replace);
}
void _Worksheet::Unprotect(const VARIANT& Password)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x11d, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Password);
}
long _Worksheet::GetVisible()
{
long result;
InvokeHelper(0x22e, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Worksheet::SetVisible(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x22e, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
LPDISPATCH _Worksheet::GetShapes()
{
LPDISPATCH result;
InvokeHelper(0x561, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
BOOL _Worksheet::GetTransitionExpEval()
{
BOOL result;
InvokeHelper(0x191, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Worksheet::SetTransitionExpEval(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x191, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Worksheet::GetAutoFilterMode()
{
BOOL result;
InvokeHelper(0x318, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Worksheet::SetAutoFilterMode(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x318, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
void _Worksheet::SetBackgroundPicture(LPCTSTR Filename)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x4a4, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Filename);
}
void _Worksheet::Calculate()
{
InvokeHelper(0x117, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
BOOL _Worksheet::GetEnableCalculation()
{
BOOL result;
InvokeHelper(0x590, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Worksheet::SetEnableCalculation(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x590, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
LPDISPATCH _Worksheet::GetCells()
{
LPDISPATCH result;
InvokeHelper(0xee, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Worksheet::ChartObjects(const VARIANT& Index)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x424, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
&Index);
return result;
}
void _Worksheet::CheckSpelling(const VARIANT& CustomDictionary, const VARIANT& IgnoreUppercase, const VARIANT& AlwaysSuggest, const VARIANT& SpellLang)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x1f9, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&CustomDictionary, &IgnoreUppercase, &AlwaysSuggest, &SpellLang);
}
LPDISPATCH _Worksheet::GetCircularReference()
{
LPDISPATCH result;
InvokeHelper(0x42d, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Worksheet::ClearArrows()
{
InvokeHelper(0x3ca, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
LPDISPATCH _Worksheet::GetColumns()
{
LPDISPATCH result;
InvokeHelper(0xf1, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long _Worksheet::GetConsolidationFunction()
{
long result;
InvokeHelper(0x315, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
VARIANT _Worksheet::GetConsolidationOptions()
{
VARIANT result;
InvokeHelper(0x316, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT _Worksheet::GetConsolidationSources()
{
VARIANT result;
InvokeHelper(0x317, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
BOOL _Worksheet::GetEnableAutoFilter()
{
BOOL result;
InvokeHelper(0x484, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Worksheet::SetEnableAutoFilter(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x484, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Worksheet::GetEnableSelection()
{
long result;
InvokeHelper(0x591, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Worksheet::SetEnableSelection(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x591, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
BOOL _Worksheet::GetEnableOutlining()
{
BOOL result;
InvokeHelper(0x485, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Worksheet::SetEnableOutlining(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x485, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Worksheet::GetEnablePivotTable()
{
BOOL result;
InvokeHelper(0x486, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Worksheet::SetEnablePivotTable(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x486, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
VARIANT _Worksheet::Evaluate(const VARIANT& Name)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x1, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Name);
return result;
}
VARIANT _Worksheet::_Evaluate(const VARIANT& Name)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0xfffffffb, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Name);
return result;
}
BOOL _Worksheet::GetFilterMode()
{
BOOL result;
InvokeHelper(0x320, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Worksheet::ResetAllPageBreaks()
{
InvokeHelper(0x592, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
LPDISPATCH _Worksheet::GetNames()
{
LPDISPATCH result;
InvokeHelper(0x1ba, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Worksheet::OLEObjects(const VARIANT& Index)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x31f, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
&Index);
return result;
}
LPDISPATCH _Worksheet::GetOutline()
{
LPDISPATCH result;
InvokeHelper(0x66, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Worksheet::Paste(const VARIANT& Destination, const VARIANT& Link)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0xd3, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Destination, &Link);
}
LPDISPATCH _Worksheet::PivotTables(const VARIANT& Index)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x2b2, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
&Index);
return result;
}
LPDISPATCH _Worksheet::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 result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x2ac, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
&SourceType, &SourceData, &TableDestination, &TableName, &RowGrand, &ColumnGrand, &SaveData, &HasAutoFormat, &AutoPage, &Reserved, &BackgroundQuery, &OptimizeCache, &PageFieldOrder, &PageFieldWrapCount, &ReadData, &Connection);
return result;
}
LPDISPATCH _Worksheet::GetRange(const VARIANT& Cell1, const VARIANT& Cell2)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0xc5, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, parms,
&Cell1, &Cell2);
return result;
}
LPDISPATCH _Worksheet::GetRows()
{
LPDISPATCH result;
InvokeHelper(0x102, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Worksheet::Scenarios(const VARIANT& Index)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x38c, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
&Index);
return result;
}
CString _Worksheet::GetScrollArea()
{
CString result;
InvokeHelper(0x599, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Worksheet::SetScrollArea(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x599, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
void _Worksheet::ShowAllData()
{
InvokeHelper(0x31a, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void _Worksheet::ShowDataForm()
{
InvokeHelper(0x199, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
double _Worksheet::GetStandardHeight()
{
double result;
InvokeHelper(0x197, DISPATCH_PROPERTYGET, VT_R8, (void*)&result, NULL);
return result;
}
double _Worksheet::GetStandardWidth()
{
double result;
InvokeHelper(0x198, DISPATCH_PROPERTYGET, VT_R8, (void*)&result, NULL);
return result;
}
void _Worksheet::SetStandardWidth(double newValue)
{
static BYTE parms[] =
VTS_R8;
InvokeHelper(0x198, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
newValue);
}
BOOL _Worksheet::GetTransitionFormEntry()
{
BOOL result;
InvokeHelper(0x192, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Worksheet::SetTransitionFormEntry(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x192, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Worksheet::GetType()
{
long result;
InvokeHelper(0x6c, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
LPDISPATCH _Worksheet::GetUsedRange()
{
LPDISPATCH result;
InvokeHelper(0x19c, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Worksheet::GetHPageBreaks()
{
LPDISPATCH result;
InvokeHelper(0x58a, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Worksheet::GetVPageBreaks()
{
LPDISPATCH result;
InvokeHelper(0x58b, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Worksheet::GetQueryTables()
{
LPDISPATCH result;
InvokeHelper(0x59a, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
BOOL _Worksheet::GetDisplayPageBreaks()
{
BOOL result;
InvokeHelper(0x59b, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Worksheet::SetDisplayPageBreaks(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x59b, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
LPDISPATCH _Worksheet::GetComments()
{
LPDISPATCH result;
InvokeHelper(0x23f, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Worksheet::GetHyperlinks()
{
LPDISPATCH result;
InvokeHelper(0x571, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Worksheet::ClearCircles()
{
InvokeHelper(0x59c, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void _Worksheet::CircleInvalid()
{
InvokeHelper(0x59d, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
LPDISPATCH _Worksheet::GetAutoFilter()
{
LPDISPATCH result;
InvokeHelper(0x319, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
BOOL _Worksheet::GetDisplayRightToLeft()
{
BOOL result;
InvokeHelper(0x6ee, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Worksheet::SetDisplayRightToLeft(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x6ee, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
LPDISPATCH _Worksheet::GetTab()
{
LPDISPATCH result;
InvokeHelper(0x411, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Worksheet::GetMailEnvelope()
{
LPDISPATCH result;
InvokeHelper(0x7e5, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Worksheet::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)
{
static BYTE parms[] =
VTS_BSTR VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x785, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Filename, &FileFormat, &Password, &WriteResPassword, &ReadOnlyRecommended, &CreateBackup, &AddToMru, &TextCodepage, &TextVisualLayout, &Local);
}
LPDISPATCH _Worksheet::GetCustomProperties()
{
LPDISPATCH result;
InvokeHelper(0x7ee, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Worksheet::GetSmartTags()
{
LPDISPATCH result;
InvokeHelper(0x7e0, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Worksheet::GetProtection()
{
LPDISPATCH result;
InvokeHelper(0xb0, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Worksheet::PasteSpecial(const VARIANT& Format, const VARIANT& Link, const VARIANT& DisplayAsIcon, const VARIANT& IconFileName, const VARIANT& IconIndex, const VARIANT& IconLabel, const VARIANT& NoHTMLFormatting)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x788, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Format, &Link, &DisplayAsIcon, &IconFileName, &IconIndex, &IconLabel, &NoHTMLFormatting);
}
void _Worksheet::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)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x7ed, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Password, &DrawingObjects, &Contents, &Scenarios, &UserInterfaceOnly, &AllowFormattingCells, &AllowFormattingColumns, &AllowFormattingRows, &AllowInsertingColumns, &AllowInsertingRows, &AllowInsertingHyperlinks, &AllowDeletingColumns,
&AllowDeletingRows, &AllowSorting, &AllowFiltering, &AllowUsingPivotTables);
}
LPDISPATCH _Worksheet::GetListObjects()
{
LPDISPATCH result;
InvokeHelper(0x8d3, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Worksheet::XmlDataQuery(LPCTSTR XPath, const VARIANT& SelectionNamespaces, const VARIANT& Map)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_BSTR VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x8d4, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
XPath, &SelectionNamespaces, &Map);
return result;
}
LPDISPATCH _Worksheet::XmlMapQuery(LPCTSTR XPath, const VARIANT& SelectionNamespaces, const VARIANT& Map)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_BSTR VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x8d7, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
XPath, &SelectionNamespaces, &Map);
return result;
}
void _Worksheet::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,
const VARIANT& IgnorePrintAreas)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x939, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&From, &To, &Copies, &Preview, &ActivePrinter, &PrintToFile, &Collate, &PrToFileName, &IgnorePrintAreas);
}
BOOL _Worksheet::GetEnableFormatConditionsCalculation()
{
BOOL result;
InvokeHelper(0x9cf, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Worksheet::SetEnableFormatConditionsCalculation(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x9cf, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
LPDISPATCH _Worksheet::GetSort()
{
LPDISPATCH result;
InvokeHelper(0x370, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Worksheet::ExportAsFixedFormat(long Type, const VARIANT& Filename, const VARIANT& Quality, const VARIANT& IncludeDocProperties, const VARIANT& IgnorePrintAreas, const VARIANT& From, const VARIANT& To, const VARIANT& OpenAfterPublish,
const VARIANT& FixedFormatExtClassPtr)
{
static BYTE parms[] =
VTS_I4 VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x9bd, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Type, &Filename, &Quality, &IncludeDocProperties, &IgnorePrintAreas, &From, &To, &OpenAfterPublish, &FixedFormatExtClassPtr);
}
/////////////////////////////////////////////////////////////////////////////
// _Workbook properties
/////////////////////////////////////////////////////////////////////////////
// _Workbook operations
LPDISPATCH _Workbook::GetApplication()
{
LPDISPATCH result;
InvokeHelper(0x94, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long _Workbook::GetCreator()
{
long result;
InvokeHelper(0x95, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetParent()
{
LPDISPATCH result;
InvokeHelper(0x96, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Workbook::Activate()
{
InvokeHelper(0x130, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
LPDISPATCH _Workbook::GetActiveChart()
{
LPDISPATCH result;
InvokeHelper(0xb7, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetActiveSheet()
{
LPDISPATCH result;
InvokeHelper(0x133, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long _Workbook::GetAutoUpdateFrequency()
{
long result;
InvokeHelper(0x5a2, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Workbook::SetAutoUpdateFrequency(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x5a2, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
BOOL _Workbook::GetAutoUpdateSaveChanges()
{
BOOL result;
InvokeHelper(0x5a3, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetAutoUpdateSaveChanges(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x5a3, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Workbook::GetChangeHistoryDuration()
{
long result;
InvokeHelper(0x5a4, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Workbook::SetChangeHistoryDuration(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x5a4, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
LPDISPATCH _Workbook::GetBuiltinDocumentProperties()
{
LPDISPATCH result;
InvokeHelper(0x498, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Workbook::ChangeFileAccess(long Mode, const VARIANT& WritePassword, const VARIANT& Notify)
{
static BYTE parms[] =
VTS_I4 VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x3dd, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Mode, &WritePassword, &Notify);
}
void _Workbook::ChangeLink(LPCTSTR Name, LPCTSTR NewName, long Type)
{
static BYTE parms[] =
VTS_BSTR VTS_BSTR VTS_I4;
InvokeHelper(0x322, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Name, NewName, Type);
}
LPDISPATCH _Workbook::GetCharts()
{
LPDISPATCH result;
InvokeHelper(0x79, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Workbook::Close(const VARIANT& SaveChanges, const VARIANT& Filename, const VARIANT& RouteWorkbook)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x115, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&SaveChanges, &Filename, &RouteWorkbook);
}
CString _Workbook::GetCodeName()
{
CString result;
InvokeHelper(0x55d, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
CString _Workbook::Get_CodeName()
{
CString result;
InvokeHelper(0x80010000, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Workbook::Set_CodeName(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x80010000, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
VARIANT _Workbook::GetColors(const VARIANT& Index)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x11e, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, parms,
&Index);
return result;
}
void _Workbook::SetColors(const VARIANT& Index, const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x11e, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&Index, &newValue);
}
LPDISPATCH _Workbook::GetCommandBars()
{
LPDISPATCH result;
InvokeHelper(0x59f, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long _Workbook::GetConflictResolution()
{
long result;
InvokeHelper(0x497, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Workbook::SetConflictResolution(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x497, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
LPDISPATCH _Workbook::GetContainer()
{
LPDISPATCH result;
InvokeHelper(0x4a6, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
BOOL _Workbook::GetCreateBackup()
{
BOOL result;
InvokeHelper(0x11f, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetCustomDocumentProperties()
{
LPDISPATCH result;
InvokeHelper(0x499, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
BOOL _Workbook::GetDate1904()
{
BOOL result;
InvokeHelper(0x193, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetDate1904(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x193, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
void _Workbook::DeleteNumberFormat(LPCTSTR NumberFormat)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x18d, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
NumberFormat);
}
long _Workbook::GetDisplayDrawingObjects()
{
long result;
InvokeHelper(0x194, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Workbook::SetDisplayDrawingObjects(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x194, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
BOOL _Workbook::ExclusiveAccess()
{
BOOL result;
InvokeHelper(0x490, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
return result;
}
long _Workbook::GetFileFormat()
{
long result;
InvokeHelper(0x120, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Workbook::ForwardMailer()
{
InvokeHelper(0x3cd, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
CString _Workbook::GetFullName()
{
CString result;
InvokeHelper(0x121, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
BOOL _Workbook::GetHasPassword()
{
BOOL result;
InvokeHelper(0x122, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL _Workbook::GetIsAddin()
{
BOOL result;
InvokeHelper(0x5a5, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetIsAddin(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x5a5, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
VARIANT _Workbook::LinkInfo(LPCTSTR Name, long LinkInfo, const VARIANT& Type, const VARIANT& EditionRef)
{
VARIANT result;
static BYTE parms[] =
VTS_BSTR VTS_I4 VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x327, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
Name, LinkInfo, &Type, &EditionRef);
return result;
}
VARIANT _Workbook::LinkSources(const VARIANT& Type)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x328, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Type);
return result;
}
LPDISPATCH _Workbook::GetMailer()
{
LPDISPATCH result;
InvokeHelper(0x3d3, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Workbook::MergeWorkbook(const VARIANT& Filename)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x5a6, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Filename);
}
BOOL _Workbook::GetMultiUserEditing()
{
BOOL result;
InvokeHelper(0x491, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
CString _Workbook::GetName()
{
CString result;
InvokeHelper(0x6e, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetNames()
{
LPDISPATCH result;
InvokeHelper(0x1ba, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::NewWindow()
{
LPDISPATCH result;
InvokeHelper(0x118, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Workbook::OpenLinks(LPCTSTR Name, const VARIANT& ReadOnly, const VARIANT& Type)
{
static BYTE parms[] =
VTS_BSTR VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x323, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Name, &ReadOnly, &Type);
}
CString _Workbook::GetPath()
{
CString result;
InvokeHelper(0x123, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
BOOL _Workbook::GetPersonalViewListSettings()
{
BOOL result;
InvokeHelper(0x5a7, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetPersonalViewListSettings(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x5a7, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Workbook::GetPersonalViewPrintSettings()
{
BOOL result;
InvokeHelper(0x5a8, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetPersonalViewPrintSettings(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x5a8, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
LPDISPATCH _Workbook::PivotCaches()
{
LPDISPATCH result;
InvokeHelper(0x5a9, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Workbook::Post(const VARIANT& DestName)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x48e, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&DestName);
}
BOOL _Workbook::GetPrecisionAsDisplayed()
{
BOOL result;
InvokeHelper(0x195, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetPrecisionAsDisplayed(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x195, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
void _Workbook::PrintPreview(const VARIANT& EnableChanges)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x119, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&EnableChanges);
}
BOOL _Workbook::GetProtectStructure()
{
BOOL result;
InvokeHelper(0x24c, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL _Workbook::GetProtectWindows()
{
BOOL result;
InvokeHelper(0x127, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL _Workbook::GetReadOnly()
{
BOOL result;
InvokeHelper(0x128, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::RefreshAll()
{
InvokeHelper(0x5ac, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void _Workbook::Reply()
{
InvokeHelper(0x3d1, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void _Workbook::ReplyAll()
{
InvokeHelper(0x3d2, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void _Workbook::RemoveUser(long Index)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x5ad, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Index);
}
long _Workbook::GetRevisionNumber()
{
long result;
InvokeHelper(0x494, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Workbook::RunAutoMacros(long Which)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x27a, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Which);
}
void _Workbook::Save()
{
InvokeHelper(0x11b, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void _Workbook::SaveCopyAs(const VARIANT& Filename)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0xaf, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Filename);
}
BOOL _Workbook::GetSaved()
{
BOOL result;
InvokeHelper(0x12a, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetSaved(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x12a, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Workbook::GetSaveLinkValues()
{
BOOL result;
InvokeHelper(0x196, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetSaveLinkValues(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x196, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
void _Workbook::SendMail(const VARIANT& Recipients, const VARIANT& Subject, const VARIANT& ReturnReceipt)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x3b3, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Recipients, &Subject, &ReturnReceipt);
}
void _Workbook::SendMailer(const VARIANT& FileFormat, long Priority)
{
static BYTE parms[] =
VTS_VARIANT VTS_I4;
InvokeHelper(0x3d4, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&FileFormat, Priority);
}
void _Workbook::SetLinkOnData(LPCTSTR Name, const VARIANT& Procedure)
{
static BYTE parms[] =
VTS_BSTR VTS_VARIANT;
InvokeHelper(0x329, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Name, &Procedure);
}
LPDISPATCH _Workbook::GetSheets()
{
LPDISPATCH result;
InvokeHelper(0x1e5, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
BOOL _Workbook::GetShowConflictHistory()
{
BOOL result;
InvokeHelper(0x493, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetShowConflictHistory(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x493, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
LPDISPATCH _Workbook::GetStyles()
{
LPDISPATCH result;
InvokeHelper(0x1ed, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Workbook::Unprotect(const VARIANT& Password)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x11d, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Password);
}
void _Workbook::UnprotectSharing(const VARIANT& SharingPassword)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x5af, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&SharingPassword);
}
void _Workbook::UpdateFromFile()
{
InvokeHelper(0x3e3, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void _Workbook::UpdateLink(const VARIANT& Name, const VARIANT& Type)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x324, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Name, &Type);
}
BOOL _Workbook::GetUpdateRemoteReferences()
{
BOOL result;
InvokeHelper(0x19b, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetUpdateRemoteReferences(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x19b, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
VARIANT _Workbook::GetUserStatus()
{
VARIANT result;
InvokeHelper(0x495, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetCustomViews()
{
LPDISPATCH result;
InvokeHelper(0x5b0, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetWindows()
{
LPDISPATCH result;
InvokeHelper(0x1ae, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetWorksheets()
{
LPDISPATCH result;
InvokeHelper(0x1ee, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
BOOL _Workbook::GetWriteReserved()
{
BOOL result;
InvokeHelper(0x12b, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
CString _Workbook::GetWriteReservedBy()
{
CString result;
InvokeHelper(0x12c, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetExcel4IntlMacroSheets()
{
LPDISPATCH result;
InvokeHelper(0x245, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetExcel4MacroSheets()
{
LPDISPATCH result;
InvokeHelper(0x243, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
BOOL _Workbook::GetTemplateRemoveExtData()
{
BOOL result;
InvokeHelper(0x5b1, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetTemplateRemoveExtData(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x5b1, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
void _Workbook::HighlightChangesOptions(const VARIANT& When, const VARIANT& Who, const VARIANT& Where)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x5b2, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&When, &Who, &Where);
}
BOOL _Workbook::GetHighlightChangesOnScreen()
{
BOOL result;
InvokeHelper(0x5b5, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetHighlightChangesOnScreen(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x5b5, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Workbook::GetKeepChangeHistory()
{
BOOL result;
InvokeHelper(0x5b6, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetKeepChangeHistory(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x5b6, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Workbook::GetListChangesOnNewSheet()
{
BOOL result;
InvokeHelper(0x5b7, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetListChangesOnNewSheet(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x5b7, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
void _Workbook::PurgeChangeHistoryNow(long Days, const VARIANT& SharingPassword)
{
static BYTE parms[] =
VTS_I4 VTS_VARIANT;
InvokeHelper(0x5b8, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Days, &SharingPassword);
}
void _Workbook::AcceptAllChanges(const VARIANT& When, const VARIANT& Who, const VARIANT& Where)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x5ba, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&When, &Who, &Where);
}
void _Workbook::RejectAllChanges(const VARIANT& When, const VARIANT& Who, const VARIANT& Where)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x5bb, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&When, &Who, &Where);
}
void _Workbook::ResetColors()
{
InvokeHelper(0x5bc, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
LPDISPATCH _Workbook::GetVBProject()
{
LPDISPATCH result;
InvokeHelper(0x5bd, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Workbook::FollowHyperlink(LPCTSTR Address, const VARIANT& SubAddress, const VARIANT& NewWindow, const VARIANT& AddHistory, const VARIANT& ExtraInfo, const VARIANT& Method, const VARIANT& HeaderInfo)
{
static BYTE parms[] =
VTS_BSTR VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x5be, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Address, &SubAddress, &NewWindow, &AddHistory, &ExtraInfo, &Method, &HeaderInfo);
}
void _Workbook::AddToFavorites()
{
InvokeHelper(0x5c4, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
BOOL _Workbook::GetIsInplace()
{
BOOL result;
InvokeHelper(0x6e9, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::WebPagePreview()
{
InvokeHelper(0x71a, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
LPDISPATCH _Workbook::GetPublishObjects()
{
LPDISPATCH result;
InvokeHelper(0x71b, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetWebOptions()
{
LPDISPATCH result;
InvokeHelper(0x71c, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Workbook::ReloadAs(long Encoding)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x71d, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Encoding);
}
BOOL _Workbook::GetEnvelopeVisible()
{
BOOL result;
InvokeHelper(0x720, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetEnvelopeVisible(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x720, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Workbook::GetCalculationVersion()
{
long result;
InvokeHelper(0x70e, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
BOOL _Workbook::GetVBASigned()
{
BOOL result;
InvokeHelper(0x724, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL _Workbook::GetShowPivotTableFieldList()
{
BOOL result;
InvokeHelper(0x7fe, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetShowPivotTableFieldList(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x7fe, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Workbook::GetUpdateLinks()
{
long result;
InvokeHelper(0x360, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Workbook::SetUpdateLinks(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x360, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
void _Workbook::BreakLink(LPCTSTR Name, long Type)
{
static BYTE parms[] =
VTS_BSTR VTS_I4;
InvokeHelper(0x7ff, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Name, Type);
}
void _Workbook::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)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_I4 VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x785, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Filename, &FileFormat, &Password, &WriteResPassword, &ReadOnlyRecommended, &CreateBackup, AccessMode, &ConflictResolution, &AddToMru, &TextCodepage, &TextVisualLayout, &Local);
}
BOOL _Workbook::GetEnableAutoRecover()
{
BOOL result;
InvokeHelper(0x801, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetEnableAutoRecover(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x801, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Workbook::GetRemovePersonalInformation()
{
BOOL result;
InvokeHelper(0x802, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetRemovePersonalInformation(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x802, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
CString _Workbook::GetFullNameURLEncoded()
{
CString result;
InvokeHelper(0x787, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Workbook::CheckIn(const VARIANT& SaveChanges, const VARIANT& Comments, const VARIANT& MakePublic)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x803, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&SaveChanges, &Comments, &MakePublic);
}
BOOL _Workbook::CanCheckIn()
{
BOOL result;
InvokeHelper(0x805, DISPATCH_METHOD, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SendForReview(const VARIANT& Recipients, const VARIANT& Subject, const VARIANT& ShowMessage, const VARIANT& IncludeAttachment)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x806, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Recipients, &Subject, &ShowMessage, &IncludeAttachment);
}
void _Workbook::ReplyWithChanges(const VARIANT& ShowMessage)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x809, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&ShowMessage);
}
void _Workbook::EndReview()
{
InvokeHelper(0x80a, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
CString _Workbook::GetPassword()
{
CString result;
InvokeHelper(0x1ad, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Workbook::SetPassword(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x1ad, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
CString _Workbook::GetWritePassword()
{
CString result;
InvokeHelper(0x468, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Workbook::SetWritePassword(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x468, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
CString _Workbook::GetPasswordEncryptionProvider()
{
CString result;
InvokeHelper(0x80b, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
CString _Workbook::GetPasswordEncryptionAlgorithm()
{
CString result;
InvokeHelper(0x80c, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
long _Workbook::GetPasswordEncryptionKeyLength()
{
long result;
InvokeHelper(0x80d, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void _Workbook::SetPasswordEncryptionOptions(const VARIANT& PasswordEncryptionProvider, const VARIANT& PasswordEncryptionAlgorithm, const VARIANT& PasswordEncryptionKeyLength, const VARIANT& PasswordEncryptionFileProperties)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x80e, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&PasswordEncryptionProvider, &PasswordEncryptionAlgorithm, &PasswordEncryptionKeyLength, &PasswordEncryptionFileProperties);
}
BOOL _Workbook::GetPasswordEncryptionFileProperties()
{
BOOL result;
InvokeHelper(0x80f, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL _Workbook::GetReadOnlyRecommended()
{
BOOL result;
InvokeHelper(0x7d5, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetReadOnlyRecommended(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x7d5, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
void _Workbook::Protect(const VARIANT& Password, const VARIANT& Structure, const VARIANT& Windows)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x7ed, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Password, &Structure, &Windows);
}
LPDISPATCH _Workbook::GetSmartTagOptions()
{
LPDISPATCH result;
InvokeHelper(0x810, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Workbook::RecheckSmartTags()
{
InvokeHelper(0x811, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
LPDISPATCH _Workbook::GetPermission()
{
LPDISPATCH result;
InvokeHelper(0x8d8, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetSharedWorkspace()
{
LPDISPATCH result;
InvokeHelper(0x8d9, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetSync()
{
LPDISPATCH result;
InvokeHelper(0x8da, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Workbook::SendFaxOverInternet(const VARIANT& Recipients, const VARIANT& Subject, const VARIANT& ShowMessage)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x8db, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Recipients, &Subject, &ShowMessage);
}
LPDISPATCH _Workbook::GetXmlNamespaces()
{
LPDISPATCH result;
InvokeHelper(0x8dc, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetXmlMaps()
{
LPDISPATCH result;
InvokeHelper(0x8dd, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long _Workbook::XmlImport(LPCTSTR Url, LPDISPATCH* ImportMap, const VARIANT& Overwrite, const VARIANT& Destination)
{
long result;
static BYTE parms[] =
VTS_BSTR VTS_PDISPATCH VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x8de, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
Url, ImportMap, &Overwrite, &Destination);
return result;
}
LPDISPATCH _Workbook::GetSmartDocument()
{
LPDISPATCH result;
InvokeHelper(0x8e1, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetDocumentLibraryVersions()
{
LPDISPATCH result;
InvokeHelper(0x8e2, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
BOOL _Workbook::GetInactiveListBorderVisible()
{
BOOL result;
InvokeHelper(0x8e3, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetInactiveListBorderVisible(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x8e3, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Workbook::GetDisplayInkComments()
{
BOOL result;
InvokeHelper(0x8e4, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetDisplayInkComments(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x8e4, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
long _Workbook::XmlImportXml(LPCTSTR Data, LPDISPATCH* ImportMap, const VARIANT& Overwrite, const VARIANT& Destination)
{
long result;
static BYTE parms[] =
VTS_BSTR VTS_PDISPATCH VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x8e5, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
Data, ImportMap, &Overwrite, &Destination);
return result;
}
void _Workbook::SaveAsXMLData(LPCTSTR Filename, LPDISPATCH Map)
{
static BYTE parms[] =
VTS_BSTR VTS_DISPATCH;
InvokeHelper(0x8e6, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Filename, Map);
}
void _Workbook::ToggleFormsDesign()
{
InvokeHelper(0x8e7, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
LPDISPATCH _Workbook::GetContentTypeProperties()
{
LPDISPATCH result;
InvokeHelper(0x9d0, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetConnections()
{
LPDISPATCH result;
InvokeHelper(0x9d1, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Workbook::RemoveDocumentInformation(long RemoveDocInfoType)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x9d2, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
RemoveDocInfoType);
}
LPDISPATCH _Workbook::GetSignatures()
{
LPDISPATCH result;
InvokeHelper(0x9d4, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Workbook::CheckInWithVersion(const VARIANT& SaveChanges, const VARIANT& Comments, const VARIANT& MakePublic, const VARIANT& VersionType)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x9d5, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&SaveChanges, &Comments, &MakePublic, &VersionType);
}
LPDISPATCH _Workbook::GetServerPolicy()
{
LPDISPATCH result;
InvokeHelper(0x9d7, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Workbook::LockServerFile()
{
InvokeHelper(0x9d8, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
LPDISPATCH _Workbook::GetDocumentInspectors()
{
LPDISPATCH result;
InvokeHelper(0x9d9, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetWorkflowTasks()
{
LPDISPATCH result;
InvokeHelper(0x9da, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetWorkflowTemplates()
{
LPDISPATCH result;
InvokeHelper(0x9db, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Workbook::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,
const VARIANT& IgnorePrintAreas)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x939, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&From, &To, &Copies, &Preview, &ActivePrinter, &PrintToFile, &Collate, &PrToFileName, &IgnorePrintAreas);
}
LPDISPATCH _Workbook::GetServerViewableItems()
{
LPDISPATCH result;
InvokeHelper(0x9dc, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetTableStyles()
{
LPDISPATCH result;
InvokeHelper(0x9dd, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
VARIANT _Workbook::GetDefaultTableStyle()
{
VARIANT result;
InvokeHelper(0x9de, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void _Workbook::SetDefaultTableStyle(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x9de, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
VARIANT _Workbook::GetDefaultPivotTableStyle()
{
VARIANT result;
InvokeHelper(0x9df, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void _Workbook::SetDefaultPivotTableStyle(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x9df, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
BOOL _Workbook::GetCheckCompatibility()
{
BOOL result;
InvokeHelper(0x9e0, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetCheckCompatibility(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x9e0, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Workbook::GetHasVBProject()
{
BOOL result;
InvokeHelper(0x9e1, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetCustomXMLParts()
{
LPDISPATCH result;
InvokeHelper(0x9e2, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
BOOL _Workbook::GetFinal()
{
BOOL result;
InvokeHelper(0x9e3, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetFinal(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x9e3, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
LPDISPATCH _Workbook::GetResearch()
{
LPDISPATCH result;
InvokeHelper(0x9e4, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH _Workbook::GetTheme()
{
LPDISPATCH result;
InvokeHelper(0x9e5, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void _Workbook::ApplyTheme(LPCTSTR Filename)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x9e6, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Filename);
}
BOOL _Workbook::GetExcel8CompatibilityMode()
{
BOOL result;
InvokeHelper(0x9e7, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
BOOL _Workbook::GetConnectionsDisabled()
{
BOOL result;
InvokeHelper(0x9e8, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::EnableConnections()
{
InvokeHelper(0x9e9, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
BOOL _Workbook::GetShowPivotChartActiveFields()
{
BOOL result;
InvokeHelper(0x9ea, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetShowPivotChartActiveFields(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x9ea, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
void _Workbook::ExportAsFixedFormat(long Type, const VARIANT& Filename, const VARIANT& Quality, const VARIANT& IncludeDocProperties, const VARIANT& IgnorePrintAreas, const VARIANT& From, const VARIANT& To, const VARIANT& OpenAfterPublish,
const VARIANT& FixedFormatExtClassPtr)
{
static BYTE parms[] =
VTS_I4 VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x9bd, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Type, &Filename, &Quality, &IncludeDocProperties, &IgnorePrintAreas, &From, &To, &OpenAfterPublish, &FixedFormatExtClassPtr);
}
LPDISPATCH _Workbook::GetIconSets()
{
LPDISPATCH result;
InvokeHelper(0x9eb, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
CString _Workbook::GetEncryptionProvider()
{
CString result;
InvokeHelper(0x9ec, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void _Workbook::SetEncryptionProvider(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x9ec, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
BOOL _Workbook::GetDoNotPromptForConvert()
{
BOOL result;
InvokeHelper(0x9ed, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetDoNotPromptForConvert(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x9ed, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
BOOL _Workbook::GetForceFullCalculation()
{
BOOL result;
InvokeHelper(0x9ee, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
void _Workbook::SetForceFullCalculation(BOOL bNewValue)
{
static BYTE parms[] =
VTS_BOOL;
InvokeHelper(0x9ee, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
bNewValue);
}
void _Workbook::ProtectSharing(const VARIANT& Filename, const VARIANT& Password, const VARIANT& WriteResPassword, const VARIANT& ReadOnlyRecommended, const VARIANT& CreateBackup, const VARIANT& SharingPassword, const VARIANT& FileFormat)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x9ef, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Filename, &Password, &WriteResPassword, &ReadOnlyRecommended, &CreateBackup, &SharingPassword, &FileFormat);
}
/////////////////////////////////////////////////////////////////////////////
// Workbooks properties
/////////////////////////////////////////////////////////////////////////////
// Workbooks operations
LPDISPATCH Workbooks::GetApplication()
{
LPDISPATCH result;
InvokeHelper(0x94, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long Workbooks::GetCreator()
{
long result;
InvokeHelper(0x95, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
LPDISPATCH Workbooks::GetParent()
{
LPDISPATCH result;
InvokeHelper(0x96, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH Workbooks::Add(const VARIANT& Template)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0xb5, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
&Template);
return result;
}
void Workbooks::Close()
{
InvokeHelper(0x115, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
long Workbooks::GetCount()
{
long result;
InvokeHelper(0x76, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
LPDISPATCH Workbooks::GetItem(const VARIANT& Index)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0xaa, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, parms,
&Index);
return result;
}
LPUNKNOWN Workbooks::Get_NewEnum()
{
LPUNKNOWN result;
InvokeHelper(0xfffffffc, DISPATCH_PROPERTYGET, VT_UNKNOWN, (void*)&result, NULL);
return result;
}
LPDISPATCH Workbooks::Get_Default(const VARIANT& Index)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x0, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, parms,
&Index);
return result;
}
LPDISPATCH Workbooks::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)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_BSTR VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x783, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
Filename, &UpdateLinks, &ReadOnly, &Format, &Password, &WriteResPassword, &IgnoreReadOnlyRecommended, &Origin, &Delimiter, &Editable, &Notify, &Converter, &AddToMru, &Local, &CorruptLoad);
return result;
}
void Workbooks::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)
{
static BYTE parms[] =
VTS_BSTR VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_I4 VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x784, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Filename, &Origin, &StartRow, &DataType, TextQualifier, &ConsecutiveDelimiter, &Tab, &Semicolon, &Comma, &Space, &Other, &OtherChar, &FieldInfo, &TextVisualLayout, &DecimalSeparator, &ThousandsSeparator, &TrailingMinusNumbers, &Local);
}
LPDISPATCH Workbooks::OpenDatabase(LPCTSTR Filename, const VARIANT& CommandText, const VARIANT& CommandType, const VARIANT& BackgroundQuery, const VARIANT& ImportDataAs)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_BSTR VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x813, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
Filename, &CommandText, &CommandType, &BackgroundQuery, &ImportDataAs);
return result;
}
void Workbooks::CheckOut(LPCTSTR Filename)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x815, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Filename);
}
BOOL Workbooks::CanCheckOut(LPCTSTR Filename)
{
BOOL result;
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x816, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
Filename);
return result;
}
LPDISPATCH Workbooks::OpenXML(LPCTSTR Filename, const VARIANT& Stylesheets, const VARIANT& LoadOption)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_BSTR VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x8e8, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
Filename, &Stylesheets, &LoadOption);
return result;
}
/////////////////////////////////////////////////////////////////////////////
// Range properties
/////////////////////////////////////////////////////////////////////////////
// Range operations
LPDISPATCH Range::GetApplication()
{
LPDISPATCH result;
InvokeHelper(0x94, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long Range::GetCreator()
{
long result;
InvokeHelper(0x95, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::GetParent()
{
LPDISPATCH result;
InvokeHelper(0x96, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
VARIANT Range::Activate()
{
VARIANT result;
InvokeHelper(0x130, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT Range::GetAddIndent()
{
VARIANT result;
InvokeHelper(0x427, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetAddIndent(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x427, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
CString Range::GetAddress(const VARIANT& RowAbsolute, const VARIANT& ColumnAbsolute, long ReferenceStyle, const VARIANT& External, const VARIANT& RelativeTo)
{
CString result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_I4 VTS_VARIANT VTS_VARIANT;
InvokeHelper(0xec, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, parms,
&RowAbsolute, &ColumnAbsolute, ReferenceStyle, &External, &RelativeTo);
return result;
}
CString Range::GetAddressLocal(const VARIANT& RowAbsolute, const VARIANT& ColumnAbsolute, long ReferenceStyle, const VARIANT& External, const VARIANT& RelativeTo)
{
CString result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_I4 VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x1b5, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, parms,
&RowAbsolute, &ColumnAbsolute, ReferenceStyle, &External, &RelativeTo);
return result;
}
VARIANT Range::AdvancedFilter(long Action, const VARIANT& CriteriaRange, const VARIANT& CopyToRange, const VARIANT& Unique)
{
VARIANT result;
static BYTE parms[] =
VTS_I4 VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x36c, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
Action, &CriteriaRange, &CopyToRange, &Unique);
return result;
}
VARIANT Range::ApplyNames(const VARIANT& Names, const VARIANT& IgnoreRelativeAbsolute, const VARIANT& UseRowColumnNames, const VARIANT& OmitColumn, const VARIANT& OmitRow, long Order, const VARIANT& AppendLast)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_I4 VTS_VARIANT;
InvokeHelper(0x1b9, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Names, &IgnoreRelativeAbsolute, &UseRowColumnNames, &OmitColumn, &OmitRow, Order, &AppendLast);
return result;
}
VARIANT Range::ApplyOutlineStyles()
{
VARIANT result;
InvokeHelper(0x1c0, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::GetAreas()
{
LPDISPATCH result;
InvokeHelper(0x238, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
CString Range::AutoComplete(LPCTSTR String)
{
CString result;
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x4a1, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
String);
return result;
}
VARIANT Range::AutoFill(LPDISPATCH Destination, long Type)
{
VARIANT result;
static BYTE parms[] =
VTS_DISPATCH VTS_I4;
InvokeHelper(0x1c1, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
Destination, Type);
return result;
}
VARIANT Range::AutoFilter(const VARIANT& Field, const VARIANT& Criteria1, long Operator, const VARIANT& Criteria2, const VARIANT& VisibleDropDown)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_I4 VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x319, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Field, &Criteria1, Operator, &Criteria2, &VisibleDropDown);
return result;
}
VARIANT Range::AutoFit()
{
VARIANT result;
InvokeHelper(0xed, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT Range::AutoOutline()
{
VARIANT result;
InvokeHelper(0x40c, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT Range::BorderAround(const VARIANT& LineStyle, long Weight, long ColorIndex, const VARIANT& Color)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_I4 VTS_I4 VTS_VARIANT;
InvokeHelper(0x42b, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&LineStyle, Weight, ColorIndex, &Color);
return result;
}
LPDISPATCH Range::GetBorders()
{
LPDISPATCH result;
InvokeHelper(0x1b3, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
VARIANT Range::Calculate()
{
VARIANT result;
InvokeHelper(0x117, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::GetCells()
{
LPDISPATCH result;
InvokeHelper(0xee, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::GetCharacters(const VARIANT& Start, const VARIANT& Length)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x25b, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, parms,
&Start, &Length);
return result;
}
VARIANT Range::CheckSpelling(const VARIANT& CustomDictionary, const VARIANT& IgnoreUppercase, const VARIANT& AlwaysSuggest, const VARIANT& SpellLang)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x1f9, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&CustomDictionary, &IgnoreUppercase, &AlwaysSuggest, &SpellLang);
return result;
}
VARIANT Range::Clear()
{
VARIANT result;
InvokeHelper(0x6f, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT Range::ClearContents()
{
VARIANT result;
InvokeHelper(0x71, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT Range::ClearFormats()
{
VARIANT result;
InvokeHelper(0x70, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT Range::ClearNotes()
{
VARIANT result;
InvokeHelper(0xef, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT Range::ClearOutline()
{
VARIANT result;
InvokeHelper(0x40d, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
long Range::GetColumn()
{
long result;
InvokeHelper(0xf0, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::ColumnDifferences(const VARIANT& Comparison)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x1fe, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
&Comparison);
return result;
}
LPDISPATCH Range::GetColumns()
{
LPDISPATCH result;
InvokeHelper(0xf1, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
VARIANT Range::GetColumnWidth()
{
VARIANT result;
InvokeHelper(0xf2, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetColumnWidth(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0xf2, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
VARIANT Range::Consolidate(const VARIANT& Sources, const VARIANT& Function, const VARIANT& TopRow, const VARIANT& LeftColumn, const VARIANT& CreateLinks)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x1e2, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Sources, &Function, &TopRow, &LeftColumn, &CreateLinks);
return result;
}
VARIANT Range::Copy(const VARIANT& Destination)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x227, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Destination);
return result;
}
long Range::CopyFromRecordset(LPUNKNOWN Data, const VARIANT& MaxRows, const VARIANT& MaxColumns)
{
long result;
static BYTE parms[] =
VTS_UNKNOWN VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x480, DISPATCH_METHOD, VT_I4, (void*)&result, parms,
Data, &MaxRows, &MaxColumns);
return result;
}
VARIANT Range::CopyPicture(long Appearance, long Format)
{
VARIANT result;
static BYTE parms[] =
VTS_I4 VTS_I4;
InvokeHelper(0xd5, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
Appearance, Format);
return result;
}
long Range::GetCount()
{
long result;
InvokeHelper(0x76, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
VARIANT Range::CreateNames(const VARIANT& Top, const VARIANT& Left, const VARIANT& Bottom, const VARIANT& Right)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x1c9, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Top, &Left, &Bottom, &Right);
return result;
}
LPDISPATCH Range::GetCurrentArray()
{
LPDISPATCH result;
InvokeHelper(0x1f5, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::GetCurrentRegion()
{
LPDISPATCH result;
InvokeHelper(0xf3, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
VARIANT Range::Cut(const VARIANT& Destination)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x235, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Destination);
return result;
}
VARIANT Range::DataSeries(const VARIANT& Rowcol, long Type, long Date, const VARIANT& Step, const VARIANT& Stop, const VARIANT& Trend)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_I4 VTS_I4 VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x1d0, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Rowcol, Type, Date, &Step, &Stop, &Trend);
return result;
}
VARIANT Range::Get_Default(const VARIANT& RowIndex, const VARIANT& ColumnIndex)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x0, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, parms,
&RowIndex, &ColumnIndex);
return result;
}
void Range::Set_Default(const VARIANT& RowIndex, const VARIANT& ColumnIndex, const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x0, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&RowIndex, &ColumnIndex, &newValue);
}
VARIANT Range::Delete(const VARIANT& Shift)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x75, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Shift);
return result;
}
LPDISPATCH Range::GetDependents()
{
LPDISPATCH result;
InvokeHelper(0x21f, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
VARIANT Range::DialogBox_()
{
VARIANT result;
InvokeHelper(0xf5, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::GetDirectDependents()
{
LPDISPATCH result;
InvokeHelper(0x221, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::GetDirectPrecedents()
{
LPDISPATCH result;
InvokeHelper(0x222, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
VARIANT Range::EditionOptions(long Type, long Option, const VARIANT& Name, const VARIANT& Reference, long Appearance, long ChartSize, const VARIANT& Format)
{
VARIANT result;
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_VARIANT VTS_VARIANT VTS_I4 VTS_I4 VTS_VARIANT;
InvokeHelper(0x46b, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
Type, Option, &Name, &Reference, Appearance, ChartSize, &Format);
return result;
}
LPDISPATCH Range::GetEnd(long Direction)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x1f4, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, parms,
Direction);
return result;
}
LPDISPATCH Range::GetEntireColumn()
{
LPDISPATCH result;
InvokeHelper(0xf6, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::GetEntireRow()
{
LPDISPATCH result;
InvokeHelper(0xf7, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
VARIANT Range::FillDown()
{
VARIANT result;
InvokeHelper(0xf8, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT Range::FillLeft()
{
VARIANT result;
InvokeHelper(0xf9, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT Range::FillRight()
{
VARIANT result;
InvokeHelper(0xfa, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT Range::FillUp()
{
VARIANT result;
InvokeHelper(0xfb, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::Find(const VARIANT& What, const VARIANT& After, const VARIANT& LookIn, const VARIANT& LookAt, const VARIANT& SearchOrder, long SearchDirection, const VARIANT& MatchCase, const VARIANT& MatchByte, const VARIANT& SearchFormat)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_I4 VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x18e, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
&What, &After, &LookIn, &LookAt, &SearchOrder, SearchDirection, &MatchCase, &MatchByte, &SearchFormat);
return result;
}
LPDISPATCH Range::FindNext(const VARIANT& After)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x18f, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
&After);
return result;
}
LPDISPATCH Range::FindPrevious(const VARIANT& After)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x190, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
&After);
return result;
}
LPDISPATCH Range::GetFont()
{
LPDISPATCH result;
InvokeHelper(0x92, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
VARIANT Range::GetFormula()
{
VARIANT result;
InvokeHelper(0x105, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetFormula(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x105, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
VARIANT Range::GetFormulaArray()
{
VARIANT result;
InvokeHelper(0x24a, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetFormulaArray(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x24a, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
VARIANT Range::GetFormulaHidden()
{
VARIANT result;
InvokeHelper(0x106, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetFormulaHidden(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x106, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
VARIANT Range::GetFormulaLocal()
{
VARIANT result;
InvokeHelper(0x107, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetFormulaLocal(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x107, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
VARIANT Range::GetFormulaR1C1()
{
VARIANT result;
InvokeHelper(0x108, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetFormulaR1C1(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x108, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
VARIANT Range::GetFormulaR1C1Local()
{
VARIANT result;
InvokeHelper(0x109, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetFormulaR1C1Local(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x109, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
VARIANT Range::FunctionWizard()
{
VARIANT result;
InvokeHelper(0x23b, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT Range::Group(const VARIANT& Start, const VARIANT& End, const VARIANT& By, const VARIANT& Periods)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x2e, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Start, &End, &By, &Periods);
return result;
}
VARIANT Range::GetHasArray()
{
VARIANT result;
InvokeHelper(0x10a, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT Range::GetHasFormula()
{
VARIANT result;
InvokeHelper(0x10b, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT Range::GetHeight()
{
VARIANT result;
InvokeHelper(0x7b, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT Range::GetHidden()
{
VARIANT result;
InvokeHelper(0x10c, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetHidden(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x10c, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
VARIANT Range::GetHorizontalAlignment()
{
VARIANT result;
InvokeHelper(0x88, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetHorizontalAlignment(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x88, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
VARIANT Range::GetIndentLevel()
{
VARIANT result;
InvokeHelper(0xc9, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetIndentLevel(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0xc9, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
void Range::InsertIndent(long InsertAmount)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x565, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
InsertAmount);
}
VARIANT Range::Insert(const VARIANT& Shift, const VARIANT& CopyOrigin)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0xfc, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Shift, &CopyOrigin);
return result;
}
LPDISPATCH Range::GetInterior()
{
LPDISPATCH result;
InvokeHelper(0x81, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
VARIANT Range::GetItem(const VARIANT& RowIndex, const VARIANT& ColumnIndex)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0xaa, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, parms,
&RowIndex, &ColumnIndex);
return result;
}
void Range::SetItem(const VARIANT& RowIndex, const VARIANT& ColumnIndex, const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0xaa, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&RowIndex, &ColumnIndex, &newValue);
}
VARIANT Range::Justify()
{
VARIANT result;
InvokeHelper(0x1ef, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT Range::GetLeft()
{
VARIANT result;
InvokeHelper(0x7f, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
long Range::GetListHeaderRows()
{
long result;
InvokeHelper(0x4a3, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
VARIANT Range::ListNames()
{
VARIANT result;
InvokeHelper(0xfd, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
long Range::GetLocationInTable()
{
long result;
InvokeHelper(0x2b3, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
VARIANT Range::GetLocked()
{
VARIANT result;
InvokeHelper(0x10d, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetLocked(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x10d, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
void Range::Merge(const VARIANT& Across)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x234, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Across);
}
void Range::UnMerge()
{
InvokeHelper(0x568, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
LPDISPATCH Range::GetMergeArea()
{
LPDISPATCH result;
InvokeHelper(0x569, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
VARIANT Range::GetMergeCells()
{
VARIANT result;
InvokeHelper(0xd0, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetMergeCells(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0xd0, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
VARIANT Range::GetName()
{
VARIANT result;
InvokeHelper(0x6e, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetName(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x6e, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
VARIANT Range::NavigateArrow(const VARIANT& TowardPrecedent, const VARIANT& ArrowNumber, const VARIANT& LinkNumber)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x408, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&TowardPrecedent, &ArrowNumber, &LinkNumber);
return result;
}
LPUNKNOWN Range::Get_NewEnum()
{
LPUNKNOWN result;
InvokeHelper(0xfffffffc, DISPATCH_PROPERTYGET, VT_UNKNOWN, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::GetNext()
{
LPDISPATCH result;
InvokeHelper(0x1f6, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
CString Range::NoteText(const VARIANT& Text, const VARIANT& Start, const VARIANT& Length)
{
CString result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x467, DISPATCH_METHOD, VT_BSTR, (void*)&result, parms,
&Text, &Start, &Length);
return result;
}
VARIANT Range::GetNumberFormat()
{
VARIANT result;
InvokeHelper(0xc1, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetNumberFormat(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0xc1, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
VARIANT Range::GetNumberFormatLocal()
{
VARIANT result;
InvokeHelper(0x449, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetNumberFormatLocal(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x449, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
LPDISPATCH Range::GetOffset(const VARIANT& RowOffset, const VARIANT& ColumnOffset)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0xfe, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, parms,
&RowOffset, &ColumnOffset);
return result;
}
VARIANT Range::GetOrientation()
{
VARIANT result;
InvokeHelper(0x86, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetOrientation(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x86, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
VARIANT Range::GetOutlineLevel()
{
VARIANT result;
InvokeHelper(0x10f, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetOutlineLevel(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x10f, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
long Range::GetPageBreak()
{
long result;
InvokeHelper(0xff, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void Range::SetPageBreak(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0xff, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
VARIANT Range::Parse(const VARIANT& ParseLine, const VARIANT& Destination)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x1dd, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&ParseLine, &Destination);
return result;
}
LPDISPATCH Range::GetPivotField()
{
LPDISPATCH result;
InvokeHelper(0x2db, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::GetPivotItem()
{
LPDISPATCH result;
InvokeHelper(0x2e4, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::GetPivotTable()
{
LPDISPATCH result;
InvokeHelper(0x2cc, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::GetPrecedents()
{
LPDISPATCH result;
InvokeHelper(0x220, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
VARIANT Range::GetPrefixCharacter()
{
VARIANT result;
InvokeHelper(0x1f8, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::GetPrevious()
{
LPDISPATCH result;
InvokeHelper(0x1f7, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
VARIANT Range::PrintPreview(const VARIANT& EnableChanges)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x119, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&EnableChanges);
return result;
}
LPDISPATCH Range::GetQueryTable()
{
LPDISPATCH result;
InvokeHelper(0x56a, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::GetRange(const VARIANT& Cell1, const VARIANT& Cell2)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0xc5, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, parms,
&Cell1, &Cell2);
return result;
}
VARIANT Range::RemoveSubtotal()
{
VARIANT result;
InvokeHelper(0x373, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
BOOL Range::Replace(const VARIANT& What, const VARIANT& Replacement, const VARIANT& LookAt, const VARIANT& SearchOrder, const VARIANT& MatchCase, const VARIANT& MatchByte, const VARIANT& SearchFormat, const VARIANT& ReplaceFormat)
{
BOOL result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0xe2, DISPATCH_METHOD, VT_BOOL, (void*)&result, parms,
&What, &Replacement, &LookAt, &SearchOrder, &MatchCase, &MatchByte, &SearchFormat, &ReplaceFormat);
return result;
}
LPDISPATCH Range::GetResize(const VARIANT& RowSize, const VARIANT& ColumnSize)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x100, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, parms,
&RowSize, &ColumnSize);
return result;
}
long Range::GetRow()
{
long result;
InvokeHelper(0x101, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::RowDifferences(const VARIANT& Comparison)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x1ff, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
&Comparison);
return result;
}
VARIANT Range::GetRowHeight()
{
VARIANT result;
InvokeHelper(0x110, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetRowHeight(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x110, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
LPDISPATCH Range::GetRows()
{
LPDISPATCH result;
InvokeHelper(0x102, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
VARIANT Range::Run(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 result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x103, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Arg1, &Arg2, &Arg3, &Arg4, &Arg5, &Arg6, &Arg7, &Arg8, &Arg9, &Arg10, &Arg11, &Arg12, &Arg13, &Arg14, &Arg15, &Arg16, &Arg17, &Arg18, &Arg19, &Arg20, &Arg21, &Arg22, &Arg23, &Arg24, &Arg25, &Arg26, &Arg27, &Arg28, &Arg29, &Arg30);
return result;
}
VARIANT Range::Select()
{
VARIANT result;
InvokeHelper(0xeb, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT Range::Show()
{
VARIANT result;
InvokeHelper(0x1f0, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT Range::ShowDependents(const VARIANT& Remove)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x36d, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Remove);
return result;
}
VARIANT Range::GetShowDetail()
{
VARIANT result;
InvokeHelper(0x249, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetShowDetail(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x249, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
VARIANT Range::ShowErrors()
{
VARIANT result;
InvokeHelper(0x36e, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT Range::ShowPrecedents(const VARIANT& Remove)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x36f, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Remove);
return result;
}
VARIANT Range::GetShrinkToFit()
{
VARIANT result;
InvokeHelper(0xd1, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetShrinkToFit(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0xd1, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
VARIANT Range::Sort(const VARIANT& Key1, long Order1, const VARIANT& Key2, const VARIANT& Type, long Order2, const VARIANT& Key3, long Order3, long Header, const VARIANT& OrderCustom, const VARIANT& MatchCase, long Orientation, long SortMethod,
long DataOption1, long DataOption2, long DataOption3)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_I4 VTS_VARIANT VTS_VARIANT VTS_I4 VTS_VARIANT VTS_I4 VTS_I4 VTS_VARIANT VTS_VARIANT VTS_I4 VTS_I4 VTS_I4 VTS_I4 VTS_I4;
InvokeHelper(0x370, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Key1, Order1, &Key2, &Type, Order2, &Key3, Order3, Header, &OrderCustom, &MatchCase, Orientation, SortMethod, DataOption1, DataOption2, DataOption3);
return result;
}
VARIANT Range::SortSpecial(long SortMethod, const VARIANT& Key1, long Order1, const VARIANT& Type, const VARIANT& Key2, long Order2, const VARIANT& Key3, long Order3, long Header, const VARIANT& OrderCustom, const VARIANT& MatchCase,
long Orientation, long DataOption1, long DataOption2, long DataOption3)
{
VARIANT result;
static BYTE parms[] =
VTS_I4 VTS_VARIANT VTS_I4 VTS_VARIANT VTS_VARIANT VTS_I4 VTS_VARIANT VTS_I4 VTS_I4 VTS_VARIANT VTS_VARIANT VTS_I4 VTS_I4 VTS_I4 VTS_I4;
InvokeHelper(0x371, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
SortMethod, &Key1, Order1, &Type, &Key2, Order2, &Key3, Order3, Header, &OrderCustom, &MatchCase, Orientation, DataOption1, DataOption2, DataOption3);
return result;
}
LPDISPATCH Range::GetSoundNote()
{
LPDISPATCH result;
InvokeHelper(0x394, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::SpecialCells(long Type, const VARIANT& Value)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_I4 VTS_VARIANT;
InvokeHelper(0x19a, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
Type, &Value);
return result;
}
VARIANT Range::GetStyle()
{
VARIANT result;
InvokeHelper(0x104, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetStyle(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x104, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
VARIANT Range::SubscribeTo(LPCTSTR Edition, long Format)
{
VARIANT result;
static BYTE parms[] =
VTS_BSTR VTS_I4;
InvokeHelper(0x1e1, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
Edition, Format);
return result;
}
VARIANT Range::Subtotal(long GroupBy, long Function, const VARIANT& TotalList, const VARIANT& Replace, const VARIANT& PageBreaks, long SummaryBelowData)
{
VARIANT result;
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_I4;
InvokeHelper(0x372, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
GroupBy, Function, &TotalList, &Replace, &PageBreaks, SummaryBelowData);
return result;
}
VARIANT Range::GetSummary()
{
VARIANT result;
InvokeHelper(0x111, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT Range::Table(const VARIANT& RowInput, const VARIANT& ColumnInput)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x1f1, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&RowInput, &ColumnInput);
return result;
}
VARIANT Range::GetText()
{
VARIANT result;
InvokeHelper(0x8a, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT Range::TextToColumns(const VARIANT& Destination, long 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& DecimalSeparator, const VARIANT& ThousandsSeparator, const VARIANT& TrailingMinusNumbers)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT VTS_I4 VTS_I4 VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x410, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&Destination, DataType, TextQualifier, &ConsecutiveDelimiter, &Tab, &Semicolon, &Comma, &Space, &Other, &OtherChar, &FieldInfo, &DecimalSeparator, &ThousandsSeparator, &TrailingMinusNumbers);
return result;
}
VARIANT Range::GetTop()
{
VARIANT result;
InvokeHelper(0x7e, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT Range::Ungroup()
{
VARIANT result;
InvokeHelper(0xf4, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT Range::GetUseStandardHeight()
{
VARIANT result;
InvokeHelper(0x112, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetUseStandardHeight(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x112, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
VARIANT Range::GetUseStandardWidth()
{
VARIANT result;
InvokeHelper(0x113, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetUseStandardWidth(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x113, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
LPDISPATCH Range::GetValidation()
{
LPDISPATCH result;
InvokeHelper(0x56b, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
VARIANT Range::GetValue(const VARIANT& RangeValueDataType)
{
VARIANT result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x6, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, parms,
&RangeValueDataType);
return result;
}
void Range::SetValue(const VARIANT& RangeValueDataType, const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x6, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&RangeValueDataType, &newValue);
}
VARIANT Range::GetValue2()
{
VARIANT result;
InvokeHelper(0x56c, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetValue2(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x56c, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
VARIANT Range::GetVerticalAlignment()
{
VARIANT result;
InvokeHelper(0x89, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetVerticalAlignment(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x89, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
VARIANT Range::GetWidth()
{
VARIANT result;
InvokeHelper(0x7a, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::GetWorksheet()
{
LPDISPATCH result;
InvokeHelper(0x15c, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
VARIANT Range::GetWrapText()
{
VARIANT result;
InvokeHelper(0x114, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Range::SetWrapText(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x114, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
LPDISPATCH Range::AddComment(const VARIANT& Text)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x56d, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
&Text);
return result;
}
LPDISPATCH Range::GetComment()
{
LPDISPATCH result;
InvokeHelper(0x38e, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void Range::ClearComments()
{
InvokeHelper(0x56e, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
LPDISPATCH Range::GetPhonetic()
{
LPDISPATCH result;
InvokeHelper(0x56f, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::GetFormatConditions()
{
LPDISPATCH result;
InvokeHelper(0x570, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long Range::GetReadingOrder()
{
long result;
InvokeHelper(0x3cf, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void Range::SetReadingOrder(long nNewValue)
{
static BYTE parms[] =
VTS_I4;
InvokeHelper(0x3cf, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
nNewValue);
}
LPDISPATCH Range::GetHyperlinks()
{
LPDISPATCH result;
InvokeHelper(0x571, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::GetPhonetics()
{
LPDISPATCH result;
InvokeHelper(0x713, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void Range::SetPhonetic()
{
InvokeHelper(0x714, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
CString Range::GetId()
{
CString result;
InvokeHelper(0x715, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void Range::SetId(LPCTSTR lpszNewValue)
{
static BYTE parms[] =
VTS_BSTR;
InvokeHelper(0x715, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
lpszNewValue);
}
LPDISPATCH Range::GetPivotCell()
{
LPDISPATCH result;
InvokeHelper(0x7dd, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void Range::Dirty()
{
InvokeHelper(0x7de, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
LPDISPATCH Range::GetErrors()
{
LPDISPATCH result;
InvokeHelper(0x7df, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::GetSmartTags()
{
LPDISPATCH result;
InvokeHelper(0x7e0, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void Range::Speak(const VARIANT& SpeakDirection, const VARIANT& SpeakFormulas)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x7e1, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&SpeakDirection, &SpeakFormulas);
}
VARIANT Range::PasteSpecial(long Paste, long Operation, const VARIANT& SkipBlanks, const VARIANT& Transpose)
{
VARIANT result;
static BYTE parms[] =
VTS_I4 VTS_I4 VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x788, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
Paste, Operation, &SkipBlanks, &Transpose);
return result;
}
BOOL Range::GetAllowEdit()
{
BOOL result;
InvokeHelper(0x7e4, DISPATCH_PROPERTYGET, VT_BOOL, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::GetListObject()
{
LPDISPATCH result;
InvokeHelper(0x8d1, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::GetXPath()
{
LPDISPATCH result;
InvokeHelper(0x8d2, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH Range::GetServerActions()
{
LPDISPATCH result;
InvokeHelper(0x9bb, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
void Range::RemoveDuplicates(const VARIANT& Columns, long Header)
{
static BYTE parms[] =
VTS_VARIANT VTS_I4;
InvokeHelper(0x9bc, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Columns, Header);
}
VARIANT Range::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 result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x939, DISPATCH_METHOD, VT_VARIANT, (void*)&result, parms,
&From, &To, &Copies, &Preview, &ActivePrinter, &PrintToFile, &Collate, &PrToFileName);
return result;
}
CString Range::GetMdx()
{
CString result;
InvokeHelper(0x84b, DISPATCH_PROPERTYGET, VT_BSTR, (void*)&result, NULL);
return result;
}
void Range::ExportAsFixedFormat(long Type, const VARIANT& Filename, const VARIANT& Quality, const VARIANT& IncludeDocProperties, const VARIANT& IgnorePrintAreas, const VARIANT& From, const VARIANT& To, const VARIANT& OpenAfterPublish,
const VARIANT& FixedFormatExtClassPtr)
{
static BYTE parms[] =
VTS_I4 VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x9bd, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Type, &Filename, &Quality, &IncludeDocProperties, &IgnorePrintAreas, &From, &To, &OpenAfterPublish, &FixedFormatExtClassPtr);
}
VARIANT Range::GetCountLarge()
{
VARIANT result;
InvokeHelper(0x9c3, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
VARIANT Range::CalculateRowMajorOrder()
{
VARIANT result;
InvokeHelper(0x93c, DISPATCH_METHOD, VT_VARIANT, (void*)&result, NULL);
return result;
}
/////////////////////////////////////////////////////////////////////////////
// Worksheets properties
/////////////////////////////////////////////////////////////////////////////
// Worksheets operations
LPDISPATCH Worksheets::GetApplication()
{
LPDISPATCH result;
InvokeHelper(0x94, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
long Worksheets::GetCreator()
{
long result;
InvokeHelper(0x95, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
LPDISPATCH Worksheets::GetParent()
{
LPDISPATCH result;
InvokeHelper(0x96, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH Worksheets::Add(const VARIANT& Before, const VARIANT& After, const VARIANT& Count, const VARIANT& Type)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0xb5, DISPATCH_METHOD, VT_DISPATCH, (void*)&result, parms,
&Before, &After, &Count, &Type);
return result;
}
void Worksheets::Copy(const VARIANT& Before, const VARIANT& After)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x227, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Before, &After);
}
long Worksheets::GetCount()
{
long result;
InvokeHelper(0x76, DISPATCH_PROPERTYGET, VT_I4, (void*)&result, NULL);
return result;
}
void Worksheets::Delete()
{
InvokeHelper(0x75, DISPATCH_METHOD, VT_EMPTY, NULL, NULL);
}
void Worksheets::FillAcrossSheets(LPDISPATCH Range, long Type)
{
static BYTE parms[] =
VTS_DISPATCH VTS_I4;
InvokeHelper(0x1d5, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
Range, Type);
}
LPDISPATCH Worksheets::GetItem(const VARIANT& Index)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0xaa, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, parms,
&Index);
return result;
}
void Worksheets::Move(const VARIANT& Before, const VARIANT& After)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x27d, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Before, &After);
}
LPUNKNOWN Worksheets::Get_NewEnum()
{
LPUNKNOWN result;
InvokeHelper(0xfffffffc, DISPATCH_PROPERTYGET, VT_UNKNOWN, (void*)&result, NULL);
return result;
}
void Worksheets::PrintPreview(const VARIANT& EnableChanges)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x119, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&EnableChanges);
}
void Worksheets::Select(const VARIANT& Replace)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0xeb, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&Replace);
}
LPDISPATCH Worksheets::GetHPageBreaks()
{
LPDISPATCH result;
InvokeHelper(0x58a, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
LPDISPATCH Worksheets::GetVPageBreaks()
{
LPDISPATCH result;
InvokeHelper(0x58b, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, NULL);
return result;
}
VARIANT Worksheets::GetVisible()
{
VARIANT result;
InvokeHelper(0x22e, DISPATCH_PROPERTYGET, VT_VARIANT, (void*)&result, NULL);
return result;
}
void Worksheets::SetVisible(const VARIANT& newValue)
{
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x22e, DISPATCH_PROPERTYPUT, VT_EMPTY, NULL, parms,
&newValue);
}
LPDISPATCH Worksheets::Get_Default(const VARIANT& Index)
{
LPDISPATCH result;
static BYTE parms[] =
VTS_VARIANT;
InvokeHelper(0x0, DISPATCH_PROPERTYGET, VT_DISPATCH, (void*)&result, parms,
&Index);
return result;
}
void Worksheets::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,
const VARIANT& IgnorePrintAreas)
{
static BYTE parms[] =
VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT VTS_VARIANT;
InvokeHelper(0x939, DISPATCH_METHOD, VT_EMPTY, NULL, parms,
&From, &To, &Copies, &Preview, &ActivePrinter, &PrintToFile, &Collate, &PrToFileName, &IgnorePrintAreas);
}