All Classes
Class
Description
This class stores a drawing shape having an alignment formatting.
This class contains the constants for vertical and horizontal text alignment when formatting cells.
This class stores the text alignment for drawing objects.
This class contains the constants for borderline styles when formatting cells.
This class stores the cell location.
This class contains the constants used for creating charts.
This class contains the constants used for creating a conditional formatting cell range.
This class contains the constants for data grouping.
This class contains the constants for allowable cell data types.
This class contains the constants for creating a data validator
This class stores the properties of the document summary information like company, scale, links dirty, category, hyperlink base, manager and custom properties.
A drawing is a graphical object that can be included inside an Excel document, like shapes, images, textboxes, comments, charts and chart elements.
A drawing is a graphical object that can be included inside an Excel worksheet, like shapes, images, textboxes, comments or charts.
This class stores a drawing shape having a 3D-formatting.
This class contains the constants for handling encoding in text file formats
This class contains the constants for available encryption types.
This class contains the constants for possible errors.
This class describes a formula that was array-entered into a range of cells.
This class stores the table autoformat information like font name, font size, font bold, font italic, word wrap,
font underline style, font subscript, font superscript, font strikethrough, background color,
foreground color, horizontal alignment, vertical alignment, number or date format,
cell locked or hidden, shrink, border type, border color.
This class stores the chart axis information like extends
label, fill settings, font settings, line settings, shadow settings, alignment settings, type of major and minor tick mark,
tick mark label, number format, rotation of the axis, visibility.
This class stores the formula for a calculated field of pivot table.
This class stores the cell information like value, format (font name, font size, font bold,
font italic, word wrap, font underline style, font subscript, font superscript, font
strikethrough, background color, foreground color, horizontal alignment, vertical alignment,
number or date format, cell locked or hidden, shrink, border type,
border color) and comment.
This class stores chart information like series, legend, axis, plot area, chart area, data table, title,
series gap and overlap, 3D perspective, 3D elevation, 3D rotation and 3D height.
This class stores the chart area information like fill settings, font settings, line settings and shadow settings.
This class stores the chart gridlines information like line settings, shadow settings and visibility.
This class stores the ChartLegend information like fill settings, font settings, line settings, shadow settings, legend position,
keys arrangement direction, visibility .
This class stores chart information like series, legend, axis, plot area, chart area, data table, title,
series gap and overlap, 3D perspective, 3D elevation, 3D rotation and 3D height.
This class stores the colors information for a theme.
This class stores the column information extends width and format (font name, font size, font bold, font italic,
word wrap, font underline style, font subscript, font superscript, font strikethrough, background color,
foreground color, horizontal alignment, vertical alignment, number or date format, column cells locked or hidden,
shrink, border type, border color).
This class stores the comment information like text, font name, font size, font style, foreground and comment position.
This class stores the condition of the conditional formatting information like
type, operator, first and second formula, font, border and pattern style.
This class stores the conditional formatting information like cells range and conditions.
This class allows to group and outline the cell ranges.
This class stores the data labels settings like label options, number format, fill settings, line settings, (font settings), 3D-format settings,
alignment settings and shadow settings.
This class stores the data table information like
line settings, fill settings, font settings, shadow settings, legend key visibility,
horizontal lines visibility, vertical lines visibility, outlines visibility, visibility.
This class restricts the cell entries to a specific data type (integers, decimal numbers, or text) and
sets limits on the valid entries.
The
ExcelDocument class is the main class that contains methods to generate or read a Microsoft Excel file.This class stores the effects information for a theme.
This class stores pivot table field information like name, area location, subtotals & filters options, layout & print options and sort order.
This class stores the auto-filter and advanced filter information.
This class stores the font information for a theme.
This class stores the footer information extends text, position (left, center, or right), font name, font size, underline, strikethrough, superscript, subscript, page number, the number of pages, date and time, file name.
This class stores the header information extends text, position (left, center, or right), font name, font size, underline, strikethrough, superscript, subscript, page number, the number of pages, date and time, file name.
This class stores the hyperlink information like position (first row, first column, last row, last column),
hyperlink type, description, URL, target frame, text mark and tool tip.
This class stores image information like image path and position in worksheet.
This class stores names with its information like title and formula.
This class stores some of the options of an Excel document, available in the main menu Tools/Options window.
This class stores page setup settings like print area, the rows to be repeated at top,
columns to be repeated at left, page orientation (portrait, landscape), paper size,
scaling factor, fit to pages width/height, paper margins, print order,
horizontal and vertical page breaks and other customizations like:
print gridlines, print black and white, print draft quality, print row and column headings, print comments.
This class stores pivot chart information like pivot table source and chart information.
This class stores pivot table information like name, location, data source, layout & format options, totals & filters, display, printing and data
options.
This class stores the plot area information like fill settings, line settings and shadow settings.
This class is a collection of cells.
This class stores the series information like
values, name, fill settings, line settings, shadow settings, data labels type, legend key visibility next to label,
marker type.
This class simulates a sheet.
This class stores the style information like font name, font size, font bold, font italic, word wrap,
font underline style, font subscript, font superscript, font strikethrough, background color,
foreground color, horizontal alignment, vertical alignment, number or date format,
cell locked or hidden, shrink, border type, border color.
This class simulates a worksheet table.
This class stores the theme information like theme colors, theme fonts and theme effects.
This class stores the titles information like
text, fill settings, line settings, font settings, alignment settings and shadow settings.
This class stores pivot table value field information like name, basic field, subtotal and number format.
This class simulates a worksheet.
This class contains the external links from the formulas inside the document.
This class contains the constants for the file properties of the Excel document.
This class contains the constants for fill effects when formatting cells.
This class stores a drawing shape having a fill formatting.
This class stores the fill options for images, shapes and other drawing objects.
This class stores a drawing shape having a font formatting.
This class stores the font options for shapes and other drawing objects.
This class contains the constants for the font underline style.
This class contains the allowable footer positions relative to page margins.
This class contains the constants for number and date format when formatting cells.
This class stores the 3D-formatting for drawing objects.
This class is used for formulas computation.
This class contains useful methods for parsing formulas.
This class stores the result of a formula.
This class stores the position, the color and the transparency of a stop for the gradient fill.
This class contains the allowable header positions relative to page margins.
This class contains the hyperlink type constants
Interface of the class stores a drawing shape having an alignment formatting.
Interface of the class that stores a drawing shape having a 3D-formatting.
Interface of the class that stores a drawing shape having a font formatting.
This class stores the license information.
This class stores the line color options for images, shapes and other drawing objects.
This class stores a drawing shape having a line color, a line style and a shadow formatting.
This class stores the line style options for images, shapes and other drawing objects.
This class simulates a list of objects.
This class contains the constants for page orientation, paper size, print comments options and page order when setting Page Setup options.
This class contains the constants for the pattern style.
This class contains the constants for the pivot tables.
This class stores the 3D-rotation for drawing objects.
This class stores the shadow options for images, shapes and other drawing objects.
This class contains predefined styles for formatting cells.
This class stores the properties of the summary information of the document like author, last author, application name, create date, comments, keywords, revision number, subject, title.
This class contains the constants for table (grid).
This class contains predefined themes for the document.
This class stores a theme color.
This class is a sheet of unknown type.