Bytescout Spreadsheet SDK for .NET, ASP.NET, ActiveX

About Bytescout Spreadsheet SDKList of supported functions for formula calculationsGetting Startedin Visual Basic 6in VBScriptin Javascriptin Visual Basic.NETin Visual C# (Visual Studio 2003)in Visual C#in ASP.NETin CF.NET and Windows CEin Console version (command line)in CF.NET and Pocket PCAdvanced Examples (How To..)Advanced Examples (C#)Add Background ImageASP (classic ASP, Visual Studio 6)Generate XLS spreadsheetASP.NETHello WorldASP.NET (C#)Display XLS as HTMLHello WorldASP.NET (VB.NET)Display XLS as HTMLC#Add Background ImageAdd Chart AreaAdd Chart BarAdd Chart BubbleAdd Chart ColumnAdd Chart CombinationAdd Chart DoughnutAdd Chart LineAdd Chart PieAdd Chart RadarAdd Chart StockAdd Chart SurfaceAdd Chart XYScatterAdd imageAdd image into existing XLSAdd ImagesAdd Images AdvancedAdding columns into existing XLSAdding rows to existing XLSCalculating formula in cellCalculating XIRR functionCalculations and XLS as databaseCells alignmentChange cell width and heightChange column width and row heightChanging data in existing XLSConverting XLS to CSVConverting XLS to TXTConverting XLS to XLSXConverting XLS to XMLCopy rangeCopy worksheetCopyPaste ColumnsCopyPaste RowsCreate a report with table in XLSCreate WorksheetsCSV to SQL ServerDate formatting for cellsExport To 2D ArrayExport To Data TableExport To DatasetExport To HTMLExport To Jagged ArrayExport To ListExport To PDFExport to WinForms DataGridFont Settings for XLSXFont style for cellFonts available for cellsGet Cell ColorHiddenFormulaHiddenRowsAndColumnsImport From 2D ArrayImport From Data TableImport From DatasetImport From Jagged ArrayImport From ListImport From WinForms DataGridLine styles for cellsMerge 2 Documents into Single OneMerge cellsNumber formats for cellsODS to SQL ServerPDF To CSV To XLSRangeSortRead cell colorRead CSV filesRead Dates from cellsRead document propertiesRead format type of cellsRead ODS (Open Office Calc) filesRead TXT (tab delimited)Read XLSX (Office 2007) filesReading data from XLS into datasetReading formula from a cellReading merged cellsRemoving columns from existing XLSRemoving rows from existing XLSRename WorksheetRich text formatting for cellSearch TextSelect Active WorksheetShrinkToFit for cellsSwap cells and their valuesSwap WorksheetsTemplate To XLSTXT to SQL ServerUnicode TextUnmerge CellsUsing rich formatting to create a XLS reportValidating cells if cell value is in the rangeValidating cells with datesValidating data in cells and marking wrong with colorWrite document propertiesWriting formula to cellXLS to SQL ServerXLS to SQL Server (via CSV BULK INSERT)XLS to XML and XML to XLSXLSX (office 2007) writingXLSX to SQL ServerConsole version (.BAT)Batch to XLSBatch XLS to CSVJavaScriptHello WorldManaged C++HelloWorldPocketPC (CF.NET)Read XLSRead XLS (VB.NET)Write XLSWrite XLS (VB.NET)VBScriptAdd ImagesChange Column HeightChange Row HeightHello WorldRich Text FormattingVisual Basic .NETAdd Background ImageAdd Chart AreaAdd Chart BarAdd Chart BubbleAdd Chart ColumnAdd Chart CombinationAdd Chart DoughnutAdd Chart LineAdd Chart PieAdd Chart RadarAdd Chart StockAdd Chart SurfaceAdd Chart XYScatterAdd ImagesAdd Images AdvancedAdding columns into existing XLSAdding rows to existing XLSCalculating formula in cellCalculating XIRR functionCalculation and using XLS as databaseCells alignmentChange cell width and heightChange column width and row heightChanging data in existing XLSConverting XLS to CSVConverting XLS to TXTConverting XLS to XLSXConverting XLS to XMLCopy rangeCopy worksheetCopyPaste ColumnsCopyPaste RowsCreate a report with table in XLSCreate WorksheetsCSV to SQL ServerDate formatting for cellsExport To 2D ArrayExport To Data TableExport To DataSetExport To Jagged ArrayExport To ListExport to WinForms DataGridExportToHTMLFont Settings for XLSXFont style for cellFonts available for cellsGet Cell ColorHiddenFormulaHiddenRowsAndColumnsImport From 2D ArrayImport From DataSetImport From DataTableImport From Jagged ArrayImport From ListImport From WinForms DataGridLine styles for cellsMerge 2 Documents into Single OneMerge CellsNumber formats for cellsODS to SQL ServerPDF To CSV To XLSRead cell colorRead CSV filesRead Dates from cellsRead document propertiesRead format type of cellsRead ODS (Open Office Calc) filesRead XLSX (Office 2007) filesReading data from XLS into datasetReading formula from a cellReading merged cellsRemoving columns from existing XLSRemoving rows from existing XLSRename WorksheetRich text formatting for cellSearch TextSelect Active WorksheetShrinkToFit for cellsSwap Cells and their valuesSwap WorksheetsTemplate To XLSTXT to SQL ServerUnicode TextUnmerge CellsUsing rich formatting to create a XLS reportValidating cells if cell value is in the rangeValidating cells with datesValidating data in cells and marking wrong with colorWrite document propertiesWriting formula to cellXLS to SQL ServerXLS to SQL Server (via CSV BULK INSERT)XLS to XML and XML to XLSXLS2PDFXLSX (office 2007) writingXLSX to SQL ServerVisual Basic 6 (Visual Studio 6)Hello WorldVisual Basic.NET (Visual Studio 2005 and higher)HelloWorldVisual C# (Visual Studio 2003)Hello WorldVisual C# (Visual Studio 2005 and higher)HelloWorldVisual C++ (Visual Studio 6)Hello WorldWinCE (CF.NET)Read XLSRead XLS (VB.NET)Write XLSWrite XLS (VB.NET)Bytescout.Spreadsheet NamespaceBiffChartSaveException ClassBiffChartSaveException MembersBiffChartSaveException ConstructorBiffChartSaveException ConstructorBiffChartSaveException Constructor (String)BiffChartSaveException Constructor (SerializationInfo, StreamingContext)BiffChartSaveException Constructor (String, Exception)BiffChartSaveException MethodsBiffChartSaveException PropertiesBuiltInFuncException ClassBuiltInFuncException MembersBuiltInFuncException ConstructorBuiltInFuncException ConstructorBuiltInFuncException Constructor (String)BuiltInFuncException Constructor (SerializationInfo, StreamingContext)BuiltInFuncException Constructor (String, Exception)BuiltInFuncException MethodsBuiltInFuncException PropertiesCacheType EnumerationCell ClassCell MembersCell MethodsCalculate MethodClear MethodDispose MethodDispose MethodDispose Method (Boolean)Finalize MethodGetAddress MethodSetFontColorRGB MethodSetFontProperties MethodToDateTime MethodToDouble MethodToHTML MethodToInteger MethodToString MethodCell PropertiesAlignmentHorizontal PropertyAlignmentVertical PropertyBottomBorderColor PropertyBottomBorderStyle PropertyCellFormat PropertyContainsArrayFormula PropertyDiagonalBorderColor PropertyDiagonalBorderStyle PropertyFillPattern PropertyFillPatternBackColor PropertyFillPatternForeColor PropertyFont PropertyFontColor PropertyFontColorIndex PropertyFontEscapement PropertyFontUnderline PropertyFormula PropertyHiddenFormula PropertyIndent PropertyIsDiagonalDownLine PropertyIsDiagonalUpLine PropertyIsInteger PropertyLeftBorderColor PropertyLeftBorderStyle PropertyLocked PropertyMerged PropertyMergedWith PropertyMergedWithCell PropertyNumberFormatString PropertyRightBorderColor PropertyRightBorderStyle PropertyRotation PropertyShrinkToFit PropertyTextDirection PropertyTopBorderColor PropertyTopBorderStyle PropertyValue PropertyValueAsBoolean PropertyValueAsDateTime PropertyValueAsDouble PropertyValueAsExcelDisplays PropertyValueAsHTML PropertyValueAsInteger PropertyValueAsString PropertyValueAsUnformattedString PropertyValueDataType PropertyValueDataTypeByNumberFormatString PropertyWrap PropertyCellsSelectionMethod EnumerationColumn ClassColumn MembersColumn MethodsAutoFit MethodSetFontColorRGB MethodSetFontProperties MethodToString MethodColumn PropertiesAlignmentHorizontal PropertyAlignmentVertical PropertyBottomBorderColor PropertyBottomBorderStyle PropertyCellFormat PropertyDiagonalBorderColor PropertyDiagonalBorderStyle PropertyFillPattern PropertyFillPatternBackColor PropertyFillPatternForeColor PropertyFont PropertyFontColor PropertyFontColorIndex PropertyFontEscapement PropertyFontUnderline PropertyHidden PropertyHiddenFormula PropertyIndent PropertyIsDiagonalDownLine PropertyIsDiagonalUpLine PropertyIsFormatted PropertyIsNotEmptyCells PropertyItem PropertyLeftBorderColor PropertyLeftBorderStyle PropertyLocked PropertyNumberFormat PropertyRightBorderColor PropertyRightBorderStyle PropertyRotation PropertyShrinkToFit PropertyTextDirection PropertyTopBorderColor PropertyTopBorderStyle PropertyWidth PropertyWrap PropertyColumns ClassColumns MembersColumns Fieldsmax Fieldmin FieldColumns MethodsCopyAndPaste MethodDelete MethodDelete Method (Int32)Delete Method (Int32, Int32)Insert MethodInsert Method (Int32)Insert Method (Int32, Int32)Columns PropertiesFirstFormatedColumn PropertyItem PropertyLastFormatedColumn PropertyConversionOptions ClassConversionOptions MembersConversionOptions ConstructorConversionOptions MethodsConversionOptions PropertiesDelimiter PropertyOutputFormat PropertyQuote PropertyDefinedName ClassDefinedName MembersDefinedName MethodsDefinedName PropertiesComment PropertyIndex PropertyName PropertyRefersTo PropertyValue PropertyVisible PropertyExtendedFormat ClassExtendedFormat MembersExtendedFormat MethodsDispose MethodDispose MethodDispose Method (Boolean)Finalize MethodFormulaReferenceException ClassFormulaReferenceException MembersFormulaReferenceException ConstructorFormulaReferenceException ConstructorFormulaReferenceException Constructor (String)FormulaReferenceException Constructor (SerializationInfo, StreamingContext)FormulaReferenceException Constructor (String, Exception)FormulaReferenceException MethodsFormulaReferenceException PropertiesFuncNotSupportedException ClassFuncNotSupportedException MembersFuncNotSupportedException ConstructorFuncNotSupportedException ConstructorFuncNotSupportedException Constructor (String)FuncNotSupportedException Constructor (SerializationInfo, StreamingContext)FuncNotSupportedException Constructor (String, Exception)FuncNotSupportedException MethodsFuncNotSupportedException PropertiesHTMLTemplate ClassHTMLTemplate MembersHTMLTemplate ConstructorHTMLTemplate MethodsSaveAsHTML MethodSaveAsHTML Method (Worksheet, Stream)SaveAsHTML Method (Worksheet, String)SaveHTML MethodHTMLTemplate PropertiesCellHeader PropertyTableHeader PropertyHyperLink ClassHyperLink MembersHyperLink ConstructorHyperLink Constructor (CellsRange, String)HyperLink Constructor (CellsRange, String, String, String, String)HyperLink MethodsHyperLink PropertiesAddress PropertyRange PropertyScreenTip PropertySubAddress PropertyTextToDisplay PropertyHyperLinks ClassHyperLinks MembersHyperLinks MethodsAdd MethodAdd Method (HyperLink)Add Method (CellsRange, String, String, String, String)RemoveAt MethodHyperLinks PropertiesCount PropertyItem PropertyInvalidPasswordException ClassInvalidPasswordException MembersInvalidPasswordException ConstructorInvalidPasswordException ConstructorInvalidPasswordException Constructor (String)InvalidPasswordException Constructor (SerializationInfo, StreamingContext)InvalidPasswordException Constructor (String, Exception)InvalidPasswordException MethodsInvalidPasswordException PropertiesOpenXMLParserException ClassOpenXMLParserException MembersOpenXMLParserException ConstructorOpenXMLParserException ConstructorOpenXMLParserException Constructor (String)OpenXMLParserException Constructor (SerializationInfo, StreamingContext)OpenXMLParserException Constructor (String, Exception)OpenXMLParserException MethodsOpenXMLParserException PropertiesOutputFormat EnumerationRange ClassRange MembersRange MethodsCalculate MethodCopyInto MethodCopyInto Method (String)CopyInto Method (Int32, Int32)Merge MethodSort MethodSort Method (String, SortOrder, String, SortOrder, String, SortOrder, Boolean, SortOrientation, SortDataOption, SortDataOption, SortDataOption)Sort Method (String, SortOrder, Boolean, SortOrientation, SortDataOption)UnMerge MethodRange PropertiesAlignmentHorizontal PropertyAlignmentVertical PropertyBottomBorderColor PropertyBottomBorderStyle PropertyBottomRowIndex PropertyCellFormat PropertyDiagonalBorderColor PropertyDiagonalBorderStyle PropertyFillPattern PropertyFillPatternBackColor PropertyFillPatternForeColor PropertyFont PropertyFontColor PropertyFontColorIndex PropertyFontEscapement PropertyFontUnderline PropertyFormula PropertyHiddenFormula PropertyIndent PropertyInnerBorderColor PropertyInnerBorderStyle PropertyIsDiagonalDownLine PropertyIsDiagonalUpLine PropertyIsNotEmptyCells PropertyLeftBorderColor PropertyLeftBorderStyle PropertyLeftColumnIndex PropertyLocked PropertyNumberFormatString PropertyOuterBorderColor PropertyOuterBorderStyle PropertyRightBorderColor PropertyRightBorderStyle PropertyRightColumnIndex PropertyRotation PropertyShrinkToFit PropertyTextDirection PropertyTopBorderColor PropertyTopBorderStyle PropertyTopRowIndex PropertyValue PropertyValueAsHTML PropertyValueDataTypeByNumberFormatString PropertyWrap PropertyRow ClassRow MembersRow Fieldsmax Fieldmin FieldrecalcMinMax FieldRow MethodsAutoFit MethodDeleteCell MethodInsertCell MethodSetFontColorRGB MethodSetFontProperties MethodToString MethodRow PropertiesAlignmentHorizontal PropertyAlignmentVertical PropertyBottomBorderColor PropertyBottomBorderStyle PropertyCellFormat PropertyColumnMax PropertyColumnMin PropertyDiagonalBorderColor PropertyDiagonalBorderStyle PropertyFillPattern PropertyFillPatternBackColor PropertyFillPatternForeColor PropertyFont PropertyFontColor PropertyFontColorIndex PropertyFontEscapement PropertyFontUnderline PropertyHeight PropertyHidden PropertyHiddenFormula PropertyIndent PropertyIsDiagonalDownLine PropertyIsDiagonalUpLine PropertyIsFormatted PropertyIsNotEmptyCells PropertyItem PropertyLeftBorderColor PropertyLeftBorderStyle PropertyLocked PropertyNumberFormat PropertyRightBorderColor PropertyRightBorderStyle PropertyRotation PropertyShrinkToFit PropertyTextDirection PropertyTopBorderColor PropertyTopBorderStyle PropertyUseStandardHeight PropertyWrap PropertyRows ClassRows MembersRows Fieldsmax Fieldmin FieldRows MethodsCopyAndPaste MethodDelete MethodDelete Method (Int32)Delete Method (Int32, Int32)Insert MethodInsert Method (Int32)Insert Method (Int32, Int32)Rows PropertiesFirstFormatedRow PropertyItem PropertyLastFormatedRow PropertySearchOptions ClassSearchOptions MembersSearchOptions ConstructorSearchOptions MethodsSearchOptions PropertiesCaseSensitiveSearch PropertyRegexSearch PropertySearchBackwards PropertySearchString PropertySpreadsheet ClassSpreadsheet MembersSpreadsheet ConstructorSpreadsheet MethodsClose MethodDispose MethodExportTo2DArray MethodExportTo2DArray MethodExportTo2DArray Method (Int32)ExportTo2DArray Method (String)ExportToDataSet MethodExportToDataSet MethodExportToDataSet Method (DataSet)ExportToDataTable MethodExportToDataTable MethodExportToDataTable Method (Int32)ExportToDataTable Method (String)ExportToJaggedArray MethodExportToJaggedArray MethodExportToJaggedArray Method (Int32)ExportToJaggedArray Method (String)ExportToList MethodExportToList Method (IList)ExportToList Method (IList, Int32)ExportToList Method (IList, String)Finalize MethodGetAsBytesArray MethodGetAsBytesArrayCSV MethodGetAsBytesArrayHTML MethodGetAsBytesArrayHTML MethodGetAsBytesArrayHTML Method (Int32)GetAsBytesArrayTXT MethodGetAsBytesArrayXLS MethodGetAsBytesArrayXLSX MethodGetAsBytesArrayXML MethodImportFrom2DArray MethodImportFrom2DArray Method (String[,])ImportFrom2DArray Method (String[,], Int32)ImportFrom2DArray Method (String[,], String)ImportFromDataSet MethodImportFromDataSet Method (DataSet)ImportFromDataSet Method (DataSet, UInt32)ImportFromDataTable MethodImportFromDataTable Method (DataTable)ImportFromDataTable Method (DataTable, Int32)ImportFromDataTable Method (DataTable, String)ImportFromDataTable Method (DataTable, UInt32)ImportFromJaggedArray MethodImportFromJaggedArray Method (String[][])ImportFromJaggedArray Method (String[][], Int32)ImportFromJaggedArray Method (String[][], String)ImportFromList MethodImportFromList Method (IList)ImportFromList Method (IList, Int32)ImportFromList Method (IList, String)LoadFromFile MethodLoadFromFile Method (String)LoadFromFile Method (String, CacheType)LoadFromFile Method (String, String)LoadFromFile Method (String, CacheType, String)LoadFromFile Method (String, String, Encoding)LoadFromFile Method (String, CacheType, String, Encoding)LoadFromFile Method (String, CacheType, String, Encoding, String)LoadFromStream MethodLoadFromStream Method (Stream)LoadFromStream Method (Stream, CacheType)LoadFromStream Method (Stream, SpreadsheetFormatType)LoadFromStream Method (Stream, CacheType, String)LoadFromStream Method (Stream, SpreadsheetFormatType, CacheType)LoadFromStream Method (Stream, SpreadsheetFormatType, String, Encoding)LoadFromStream Method (Stream, SpreadsheetFormatType, CacheType, String, Encoding)LoadFromStream Method (Stream, SpreadsheetFormatType, CacheType, String, Encoding, String)SaveAs MethodSaveAs Method (String)SaveAs Method (String, SpreadsheetFormatType)SaveAsCSV MethodSaveAsCSV Method (String)SaveAsCSV Method (String, String)SaveAsHTML MethodSaveAsHTML Method (String)SaveAsHTML Method (String, Boolean)SaveAsPDF MethodSaveAsPDF Method (String)SaveAsPDF Method (String, Boolean)SaveAsTXT MethodSaveAsTXT Method (String)SaveAsTXT Method (String, String)SaveAsXLS MethodSaveAsXLSX MethodSaveAsXLSX Method (String)SaveAsXLSX Method (String, String)SaveAsXML MethodSaveToStream MethodSaveToStream Method (Stream)SaveToStream Method (Stream, SpreadsheetFormatType)SaveToStreamCSV MethodSaveToStreamCSV Method (Stream)SaveToStreamCSV Method (Stream, String)SaveToStreamHTML MethodSaveToStreamHTML Method (Stream)SaveToStreamHTML Method (Stream, Int32)SaveToStreamTXT MethodSaveToStreamTXT Method (Stream)SaveToStreamTXT Method (Stream, String)SaveToStreamXLS MethodSaveToStreamXLSX MethodSaveToStreamXLSX Method (Stream)SaveToStreamXLSX Method (Stream, String)SaveToStreamXML MethodWorksheet MethodSpreadsheet PropertiesCache PropertyOptimizeMemoryUsageOnSave PropertyOptions PropertyRegistrationKey PropertyRegistrationName PropertySearchOptions PropertyUserName PropertyWorkbook PropertyWorksheets PropertySpreadsheetChartException ClassSpreadsheetChartException MembersSpreadsheetChartException ConstructorSpreadsheetChartException ConstructorSpreadsheetChartException Constructor (String)SpreadsheetChartException Constructor (SerializationInfo, StreamingContext)SpreadsheetChartException Constructor (String, Exception)SpreadsheetChartException MethodsSpreadsheetChartException PropertiesSpreadsheetComponent ClassSpreadsheetComponent MembersSpreadsheetComponent ConstructorSpreadsheetComponent ConstructorSpreadsheetComponent Constructor (IContainer)SpreadsheetComponent MethodsClose MethodDispose MethodDispose MethodDispose Method (Boolean)Finalize MethodGetAsBytesArray MethodGetAsBytesArrayCSV MethodGetAsBytesArrayHTML MethodGetAsBytesArrayHTML MethodGetAsBytesArrayHTML Method (Int32)GetAsBytesArrayTXT MethodGetAsBytesArrayXLS MethodGetAsBytesArrayXLSX MethodGetAsBytesArrayXML MethodLoadFromFile MethodLoadFromFile Method (String)LoadFromFile Method (String, CacheType)LoadFromFile Method (String, CacheType, String)LoadFromFile Method (String, String, Encoding)LoadFromFile Method (String, CacheType, String, Encoding)LoadFromFile Method (String, CacheType, String, Encoding, String)LoadFromStream MethodLoadFromStream Method (Stream)LoadFromStream Method (Stream, CacheType)LoadFromStream Method (Stream, SpreadsheetFormatType)LoadFromStream Method (Stream, SpreadsheetFormatType, CacheType)LoadFromStream Method (Stream, SpreadsheetFormatType, String, Encoding)LoadFromStream Method (Stream, SpreadsheetFormatType, CacheType, String, Encoding)MemberwiseClone MethodSaveAs MethodSaveAs Method (String)SaveAs Method (String, SpreadsheetFormatType)SaveAsCSV MethodSaveAsCSV Method (String)SaveAsCSV Method (String, String)SaveAsHTML MethodSaveAsHTML Method (String)SaveAsHTML Method (String, Boolean)SaveAsTXT MethodSaveAsXLS MethodSaveAsXLSX MethodSaveAsXML MethodSaveToStream MethodSaveToStream Method (Stream)SaveToStream Method (Stream, SpreadsheetFormatType)SaveToStreamCSV MethodSaveToStreamCSV Method (Stream)SaveToStreamCSV Method (Stream, String)SaveToStreamHTML MethodSaveToStreamHTML Method (Stream)SaveToStreamHTML Method (Stream, Int32)SaveToStreamTXT MethodSaveToStreamXLS MethodSaveToStreamXLSX MethodSaveToStreamXML MethodWorksheet MethodSpreadsheetComponent PropertiesCache PropertyOptions PropertyUserKey PropertyUserName PropertyWorkbook PropertySpreadsheetComponent EventsSpreadsheetException ClassSpreadsheetException MembersSpreadsheetException ConstructorSpreadsheetException ConstructorSpreadsheetException Constructor (String)SpreadsheetException Constructor (SerializationInfo, StreamingContext)SpreadsheetException Constructor (String, Exception)SpreadsheetException MethodsSpreadsheetException PropertiesSpreadsheetFont ClassSpreadsheetFont MembersSpreadsheetFont ConstructorSpreadsheetFont Constructor (String, Single)SpreadsheetFont Constructor (String, Single, FontStyle, Color, FontEscapementType, FontUnderlineStyle, Byte)SpreadsheetFont MethodsDispose MethodDispose MethodDispose Method (Boolean)Equality OperatorEquals MethodFinalize MethodGetHashCode MethodInequality OperatorSpreadsheetFont PropertiesBold PropertyCharacterSet PropertyEscapement PropertyFont PropertyFontColor PropertyFontName PropertyHeight PropertyItalic PropertyStruckOut PropertyStyle PropertyUnderline PropertySpreadsheetFormulaException ClassSpreadsheetFormulaException MembersSpreadsheetFormulaException ConstructorSpreadsheetFormulaException ConstructorSpreadsheetFormulaException Constructor (String)SpreadsheetFormulaException Constructor (SerializationInfo, StreamingContext)SpreadsheetFormulaException Constructor (String, Exception)SpreadsheetFormulaException MethodsSpreadsheetFormulaException PropertiesSpreadsheetOptions ClassSpreadsheetOptions MembersSpreadsheetOptions ConstructorSpreadsheetOptions MethodsSetExcel2003Limits MethodSetExcel2007Limits MethodSetOpenOffice3Limits MethodSpreadsheetOptions PropertiesMaxColumnCountAllowed PropertyMaxRowCountAllowed PropertyMaxStringLengthAllowedPerCell PropertyThrowExceptionOnUnsupportedFormula PropertyThrowExceptionsOnFormatIncompatibilities PropertyThrowExceptionsOnFormatLimits PropertySpreadsheetProtectionException ClassSpreadsheetProtectionException MembersSpreadsheetProtectionException ConstructorSpreadsheetProtectionException ConstructorSpreadsheetProtectionException Constructor (String)SpreadsheetProtectionException Constructor (SerializationInfo, StreamingContext)SpreadsheetProtectionException Constructor (String, Exception)SpreadsheetProtectionException MethodsSpreadsheetProtectionException PropertiesSpreadsheetProtectionPasswordRequired ClassSpreadsheetProtectionPasswordRequired MembersSpreadsheetProtectionPasswordRequired ConstructorSpreadsheetProtectionPasswordRequired ConstructorSpreadsheetProtectionPasswordRequired Constructor (String)SpreadsheetProtectionPasswordRequired Constructor (SerializationInfo, StreamingContext)SpreadsheetProtectionPasswordRequired Constructor (String, Exception)SpreadsheetProtectionPasswordRequired MethodsSpreadsheetProtectionPasswordRequired PropertiesSpreadsheetProtectionXLSSheetLimitationsException ClassSpreadsheetProtectionXLSSheetLimitationsException MembersSpreadsheetProtectionXLSSheetLimitationsException ConstructorSpreadsheetProtectionXLSSheetLimitationsException ConstructorSpreadsheetProtectionXLSSheetLimitationsException Constructor (String)SpreadsheetProtectionXLSSheetLimitationsException Constructor (SerializationInfo, StreamingContext)SpreadsheetProtectionXLSSheetLimitationsException Constructor (String, Exception)SpreadsheetProtectionXLSSheetLimitationsException MethodsSpreadsheetProtectionXLSSheetLimitationsException PropertiesSpreadsheetReferenceException ClassSpreadsheetReferenceException MembersSpreadsheetReferenceException ConstructorSpreadsheetReferenceException ConstructorSpreadsheetReferenceException Constructor (String)SpreadsheetReferenceException Constructor (SerializationInfo, StreamingContext)SpreadsheetReferenceException Constructor (String, Exception)SpreadsheetReferenceException MethodsSpreadsheetReferenceException PropertiesSpreadsheetWebControl ClassSpreadsheetWebControl MembersSpreadsheetWebControl ConstructorSpreadsheetWebControl MethodsClose MethodDataBind MethodDispose MethodFinalize MethodFindControl MethodGetAsBytesArray MethodGetAsBytesArrayCSV MethodGetAsBytesArrayHTML MethodGetAsBytesArrayHTML MethodGetAsBytesArrayHTML Method (Int32)GetAsBytesArrayTXT MethodGetAsBytesArrayXLS MethodGetAsBytesArrayXLSX MethodGetAsBytesArrayXML MethodLoadFromFile MethodLoadFromFile Method (String)LoadFromFile Method (String, CacheType)LoadFromFile Method (String, String)LoadFromFile Method (String, CacheType, String)LoadFromFile Method (String, String, Encoding)LoadFromFile Method (String, CacheType, String, Encoding)LoadFromFile Method (String, CacheType, String, Encoding, String)LoadFromStream MethodLoadFromStream Method (Stream)LoadFromStream Method (Stream, CacheType)LoadFromStream Method (Stream, SpreadsheetFormatType)LoadFromStream Method (Stream, SpreadsheetFormatType, CacheType)LoadFromStream Method (Stream, SpreadsheetFormatType, String, Encoding)LoadFromStream Method (Stream, SpreadsheetFormatType, CacheType, String, Encoding)RenderBeginTag MethodRenderContents MethodRenderControl MethodRenderEndTag MethodSaveAs MethodSaveAs Method (String)SaveAs Method (String, SpreadsheetFormatType)SaveAsCSV MethodSaveAsHTML MethodSaveAsHTML Method (String)SaveAsHTML Method (String, Boolean)SaveAsTXT MethodSaveAsXLS MethodSaveAsXLSX MethodSaveAsXML MethodSaveToStream MethodSaveToStream Method (Stream)SaveToStream Method (Stream, SpreadsheetFormatType)SaveToStreamCSV MethodSaveToStreamHTML MethodSaveToStreamHTML Method (Stream)SaveToStreamHTML Method (Stream, Int32)SaveToStreamTXT MethodSaveToStreamXLS MethodSaveToStreamXLSX MethodSaveToStreamXML MethodWorksheet MethodSpreadsheetWebControl PropertiesCache PropertyOptions PropertyUserKey PropertyUserName PropertyWorkbook PropertySpreadsheetWebControl EventsWorkbook ClassWorkbook MembersWorkbook MethodsCalculate MethodProtect MethodProtectFromModifications MethodRemovePassword MethodUnProtect MethodWorkbook PropertiesAddInFunctionsNamesLocale PropertyAutoCalculation PropertyCharts PropertyColors PropertyDefaultFont PropertyDocumentProperties PropertyEncryptionKeyLength PropertyEncryptionType PropertyExternalReferenceUpdate PropertyLocale PropertyNames PropertyPassword PropertyProperties PropertyProtectStructure PropertyProtectWindows PropertyRangeSelectionMethod PropertyReadOnlyRecommended PropertyWorksheets PropertyWorksheet ClassWorksheet MembersWorksheet ConstructorWorksheet MethodsCalculate MethodCell MethodCell Method (String)Cell Method (Int32, Int32)Find MethodFind MethodFind Method (String, Boolean, Boolean, Boolean)FindNext MethodGetAsBytesArrayCSV MethodGetAsBytesArrayHTML MethodGetAsBytesArrayTXT MethodGetAsBytesArrayXML MethodProtect MethodProtect Method (String)Protect Method (String, EnhancedSheetProtection)Range MethodRange Method (String)Range Method (Int32, Int32, Int32, Int32)SaveAsCSV MethodSaveAsCSV Method (Stream)SaveAsCSV Method (String)SaveAsCSV Method (Stream, ConversionOptions)SaveAsCSV Method (Stream, String)SaveAsCSV Method (String, ConversionOptions)SaveAsCSV Method (String, String)SaveAsCSV Method (Stream, String, String)SaveAsCSV Method (String, String, String)SaveAsHTML MethodSaveAsHTML Method (Stream)SaveAsHTML Method (StreamWriter)SaveAsHTML Method (String)SaveAsPDF MethodSaveAsPDF Method (Stream)SaveAsPDF Method (String)SaveAsPDF Method (Stream, Boolean)SaveAsPDF Method (String, Boolean)SaveAsTXT MethodSaveAsTXT Method (Stream)SaveAsTXT Method (String)SaveAsTXT Method (Stream, ConversionOptions)SaveAsTXT Method (Stream, String)SaveAsTXT Method (String, ConversionOptions)SaveAsTXT Method (String, String)SaveAsTXT Method (Stream, String, String)SaveAsTXT Method (String, String, String)SaveAsXML MethodSaveAsXML Method (Stream)SaveAsXML Method (String)UnProtect MethodWorksheet PropertiesActive PropertyBackgroundPicture PropertyCharts PropertyColumns PropertyDefaultColumnWidth PropertyHyperlinks PropertyIsEmpty PropertyItem PropertyItem Property (String)Item Property (Int32, Int32)Name PropertyNotEmptyColumnMax PropertyNotEmptyColumnMin PropertyNotEmptyRowMax PropertyNotEmptyRowMin PropertyPageSetup PropertyPictures PropertyProtected PropertyProtectionOptions PropertyRows PropertyUsedRangeColumnMax PropertyUsedRangeColumnMin PropertyUsedRangeRowMax PropertyUsedRangeRowMin PropertyViewOptions PropertyVisible PropertyWorksheets ClassWorksheets MembersWorksheets ConstructorWorksheets MethodsAdd MethodAdd MethodAdd Method (String)ByName MethodCopy MethodCopy Method (Int32, Int32, String)Copy Method (Int32, Int32, String, Boolean)Delete MethodDelete Method (Int32)Delete Method (String)DeleteAll MethodGetEnumerator MethodIndexOf MethodInsert MethodMove MethodWorksheets PropertiesCount PropertyItem PropertyItem Property (Int32)Item Property (String)Bytescout.Spreadsheet.BaseClasses NamespaceCellAddress ClassCellAddress MembersCellAddress ConstructorCellAddress ConstructorCellAddress Constructor (Int32, Int32)CellAddress MethodsGetCellAddress MethodIsEmpty MethodCellAddress PropertiesColumn PropertyColumnRelative PropertyRow PropertyRowRelative PropertyCellRangeAddress StructureCellRangeAddress MembersCellRangeAddress ConstructorCellRangeAddress FieldsFirstColumn FieldFirstColumnRelative FieldFirstRow FieldFirstRowRelative FieldLastColumn FieldLastColumnRelative FieldLastRow FieldLastRowRelative FieldCellRangeAddress MethodsGetCellRangeAddress MethodPageSetup ClassPageSetup MembersPageSetup ConstructorPageSetup MethodsPageSetup PropertiesBlackAndWhite PropertyBottomMargin PropertyCenterHorizontally PropertyCenterVertically PropertyCopies PropertyDraft PropertyFirstPageNumber PropertyFitToPagesTall PropertyFitToPagesWide PropertyFooterMargin PropertyHeaderMargin PropertyLeftMargin PropertyOrder PropertyOrientation PropertyPaperSize PropertyPrintComments PropertyPrintErrors PropertyPrintNotes PropertyPrintQualityHorizontal PropertyPrintQualityVertical PropertyRightMargin PropertyTopMargin PropertyUseFirstPageNumber PropertyZoom PropertyViewOptions ClassViewOptions MembersViewOptions MethodsViewOptions PropertiesActivePane PropertyFrozenNoSplit PropertyGridLineColor PropertyGridLinesColorEnabled PropertyPageBreakPreview PropertyPaged PropertyPanesFrozen PropertyRightToLeft PropertySelected PropertyShowFormulas PropertyShowGridLines PropertyShowGuts PropertyShowSheetHeaders PropertyShowZeroValues PropertySplitColumn PropertySplitHorizontal PropertySplitRow PropertySplitVertical PropertyZoom PropertyXLSCompoundFile ClassXLSCompoundFile MembersXLSCompoundFile MethodsBytescout.Spreadsheet.Charts NamespaceAxisCrossingPoint EnumerationAxisOrientation EnumerationAxisPosition EnumerationBarGrouping EnumerationBorder ClassBorder MembersBorder ConstructorBorder MethodsEquality OperatorEquals MethodGetHashCode MethodInequality OperatorBorder PropertiesColor PropertyColorIndex PropertyLineStyle PropertyWeight PropertyBubbleSizeRepresents EnumerationCategoryAxis ClassCategoryAxis MembersCategoryAxis MethodsCategoryAxis PropertiesAutomaticCategory PropertyLabelAlignment PropertyLabelOffset PropertyShowLabelAsFlatText PropertyChart ClassChart MembersChart MethodsChart PropertiesBackWall PropertyChartArea PropertyChartGroups PropertyChartTitle PropertyChartType PropertyDepthPercent PropertyDisplayBlanksAs PropertyElevation PropertyFloor PropertyHeightPercent PropertyLegend PropertyName PropertyPerspective PropertyPlacementType PropertyPlotArea PropertyPlotVisibleOnly PropertyRightAngleAxes PropertyRotation PropertyRoundedCorners PropertySeriesCollection PropertyShowAutoTitle PropertyShowDataLabelsOverMax PropertySideWall PropertyXAxis PropertyYAxis PropertyZAxis PropertyChartArea ClassChartArea MembersChartArea MethodsChartArea PropertiesHeight PropertyLeft PropertyTop PropertyWidth PropertyChartAxis ClassChartAxis MembersChartAxis MethodsChartAxis PropertiesCrossingPoint PropertyCrossingValue PropertyDoNotDraw PropertyMajorTickMark PropertyMinorTickMark PropertyOrientation PropertyPosition PropertyShowMajorGridLines PropertyShowMinorGridLines PropertyTickLabelPosition PropertyChartCollection ClassChartCollection MembersChartCollection MethodsAddChart MethodAddChart Method (ChartType)AddChart Method (Int32, Int32, ChartType)AddChartAndFitInto MethodCopyTo MethodGetEnumerator MethodChartCollection PropertiesCount PropertyIsSynchronized PropertyItem PropertySyncRoot PropertyChartGroup ClassChartGroup MembersChartGroup ConstructorChartGroup MethodsChartGroup PropertiesBubbleScale PropertyDoughnutHoleSize PropertyFirstSliceAngle PropertyGapWidth PropertyHasHiLoLines PropertyHiLoLines PropertyShowNegativeBubbles PropertySizeRepresents PropertyVaryByCategories PropertyChartGroupCollection ClassChartGroupCollection MembersChartGroupCollection ConstructorChartGroupCollection MethodsGetEnumerator MethodChartGroupCollection PropertiesCount PropertyItem PropertyChartLineStyle EnumerationChartTitle ClassChartTitle MembersChartTitle MethodsChartTitle PropertiesBorder PropertyFill PropertyFont PropertyLeft PropertyOrientation PropertyShadow PropertyText PropertyTop PropertyChartType EnumerationColorFormat ClassColorFormat MembersColorFormat MethodsColorFormat PropertiesColor PropertyRGB PropertySchemeColor PropertyDataLabels ClassDataLabels MembersDataLabels ConstructorDataLabels MethodsDataLabels PropertiesShowBubbleSize PropertyShowCategoryName PropertyShowLeaderLines PropertyShowLegendKey PropertyShowPercent PropertyShowSeriesName PropertyShowValue PropertyDisplayBlanksAs EnumerationFillFormat ClassFillFormat MembersFillFormat ConstructorFillFormat MethodsEquality OperatorEquals MethodGetHashCode MethodInequality OperatorFillFormat PropertiesBackColor PropertyForeColor PropertyPattern PropertyGrouping EnumerationHiLoLines ClassHiLoLines MembersHiLoLines ConstructorHiLoLines MethodsHiLoLines PropertiesBorder PropertyInterior ClassInterior MembersInterior ConstructorInterior MethodsInterior PropertiesColor PropertyColorIndex PropertyPattern PropertyPatternColor PropertyPatternColorIndex PropertyLabelAlignment EnumerationLayout ClassLayout MembersLayout ConstructorLayout MethodsLayout PropertiesAuto PropertyHeight PropertyLeft PropertyTop PropertyWidth PropertyLegend ClassLegend MembersLegend ConstructorLegend MethodsLegend PropertiesLayout PropertyMayBeOverlapped PropertyPosition PropertyLegendPosition EnumerationMarker ClassMarker MembersMarker ConstructorMarker MethodsMarker PropertiesSize PropertyStyle PropertyMarkerStyle EnumerationOutline ClassOutline MembersOutline MethodsOutline PropertiesColor PropertyLineStyle PropertyWidth PropertyPlotArea ClassPlotArea MembersPlotArea MethodsPlotArea PropertiesBorder PropertyInterior PropertyLayout PropertySeries ClassSeries MembersSeries ConstructorSeries Constructor (Range)Series Constructor (Range, Range)Series Constructor (Range, Range, Range)Series MethodsSeries PropertiesBubbleSizes PropertyChartType PropertyDataLabels PropertyExplosion PropertyHas3DEffect PropertyInvertIfNegative PropertyMarkerSize PropertyMarkerStyle PropertyName PropertyShapeProperties PropertySmooth PropertyValues PropertyXValues PropertySeriesAxis ClassSeriesAxis MembersSeriesAxis MethodsSeriesAxis PropertiesSeriesCollection ClassSeriesCollection MembersSeriesCollection Fieldsm_series FieldSeriesCollection MethodsAdd MethodCopyTo MethodGetEnumerator MethodSeriesCollection PropertiesCount PropertyIsSynchronized PropertyItem PropertySyncRoot PropertyShapeProperties ClassShapeProperties MembersShapeProperties ConstructorShapeProperties MethodsShapeProperties PropertiesFillColor PropertyOutline PropertySurface ClassSurface MembersSurface ConstructorSurface MethodsSurface PropertiesThickness PropertyTickLabelPosition EnumerationTickMark EnumerationValueAxis ClassValueAxis MembersValueAxis MethodsValueAxis PropertiesCrossesBetweenCategories PropertyMajorUnit PropertyMinorUnit PropertyValuesSeries ClassValuesSeries MembersValuesSeries ConstructorValuesSeries MethodsValuesSeries PropertiesBytescout.Spreadsheet.COM NamespaceICell InterfaceICell MembersICell MethodsCalculate MethodClear MethodGetAddress MethodToDateTime MethodToDouble MethodToHTML MethodToInteger MethodToString MethodICell PropertiesContainsArrayFormula PropertyFormula PropertyIsInteger PropertyMerged PropertyMergedWith PropertyMergedWithCell PropertyNumberFormatString PropertyValue PropertyValueAsBoolean PropertyValueAsDateTime PropertyValueAsDouble PropertyValueAsExcelDisplays PropertyValueAsHTML PropertyValueAsInteger PropertyValueAsString PropertyValueAsUnformattedString PropertyValueDataType PropertyValueDataTypeByNumberFormatString PropertyICellAddress InterfaceICellAddress MembersICellAddress MethodsIsEmpty MethodICellAddress PropertiesColumn PropertyColumnRelative PropertyRow PropertyRowRelative PropertyICellsRange InterfaceICellsRange MembersICellsRange MethodsEquals MethodGetHashCode MethodToString MethodICellsRange PropertiesFirstColumn PropertyFirstRow PropertyLastColumn PropertyLastRow PropertyIColumn InterfaceIColumn MembersIColumn MethodsAutoFit MethodIColumn PropertiesHidden PropertyIsFormatted PropertyIsNotEmptyCells PropertyItem PropertyNumberFormat PropertyWidth PropertyIColumns InterfaceIColumns MembersIColumns MethodsCopyAndPaste MethodDelete MethodDelete Method (Int32)Delete Method (Int32, Int32)Insert MethodInsert Method (Int32)Insert Method (Int32, Int32)IColumns PropertiesFirstFormatedColumn PropertyItem PropertyLastFormatedColumn PropertyIDefinedName InterfaceIDefinedName MembersIDefinedName PropertiesComment PropertyIndex PropertyName PropertyRefersTo PropertyValue PropertyVisible PropertyIDefinedNameList InterfaceIDefinedNameList MembersIDefinedNameList MethodsAdd MethodIndexOf MethodRemoveAt MethodIDefinedNameList PropertiesCount PropertyItem PropertyItem Property (Int32)Item Property (String)IDocumentSummaryInformation InterfaceIDocumentSummaryInformation MembersIDocumentSummaryInformation PropertiesBytecount PropertyCategory PropertyCchwithspaces PropertyCodepage PropertyCompany PropertyContentstatus PropertyContenttype PropertyDocparts PropertyDocversion PropertyHeadingpair PropertyHiddencount PropertyHyperlinkschanged PropertyLanguage PropertyLinecount PropertyLinksdirty PropertyManager PropertyMmclipcount PropertyNotecount PropertyParacount PropertyPresformat PropertyScale PropertyShareddoc PropertySlidecount PropertyVersion PropertyIExtFormat InterfaceIExtFormat MembersIExtFormat PropertiesAlignmentHorizontal PropertyAlignmentVertical PropertyBottomBorderColor PropertyBottomBorderStyle PropertyCellFormat PropertyDiagonalBorderColor PropertyDiagonalBorderStyle PropertyFillPattern PropertyFillPatternBackColor PropertyFillPatternForeColor PropertyHiddenFormula PropertyIndent PropertyIsDiagonalDownLine PropertyIsDiagonalUpLine PropertyLeftBorderColor PropertyLeftBorderStyle PropertyLocked PropertyRightBorderColor PropertyRightBorderStyle PropertyRotation PropertyShrinkToFit PropertyTextDirection PropertyTopBorderColor PropertyTopBorderStyle PropertyWrap PropertyIFontFormat InterfaceIFontFormat MembersIFontFormat MethodsSetFontColorRGB MethodSetFontProperties MethodIFontFormat PropertiesFont PropertyFontColor PropertyFontColorIndex PropertyFontEscapement PropertyFontUnderline PropertyIHyperLink InterfaceIHyperLink MembersIHyperLink PropertiesAddress PropertyRange PropertyScreenTip PropertySubAddress PropertyTextToDisplay PropertyIHyperLinks InterfaceIHyperLinks MembersIHyperLinks MethodsAdd MethodAdd Method (HyperLink)Add Method (CellsRange, String, String, String, String)RemoveAt MethodIHyperLinks PropertiesCount PropertyItem PropertyIRange InterfaceIRange MembersIRange MethodsCalculate MethodCopyInto MethodCopyInto Method (String)CopyInto Method (Int32, Int32)IRange PropertiesAlignmentHorizontal PropertyAlignmentVertical PropertyBottomBorderColor PropertyBottomBorderStyle PropertyBottomRowIndex PropertyCellFormat PropertyDiagonalBorderColor PropertyDiagonalBorderStyle PropertyFillPattern PropertyFillPatternBackColor PropertyFillPatternForeColor PropertyFont PropertyFontColor PropertyFontEscapement PropertyFontUnderline PropertyFormula PropertyHiddenFormula PropertyIndent PropertyIsDiagonalDownLine PropertyIsDiagonalUpLine PropertyIsNotEmptyCells PropertyLeftBorderColor PropertyLeftBorderStyle PropertyLeftColumnIndex PropertyLocked PropertyNumberFormatString PropertyRightBorderColor PropertyRightBorderStyle PropertyRightColumnIndex PropertyRotation PropertyShrinkToFit PropertyTextDirection PropertyTopBorderColor PropertyTopBorderStyle PropertyTopRowIndex PropertyValue PropertyValueAsHTML PropertyValueDataTypeByNumberFormatString PropertyWrap PropertyIRow InterfaceIRow MembersIRow MethodsAutoFit MethodDeleteCell MethodInsertCell MethodIRow PropertiesColumnMax PropertyColumnMin PropertyHeight PropertyHidden PropertyIsFormatted PropertyIsNotEmptyCells PropertyItem PropertyNumberFormat PropertyUseStandardHeight PropertyIRows InterfaceIRows MembersIRows MethodsCopyAndPaste MethodDelete MethodDelete Method (Int32)Delete Method (Int32, Int32)Insert MethodInsert Method (Int32)Insert Method (Int32, Int32)IRows PropertiesFirstFormatedRow PropertyItem PropertyLastFormatedRow PropertyISearchOptions InterfaceISearchOptions MembersISearchOptions PropertiesCaseSensitiveSearch PropertyRegexSearch PropertySearchBackwards PropertySearchString PropertyISpreadsheet InterfaceISpreadsheet MembersISpreadsheet MethodsExportTo2DArray MethodExportTo2DArray MethodExportTo2DArray Method (Int32)ExportTo2DArray Method (String)ExportToDataSet MethodExportToDataSet MethodExportToDataSet Method (DataSet)ExportToDataTable MethodExportToDataTable MethodExportToDataTable Method (Int32)ExportToDataTable Method (String)ExportToList MethodExportToList Method (IList)ExportToList Method (IList, Int32)ExportToList Method (IList, String)GetAsBytesArray MethodGetAsBytesArrayCSV MethodGetAsBytesArrayHTML MethodGetAsBytesArrayHTML MethodGetAsBytesArrayHTML Method (Int32)GetAsBytesArrayTXT MethodGetAsBytesArrayXLS MethodGetAsBytesArrayXLSX MethodGetAsBytesArrayXML MethodImportFrom2DArray MethodImportFrom2DArray Method (String[,])ImportFrom2DArray Method (String[,], Int32)ImportFrom2DArray Method (String[,], String)ImportFromDataSet MethodImportFromDataTable MethodImportFromDataTable Method (DataTable)ImportFromDataTable Method (DataTable, Int32)ImportFromDataTable Method (DataTable, String)ImportFromList MethodImportFromList Method (IList)ImportFromList Method (IList, Int32)ImportFromList Method (IList, String)LoadFromFile MethodLoadFromFile Method (String)LoadFromFile Method (String, CacheType)LoadFromFile Method (String, String)LoadFromFile Method (String, CacheType, String)LoadFromFile Method (String, String, Encoding)LoadFromFile Method (String, CacheType, String, Encoding)LoadFromFile Method (String, CacheType, String, Encoding, String)LoadFromStream MethodLoadFromStream Method (Stream)LoadFromStream Method (Stream, CacheType)LoadFromStream Method (Stream, SpreadsheetFormatType)LoadFromStream Method (Stream, CacheType, String)LoadFromStream Method (Stream, SpreadsheetFormatType, CacheType)LoadFromStream Method (Stream, SpreadsheetFormatType, String, Encoding)LoadFromStream Method (Stream, SpreadsheetFormatType, CacheType, String, Encoding)LoadFromStream Method (Stream, SpreadsheetFormatType, CacheType, String, Encoding, String)SaveAs MethodSaveAs Method (String)SaveAs Method (String, SpreadsheetFormatType)SaveAsCSV MethodSaveAsCSV Method (String)SaveAsCSV Method (String, String)SaveAsHTML MethodSaveAsHTML Method (String)SaveAsHTML Method (String, Boolean)SaveAsPDF MethodSaveAsPDF Method (String)SaveAsPDF Method (String, Boolean)SaveAsTXT MethodSaveAsTXT Method (String)SaveAsTXT Method (String, String)SaveAsXLS MethodSaveAsXLSX MethodSaveAsXLSX Method (String)SaveAsXLSX Method (String, String)SaveAsXML MethodSaveToStream MethodSaveToStream Method (Stream)SaveToStream Method (Stream, SpreadsheetFormatType)SaveToStreamCSV MethodSaveToStreamCSV Method (Stream)SaveToStreamCSV Method (Stream, String)SaveToStreamHTML MethodSaveToStreamHTML Method (Stream)SaveToStreamHTML Method (Stream, Int32)SaveToStreamTXT MethodSaveToStreamTXT Method (Stream)SaveToStreamTXT Method (Stream, String)SaveToStreamXLS MethodSaveToStreamXLSX MethodSaveToStreamXLSX Method (Stream)SaveToStreamXLSX Method (Stream, String)SaveToStreamXML MethodWorksheet MethodISpreadsheet PropertiesOptions PropertySearchOptions PropertyWorkbook PropertyWorksheets PropertyISpreadsheetFont InterfaceISpreadsheetFont MembersISpreadsheetFont MethodsEquals MethodGetHashCode MethodISpreadsheetFont PropertiesBold PropertyCharacterSet PropertyEscapement PropertyFont PropertyFontColor PropertyFontName PropertyHeight PropertyItalic PropertyStruckOut PropertyUnderline PropertyISpreadsheetOptions InterfaceISpreadsheetOptions MembersISpreadsheetOptions MethodsSetExcel2003Limits MethodSetExcel2007Limits MethodSetOpenOffice3Limits MethodISpreadsheetOptions PropertiesMaxColumnCountAllowed PropertyMaxRowCountAllowed PropertyMaxStringLengthAllowedPerCell PropertyThrowExceptionsOnFormatIncompatibilities PropertyThrowExceptionsOnFormatLimits PropertyISummaryInformation InterfaceISummaryInformation MembersISummaryInformation PropertiesApplicationName PropertyAuthor PropertyCharCount PropertyCodepage PropertyComments PropertyCreateDateTime PropertyEditTime PropertyKeywords PropertyLastAuthor PropertyLastPrinted PropertyLastSavedDateTime PropertyPageCount PropertyRevisionNumber PropertySecurity PropertySubject PropertyTemplate PropertyTitle PropertyWordCount PropertyIViewOptions InterfaceIViewOptions MembersIViewOptions PropertiesActivePane PropertyFrozenNoSplit PropertyGridLineColor PropertyGridLinesColorEnabled PropertyPageBreakPreview PropertyPaged PropertyPanesFrozen PropertyRightToLeft PropertySelected PropertyShowFormulas PropertyShowGridLines PropertyShowGuts PropertyShowSheetHeaders PropertyShowZeroValues PropertySplitColumn PropertySplitHorizontal PropertySplitRow PropertySplitVertical PropertyZoom PropertyIVtHeadingPair InterfaceIVtHeadingPair MembersIVtHeadingPair PropertiesheaderParts PropertyheadingString PropertyIWorkbook InterfaceIWorkbook MembersIWorkbook MethodsCalculate MethodIWorkbook PropertiesAddInFunctionsNamesLocale PropertyAutoCalculation PropertyColors PropertyDefaultFont PropertyDocumentProperties PropertyExternalReferenceUpdate PropertyLocale PropertyNames PropertyRangeSelectionMethod PropertyWorksheets PropertyIWorksheet InterfaceIWorksheet MembersIWorksheet MethodsCalculate MethodCell MethodCell Method (String)Cell Method (Int32, Int32)Find MethodFind MethodFind Method (String, Boolean, Boolean, Boolean)FindNext MethodGetAsBytesArrayCSV MethodGetAsBytesArrayHTML MethodGetAsBytesArrayTXT MethodGetAsBytesArrayXML MethodProtect MethodProtect Method (String)Protect Method (String, EnhancedSheetProtection)Range MethodRange Method (String)Range Method (Int32, Int32, Int32, Int32)SaveAsCSV MethodSaveAsCSV Method (Stream)SaveAsCSV Method (String)SaveAsCSV Method (Stream, ConversionOptions)SaveAsCSV Method (Stream, String)SaveAsCSV Method (String, ConversionOptions)SaveAsCSV Method (String, String)SaveAsCSV Method (Stream, String, String)SaveAsCSV Method (String, String, String)SaveAsHTML MethodSaveAsHTML Method (Stream)SaveAsHTML Method (StreamWriter)SaveAsHTML Method (String)SaveAsPDF MethodSaveAsPDF Method (Stream)SaveAsPDF Method (String)SaveAsPDF Method (Stream, Boolean)SaveAsPDF Method (String, Boolean)SaveAsTXT MethodSaveAsTXT Method (Stream)SaveAsTXT Method (String)SaveAsTXT Method (Stream, ConversionOptions)SaveAsTXT Method (Stream, String)SaveAsTXT Method (String, ConversionOptions)SaveAsTXT Method (String, String)SaveAsTXT Method (Stream, String, String)SaveAsTXT Method (String, String, String)SaveAsXML MethodSaveAsXML Method (Stream)SaveAsXML Method (String)UnProtect MethodIWorksheet PropertiesActive PropertyBackgroundPicture PropertyColumns PropertyDefaultColumnWidth PropertyHyperlinks PropertyIsEmpty PropertyItem PropertyItem Property (String)Item Property (Int32, Int32)Name PropertyNotEmptyColumnMax PropertyNotEmptyColumnMin PropertyNotEmptyRowMax PropertyNotEmptyRowMin PropertyPageSetup PropertyPictures PropertyProtected PropertyProtectionOptions PropertyRows PropertyUsedRangeColumnMax PropertyUsedRangeColumnMin PropertyUsedRangeRowMax PropertyUsedRangeRowMin PropertyViewOptions PropertyVisible PropertyIWorksheets InterfaceIWorksheets MembersIWorksheets MethodsAdd MethodAdd MethodAdd Method (String)ByName MethodCopy MethodDelete MethodDelete Method (Int32)Delete Method (String)DeleteAll MethodIndexOf MethodInsert MethodMove MethodIWorksheets PropertiesCount PropertyItem PropertyItem Property (Int32)Item Property (String)Bytescout.Spreadsheet.Constants NamespaceAlignmentHorizontal EnumerationAlignmentVertical EnumerationBIFF_VERSION EnumerationBorderLineStyle EnumerationBorderWeight EnumerationCellType EnumerationDataType EnumerationEnhancedSheetProtection EnumerationFontEscapementType EnumerationFontUnderlineStyle EnumerationFORMULAERROR EnumerationLineStyle EnumerationNumberFormatType EnumerationPageOrder EnumerationPageOrientation EnumerationPaperSize EnumerationPatternStyle EnumerationPrintErrors EnumerationPrintLocation EnumerationReadingOrder EnumerationSHEETVISIBILITY EnumerationSortDataOption EnumerationSortOrder EnumerationSortOrientation EnumerationSpreadsheetFormatType EnumerationxlColorIndex StructurexlColorIndex MembersxlColorIndex FieldsAutomatic FieldNone FieldxlColorIndex MethodsXLSPallette ClassXLSPallette MembersXLSPallette ConstructorXLSPallette FieldsAqua FieldBlack FieldBlue FieldBlueViolet FieldBrown FieldCherry FieldCherry2 FieldCoral FieldCornFlower FieldDarkBlueGrey FieldDarkBlueGrey2 FieldDarkGreen FieldDarkSky FieldDarkTurquois FieldDarkViolet FieldEmerald FieldFuchsia FieldGold FieldGrass FieldGray FieldGreen FieldGrey40 FieldGrey80 FieldIndigo FieldIvory FieldLightBrown FieldLightOrange FieldLightTurquois FieldLightYellow FieldLilac FieldLime FieldMagenta FieldMaroon FieldNavy FieldOlive FieldOlive2 FieldOrange FieldPaleGreen FieldPaleSky FieldPastelSky FieldPurple FieldRed FieldRose FieldSilver FieldSky FieldTeal FieldWhite FieldYellow FieldXLSPallette MethodsColour MethodIndex MethodIndex Method (Color)Index Method (Color, Color[])Bytescout.Spreadsheet.Generic NamespaceDefinedNameList ClassDefinedNameList MembersDefinedNameList MethodsAdd MethodIndexOf MethodRemoveAt MethodDefinedNameList PropertiesCount PropertyItem PropertyItem Property (Int32)Item Property (String)IPictures InterfaceIPictures MembersIPictures MethodsAdd MethodAdd Method (Double, Double, String)Add Method (Int32, Int32, String)Add Method (String, Int32, Int32)Add Method (Int32, Int32, String, Int32, Int32)Add Method (String, Int32, Int32, Int32, Int32)AddAndFitInto MethodAddAndFitInto Method (Int32, Int32, Int32, Int32, String)AddAndFitInto Method (String, Double, Double, Double, Double)IPictures PropertiesCount PropertyItem PropertyPictures ClassPictures MembersPictures ConstructorPictures MethodsAdd MethodAdd Method (Double, Double, Image)Add Method (Double, Double, String)Add Method (Image, Int32, Int32)Add Method (Int32, Int32, Image)Add Method (Int32, Int32, String)Add Method (String, Int32, Int32)Add Method (Image, Int32, Int32, Int32, Int32)Add Method (Int32, Int32, Image, Int32, Int32)Add Method (Int32, Int32, String, Int32, Int32)Add Method (String, Int32, Int32, Int32, Int32)AddAndFitInto MethodAddAndFitInto Method (Image, Double, Double, Double, Double)AddAndFitInto Method (Int32, Int32, Int32, Int32, Image)AddAndFitInto Method (Int32, Int32, Int32, Int32, String)AddAndFitInto Method (String, Double, Double, Double, Double)GetEnumerator MethodPictures PropertiesCount PropertyItem PropertyBytescout.Spreadsheet.MSODrawing NamespaceFillFormat ClassFillFormat MembersFillFormat ConstructorFillFormat MethodsOneColorGradient MethodSolid MethodTwoColorGradient MethodFillFormat PropertiesBackColor PropertyForeColor PropertyGradientColorType PropertyGradientDegree PropertyGradientStyle PropertyGradientVariant PropertyTransparency PropertyVisible PropertyGradientColorType EnumerationGradientStyle EnumerationIFillFormat InterfaceIFillFormat MembersIFillFormat MethodsOneColorGradient MethodSolid MethodTwoColorGradient MethodIFillFormat PropertiesBackColor PropertyForeColor PropertyGradientColorType PropertyGradientDegree PropertyGradientStyle PropertyGradientVariant PropertyTransparency PropertyVisible PropertyILineFormat InterfaceILineFormat MembersILineFormat PropertiesDashStyle PropertyForeColor PropertyStyle PropertyVisible PropertyWeight PropertyIPictureShape InterfaceIPictureShape MembersIPictureShape MethodsScaleHeight MethodScaleWidth MethodIPictureShape PropertiesBrightness PropertyColorType PropertyContrast PropertyCropFromBottom PropertyCropFromLeft PropertyCropFromRight PropertyCropFromTop PropertyFill PropertyHeight PropertyLeft PropertyLeftColumn PropertyLine PropertyLockAspectRatio PropertyLocked PropertyName PropertyPicture PropertyPlacementType PropertyPrint PropertyRotation PropertyTop PropertyTopRow PropertyWidth PropertyLineDashStyle EnumerationLineFormat ClassLineFormat MembersLineFormat ConstructorLineFormat MethodsLineFormat PropertiesDashStyle PropertyForeColor PropertyStyle PropertyVisible PropertyWeight PropertyLineStyle EnumerationPatternType EnumerationPictureColorType EnumerationPictureShape ClassPictureShape MembersPictureShape ConstructorPictureShape MethodsScaleHeight MethodScaleWidth MethodPictureShape PropertiesBrightness PropertyColorType PropertyContrast PropertyCropFromBottom PropertyCropFromLeft PropertyCropFromRight PropertyCropFromTop PropertyFill PropertyHeight PropertyLeft PropertyLeftColumn PropertyLine PropertyLockAspectRatio PropertyLocked PropertyName PropertyPicture PropertyPlacementType PropertyPrint PropertyRotation PropertyTop PropertyTopRow PropertyWidth PropertyPlacement EnumerationPresetGradientType EnumerationPresetTexture EnumerationBytescout.Spreadsheet.Protection NamespaceEncryptionType EnumerationBytescout.Spreadsheet.Structures NamespaceCellsRange ClassCellsRange MembersCellsRange ConstructorCellsRange Constructor (String)CellsRange Constructor (Int32, Int32, Int32, Int32)CellsRange MethodsEquality OperatorEquals MethodGetHashCode MethodInequality OperatorToString MethodCellsRange PropertiesFirstColumn PropertyFirstRow PropertyLastColumn PropertyLastRow PropertyPaneTypes EnumerationConsole version (command line) optionsInstallation Tasks (.NET)Installation Tasks (ActiveX for VB6 and other)ActiveX version informationHistoryLicense AgreementHow To Buy