ActiveXLS v6.4.0 API Documentation

Uses of Namespace
ActiveXLS

Namespaces that use ActiveXLS
ActiveXLS   
ActiveXLS.Constants   
 

Classes in ActiveXLS used by ActiveXLS
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.
 

Classes in ActiveXLS used by ActiveXLS.Constants
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.
 


Copyright 2009 On Time Computing Solutions