Working with Microsoft Excel through Automation.
Microsoft Excel provides and automation server component, which allows most of the functionality in Excel to be called from an external program (e.g. VB6, Access VBA, etc.).
This class contains methods and properties that show you how to work with Excel.
|
Procedure Name
|
Type
|
Description
|
|
(Declarations)
|
Declarations
|
Declarations and private variables for the CExcel class
|
|
ActiveWorksheet
|
Property
|
Gets the name of the active worksheet
|
|
AppExcel
|
Property
|
Gets a handle to the current instance of Excel
|
|
BottomMargin
|
Property
|
Sets the bottom margin of the active worksheet
|
|
CurWorkbook
|
Property
|
Gets a handle to the currently open workbook
|
|
DocumentProperties
|
Property
|
Gets the specified document property
|
|
ExcelCaption
|
Property
|
Gets the caption of Excel
|
|
ExcelWindowState
|
Property
|
Gets the Excel window state of the active workbook
|
|
LeftFooter
|
Property
|
Gets the left footer value in the active worksheet
|
|
LeftHeader
|
Property
|
Gets the left header value in the active worksheet
|
|
LeftMargin
|
Property
|
Gets the left margin value in the active worksheet
|
|
PageOrientation
|
Property
|
Gets the page orientation of the active worksheet
|
|
RightFooter
|
Property
|
Sets the right footer value in the active worksheet
|
|
RightHeader
|
Property
|
Sets the right header value in the active worksheet
|
|
RightMargin
|
Property
|
Gets the right margin of the active worksheet
|
|
TopMargin
|
Property
|
Gets the top margin of the active worksheet
|
|
Visible
|
Property
|
Sets the visibility of the active worksheet
|
|
WorkbookCaption
|
Property
|
Gets the caption of the active workbook
|
|
WorkbookWindowState
|
Property
|
Gets the window state of the active workbook
|
|
ActWinDisplayGridLines
|
Method
|
Hides or Displays Worksheet gridlines.
|
|
ActWinDisplayHeadings
|
Method
|
Hides or Displays Worksheet Headings.
|
|
ActWinDisplayHorizontalScrollBar
|
Method
|
Hides or Displays the Horizontal Scroll Bar.
|
|
ActWinDisplayVerticalScrollBar
|
Method
|
Hides or Displays the Vertical Scroll Bar.
|
|
ActWinDisplayWrkBkTabs
|
Method
|
Hides or Displays the Workbook Tabs.
|
|
ActWinSetWindowCaption
|
Method
|
Sets the window caption for the Active Window.
|
|
ActWinSetWindowState
|
Method
|
Sets the window state for the active window.
|
|
AppDisplayFormulaBar
|
Method
|
Hides or Displays the Formula Bar
|
|
AppDisplayStatusBar
|
Method
|
Hides or Displays the Status Bar.
|
|
AppSetWindowCaption
|
Method
|
Sets the window caption for the application.
|
|
AppSetWindowState
|
Method
|
Sets the window state for the application.
|
|
CloseExcel
|
Method
|
Closes Excel
|
|
CloseWorkbook
|
Method
|
Closes the current workbook
|
|
CreatePivotTable
|
Method
|
Creates a Pivot Table from an External DataSource
|
|
CreateSummaryColumn
|
Method
|
For each column, summarize the data based on the summary type
|
|
CreateSummaryRow
|
Method
|
For each row, summarize the data based on the summary type
|
|
CreateTableFromAccess
|
Method
|
Gets the contents of an Access table or query into the current document
|
|
CreateTableFromAccessFast
|
Method
|
Gets the contents of an Access table or query into the current document.
|
|
CreateWorkbook
|
Method
|
Creates a new workbook and saves it
|
|
CreateWorksheet
|
Method
|
Creates a new worksheet
|
|
DeleteColumn_ByColumn
|
Method
|
Delete the column
|
|
DeleteColumn_ByRange
|
Method
|
Delete the column(s) by range
|
|
DeleteRow_ByRange
|
Method
|
Delete the Row(s) by range
|
|
DeleteRow_ByRow
|
Method
|
Delete the row
|
|
DeleteWorksheet
|
Method
|
Delete the active Worksheet
|
|
GetCellAddress
|
Method
|
Convert the Row/Column to cell address 'A1' format
|
|
GetCellFontBold_ByRange
|
Method
|
Get the bold font for the cell address or cell range
|
|
GetCellFontBold_ByRowColumn
|
Method
|
Get the bold font for the row/column.
|
|
GetCellFontItalic_ByRange
|
Method
|
Get the italic font for the cell address or cell range
|
|
GetCellFontItalic_ByRowColumn
|
Method
|
Get the italic font for the row/column
|
|
GetCellFontName_ByRange
|
Method
|
Get the font name that is set for the cell address or cell range
|
|
GetCellFontName_ByRowColumn
|
Method
|
Get the font name that is set for the row/column position
|
|
GetCellFontSize_ByRange
|
Method
|
Get the font size for the cell address or cell range
|
|
GetCellFontSize_ByRowColumn
|
Method
|
Get the font size for the row/column position.
|
|
GetCellFontUnderline_ByRange
|
Method
|
Get the underline font for the cell address or cell range.
|
|
GetCellFontUnderline_ByRowColumn
|
Method
|
Get the underline font for the row/column position.
|
|
GetCellFormula_ByRange
|
Method
|
Get the formula for the cell address
|
|
GetCellFormula_ByRowColumn
|
Method
|
Get the formula for the row/column position
|
|
GetCellValue_ByRange
|
Method
|
Get the contents of the specified cell address
|
|
GetCellValue_ByRowColumn
|
Method
|
Get the cell value for the row/column
|
|
InsertColumn_ByColumn
|
Method
|
Insert a column based on the column position
|
|
InsertColumn_ByRange
|
Method
|
Insert a column/group of columns based on the cell address or cell range.
|
|
InsertRow_ByRange
|
Method
|
Insert a row/group of rows based on the cell address or cell range.
|
|
InsertRow_ByRow
|
Method
|
Insert a row based on the row position
|
|
InsertValue_ByRange
|
Method
|
Inserts values into cells
|
|
InsertValue_ByRowColumn
|
Method
|
Set the contents of the specified cell address
|
|
OpenWorkbook
|
Method
|
Opens the named file and associates it with the class
|
|
OpenWorkbookFromLib
|
Method
|
Opens the named file and associates it with the class. This version looks in the Excel library folder.
|
|
ParseString
|
Private
|
Parses a String into pieces using the specified Delimiter
|
|
PrintActiveWorksheet
|
Method
|
Prints the active workbook
|
|
PrintSelectedSheets
|
Method
|
Prints the specified sheets
|
|
SaveCurrentDocument
|
Method
|
Save the current document.
|
|
SaveCurrentDocumentAs
|
Method
|
Save the current document with a new name
|
|
SelectDynamicColumnRange
|
Method
|
Selects a columnrange with a variable length.
|
|
SelectNamedRange
|
Method
|
Selects a named Range
|
|
SelectRange
|
Method
|
Selects a columnrange with a variable length.
|
|
SelectRange_ByRange
|
Method
|
Select cells based on cell address or cell range
|
|
SelectRange_ByRowColumn
|
Method
|
Select a cell based on row/column position.
|
|
SetActiveWorksheet
|
Method
|
Sets a worksheet as active
|
|
SetCellFontBold_ByRange
|
Method
|
Set the bold font for the cell address or cell range
|
|
SetCellFontBold_ByRowColumn
|
Method
|
Set the bold font for the row/column position
|
|
SetCellFontItalic_ByRange
|
Method
|
Set the italic font for the cell address or cell range
|
|
SetCellFontItalic_ByRowColumn
|
Method
|
Set the italic font for the row/column position
|
|
SetCellFontName_ByRange
|
Method
|
Set the font name for the cell address or cell range
|
|
SetCellFontName_ByRowColumn
|
Method
|
Set the font name for the row/column position
|
|
SetCellFontSize_ByRange
|
Method
|
Set the font size for the cell address or cell range
|
|
SetCellFontSize_ByRowColumn
|
Method
|
Set the font size for the row/column position
|
|
SetCellFontUnderline_ByRange
|
Method
|
Set the underline font for the cell address or cell range
|
|
SetCellFontUnderline_ByRowColumn
|
Method
|
Set the underline font for the row/column position
|
|
SetCellFormula_ByRange
|
Method
|
Set the cell formula in the active worksheet
|
|
SetCellFormula_ByRowColumn
|
Method
|
Set the cell formula in the active worksheet
|
|
SortRange
|
Method
|
Sorts the specified range
|
|
StartExcel
|
Method
|
Starts an instance of Excel
|
All Our Microsoft Access Products
(885K)
