Описание тега excel.application

Описание тега Вопросы с тегом

Use to focus your question on the use of an Excel.Application object outside of Excel's own VBA. Constructing an independent instance of Excel can present unique problems and this tag can be used to identify them. Examples: PowerShell or VB Script referencing and manipulating an Excel workbook; MS Access building a workbook without leaving its own VBA environment, etc. Should be considered a sub-category and used for focusing a question.

Excel is arguably the most popular of the applications within the MS Office suite; even more so when introductory programming is considered a factor. Excel workbooks and worksheets can be easiy manipulated outside of the native Excel environment by introducing an instance of an Excel.Application object and using that object to programmatically handle data retrieval, creation or modification.

This presents unique problems, particularly in addressing parent/child relationships that are taken for granted in a native Excel environment. Use this tag to focus attention on these issues when you are using an independent instance of the Excel.Application from an outside calling process.

Typical examples of outside calling processes would include vbscript, powershell or even msaccess each of which can construct an instance of an excel.application object and use it to wrangle the data stored in a workbook/worksheet.

References: