Click or drag to resize

SautinSoft.Excel Namespace

Starting from 2002 we are developing .Net components to do all what you wish with documents in PDF, DOCX, RTF, HTML, Images and other formats.
Classes
 ClassDescription
Public classAnchorCell Represents the image binding object to cells used in ExcelPictureCollection on the worksheet.
Public classCellBorder Contains settings for a single cell border.
Public classCellBorders Collection of cell borders.
Public classCellRange Represents an object of a rectangular group of worksheet cells.
Public classCellRangeEnumerator Represents an enumerator object used for iterating cells in a CellRange.
Public classCellStyle Includes parameters for presenting cell information.
Public classCOptions Set up the info block properties for resulting documents, such as file version and document producer
Public classCOptionsFormula When processing formulas of the type - "CELL("filename", A1)" it is necessary to specify the path to the current file (stream) to ensure correct processing of the action. By default: Stream
Public classCPageStyle Allows to specify page properties for output PDF document: page size, orientation, page margins and page numbers
Public classCPageStyleCPageMargin Allows to set page margins in mm and inches
Public classCPageStyleCPageOrientation Allows to set page orientation for an output document. Not used if page size set as "Auto".
Public classCPageStyleCPageScale Allows to set scale produced document. Default option: FitByWidth.
Public classCPageStyleCPageSize Allows to set page size for output PDF document. Default option: Auto
Public classCPageStylePageNumbers Allows to set page numbers and their properties in PDF.
Public classCPageStyleSizes Class to set the component's options in inches, mm and pixels.
Public classCSheet Class which allows to set custom sheets from workbook for converting
Public classCSheetPrintedArea Allows to specify which custom sheets and cells will be exported into PDF, Word
Public classCsvSaveOptions 
Public classCUnicodeOptions Class with properties which allows to specify Unicode options, such as "Fonts" directory etc
Public classDocxSaveOptions 
Public classExcelCell Excel cell provides access to a single worksheet cell or to a merged range if the cell is merged.
Public classExcelCollectionBase Base class for row, column and cell collections.
Public classExcelColumn Excel column contains column options and a set of column cells.
Public classExcelColumnCollection Collection of ExcelColumn.
Public classExcelComment Represents a comment object used by Comment in the worksheet.
Public classExcelDocument Excel document contains Worksheet collection and workbook related properties and methods.
Public classExcelFill Contains fill pattern settings.
Public classExcelFont Contains font settings.
Public classExcelHeaderFooter Represents sheet header/footer.
Public classExcelHyperlink Hyperlink class.
Public classExcelLineBase Base class for the excel column and row classes.
Public classExcelLineCollectionBase Base class for row and column collections.
Public classExcelPicture Represents the image object used in ExcelPictureCollection on the worksheet.
Public classExcelPictureCollection Collection of the ExcelPicture.
Public classExcelPrintOptions Stores print related options.
Public classExcelRange Base class for representing one or more Excel cells.
Public classExcelRow Excel row contains row options and a set of row cells.
Public classExcelRowCollection Collection of ExcelRow.
Public classExcelViewOptions Stores view related options.
Public classExcelWorksheet Represents an Excel worksheet object.
Public classExcelWorksheetCollection Collection of (worksheets).
Public classHtmlSaveOptions 
Public classLoadOptions Represents a class for loading options of various file formats.
Public classPdfSaveOptions 
Public classPdfSecurity Contains details for encrypting and access permissions for a PDF document, such as Password, Permissions etc.
Public classPivotTable Represents a pivot table object.
Public classPivotTableCollection Represents a collection of objects PivotTable.
Public classRichText Represents a RichTextString collection object.
Public classRichTextFormat Represents an object of text formatting properties.
Public classRichTextString Represents an object for working with formatted text.
Public classRtfSaveOptions 
Public classSaveOptions Represents a base class for saving options of various file formats.
Public classXlsSaveOptions 
Public classXlsxSaveOptions 
Structures
 StructureDescription
Public structureMargins Represents a set of margins for print options.
Enumerations
 EnumerationDescription
Public enumerationCOptionsePdfVersion Allows to specify PDF version
Public enumerationCUnicodeOptionseUnicodeDetectFontsDirectory Allows to specify type of finding *.tff files. This is necessary to insert Unicode inside PDF.
Public enumerationeOutputFormat Enumerator with types of produced documents: PDF, DOCX, RTF, HTML
Public enumerationExcelPictureFormat Image formats.
Public enumerationFileFormat It is an enumeration of the file formats supported for downloading.
Public enumerationFillPattern Fill pattern styles used for ExcelFill.FillStyle.
Public enumerationHorizontalAlignmentStyle Horizontal alignment styles used for CellStyle.HorizontalAlignment.
Public enumerationLineStyle Line styles used for CellBorder.LineStyle.
Public enumerationMultipleBorders Flags for Excel cell borders and border groups.
Public enumerationPaperType Specifies paper size.
Public enumerationPdfEncryptionAlgorithm Specifies the encryption algorithm to use for encrypting a PDF document.
Public enumerationPdfPermissions Specifies the operations that are allowed to a user on an encrypted PDF document.
Public enumerationPositionOption Parameter that determines the nature of the image positioning on the worksheet.
Public enumerationScriptPosition Script positions used in ExcelFont.ScriptPosition.
Public enumerationSheetVisibility Set of options used in ExcelWorksheet.Visibility.
Public enumerationSingleBorder Different borders of Excel cells.
Public enumerationUnderlineStyle Underline styles used in ExcelFont.UnderlineStyle.
Public enumerationVerticalAlignmentStyle Vertical alignment styles used for CellStyle.VerticalAlignment.