ActiveXLS v6.4.0 API Documentation

Namespace ActiveXLS

Class Summary
ExcelArrayFormula This class describes a formula that was array-entered into a range of cells.
ExcelAutoFormat 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.
ExcelCell 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.
ExcelChartSheet 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.
ExcelColumn 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).
ExcelComment This class stores the comment information extends text, font name, font size, font style, foreground and comment position.
ExcelCondition This class stores the condition of the conditional formatting information like type, operator, first and second formula, font, border and pattern style.
ExcelConditionalFormatting This class stores the conditional formatting information like cells range and conditions.
ExcelDataGroup This class allows to group and outline the cell ranges.
ExcelDataValidator This class restricts the cell entries to a specific data type (integers, decimal numbers, or text) and sets limits on the valid entries.
ExcelDocument The ExcelDocument class is the main class that contains methods to generate or read a Microsoft Excel file.
ExcelFooter 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.
ExcelHeader 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.
ExcelHyperlink 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.
ExcelImage This class stores image information like image path and position in worksheet.
ExcelName This class stores names with its information like title and formula.
ExcelOptions This class stores some of the options of an Excel document, available in the main menu Tools/Options window.
ExcelPageSetup 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.
ExcelRow This class is a collection of cells.
ExcelSheet This class simulates a sheet.
ExcelStyle 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.
ExcelTable This class simulates a worksheet table.
ExcelWorksheet This class simulates a worksheet.
ExternalLinks This class contains the external links from the formulas inside the document.
Formula This class is used for formulas computation.
UnknownSheet This class is a sheet of unknown type.
 


Copyright 2009 On Time Computing Solutions