Workbook: The Excel file itself.
Worksheet: The tabs that appear at the bottom of the sheet.
Cell: Each small square of the sheet. Advanced excel also allows you to apply styles like, for example, background colors.
Range: A range of cells and rows. NOTE: A range can consist of a single cell.
Dimension: Worksheet dimension structure. It contains the following dimension attributes of the worksheet:
Address: Address of the cell as text.
Columns: Number of columns in the worksheet.
Rows: Number of rows in the worksheet.
Start: Start location as an Address.
End: End location as an Address.
Data Series: Data series to be used in graphs, the n-th cell of the value range will correspond to the n-th cell of the label range. It has the following attributes:
Name: The name of the series.
ValueRange: Range of cells for the values of the series.
LabelRange: Range of cells for the labels of the series.
Color: Represents an ARGB (alpha, red, green, blue) color. The following attributes are available:
IsKnownColor: Gets a value indicating whether this System.Drawing.Color structure is a predefined color. Predefined colors are represented by the elements of the System.Drawing.KnownColor enumeration.
IsNamedColor: Gets a value indicating whether this System.Drawing.Color structure is a named color or a member of the System.Drawing.KnownColor enumeration.
IsSystemColor: Gets a value indicating whether this System.Drawing.Color structure is a system color. A system color is a color that is used in a Windows display element. System colors are represented by elements of the System.Drawing.KnownColor enumeration.
A: Alpha.
R: Red.
G: Green.
B: Blue.
Name: The name of this System.Drawing.Color.
CellFormat: Structure to define all the formatting attributes that can apply to a cell. The following attributes are available:
FontName: Name of the font to use.
FontSize: Size of the font to use.
BackgroundColor: Background color in hex format.
AutofitColumn: True to autofit column, false to leave as is.
Bold: True to set the text to Bold.
NumberFormat: Any number format to be applied to the cell.
BorderStyle:
None = 0,
Hair = 1,
Dotted = 2,
DashDot = 3,
Thin = 4,
DashDotDot = 5,
Dashed = 6,
MediumDashDotDot = 7,
MediumDashed = 8,
MediumDashDot = 9,
Thick = 10,
Medium = 11,
Double = 12
BorderColor: Color of the border in hex format
Address: The Address structure used by Excel. It contains the following attributes:
Address: The address as text.
Row: The row index of the address.
Column: The column index of the address.
IsRef: If the address is an invalid reference (#REF!)
Workbook_Create
Workbook_Open
Worksheet_Select
Chart_Create
Workbook_GetBinaryData
Workbook_Close
Cell_WriteRange
Column_Hide_Show
Column_Insert
Cell_Write
Worksheet_AutofitColumns
Worksheet_Rename
Cell_FormatRange
Below advanced methods for workbook and worksheet has been added in the demo:
Comment_Add
Comment_Delete
Image_Insert
Workbook_AddCopyWorksheet
Workbook_ChangeSheetIndex
Workbook_GetProperties
Worksheet_AddAutoFilter
Worksheet_AddDropdown
Worksheet_Delete
Worksheet_GetImages
Worksheet_SetActive
Worksheet_Protect
Worksheet_GetName
Added the latest row/column and formatting methods demos:
Row_SetHeight
Row_insert
Row_delete
Column_setwidth
Cell_WriteImageByName
Cell_UnMerge
Cell_Merge
Cells_FindByValue
Cell_Read
Cell_SetFormulaByIndex
Cell_CalculateByName
Worksheet_Calculate
ContainInRange
ConditionalFormating_AddRule
Select Conditional Rule Type from the following:
AboveAverage = 0,
AboveOrEqualAverage = 1,
BelowAverage = 2,
BelowOrEqualAverage = 3,
AboveStdDev = 4,
BelowStdDev = 5,
Bottom = 6,
BottomPercent = 7,
Top = 8,
TopPercent = 9,
Last7Days = 10,
LastMonth = 11,
LastWeek = 12,
NextMonth = 13,
NextWeek = 14,
ThisMonth = 15,
ThisWeek = 16,
Today = 17,
Tomorrow = 18,
Yesterday = 19,
GreaterThan = 29,
GreaterThanOrEqual = 30,
LessThan = 31,
LessThanOrEqual = 32
ConditionalFormating_DeleteAllRules
ConditionalFormating_GetAllRules
17. Worksheet_SetHeader
18. Worksheet_GetHeader
19. Address_From_RowCol
20. Address_From_Text
21. Worksheet_CopyRows