Namespace EasyXLS
package EasyXLS
-
ClassesClassDescriptionThis 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 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 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 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 restricts the cell entries to a specific data type (integers, decimal numbers, or text) and sets limits on the valid entries.The
ExcelDocumentclass is the main class that contains methods to generate or read a Microsoft Excel file.This class stores the auto-filter and advanced filter information.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 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 is a collection of cells.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 simulates a worksheet.This class contains the external links from the formulas inside the document.This class is used for formulas computation.This class stores the license information.This class is a sheet of unknown type.