Bytescout.XLS for .NET

About Bytescout.XLSGetting StartedVisual Basic.NETVisual C# .NETASP.NETAdvanced ExamplesAdding columns into existing XLSAdding rows to existing XLSCells alignmentChanging data in existing XLSConverting XLS to CSVConverting XLS to TXTConverting XLS to XMLCreate a report with table in XLSCreate WorksheetsDate formatting for cellsExportToHTMLFonts available for cellsLine styles for cellsNumber formats for cellsRead CSV filesRead Dates from cellsRead ODS (Open Office Calc) filesRead XLSX (Office 2007) filesReading data from XLS into datasetReading value from merged cellsReading formula from a cellRemoving columns from existing XLSRemoving rows from existing XLSRename WorksheetUsing 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 colorWriting formula to cellSave to HTML customized reportSelect active worksheetSet ShrinkToFit for cellsGet cell format typeMerge cellsUnmerge cellsFont style for text in cellRich text formatting inside cellXLS to XML and XML to XLSXLS2PDFBytescout.XLS NamespaceCacheType EnumerationCell ClassCell MembersCell MethodsClear MethodCell PropertiesAlignmentHorizontal PropertyAlignmentVertical PropertyBottomBorderColor PropertyBottomBorderStyle PropertyDiagonalBorderColor PropertyDiagonalBorderStyle PropertyFillPattern PropertyFillPatternBackColor PropertyFillPatternForeColor PropertyFont PropertyFontColor PropertyFontColorIndex PropertyFontEscapement PropertyFontUnderline PropertyFormat PropertyFormula PropertyGetFormatType PropertyHiddenFormula PropertyIndent PropertyIsDiagonalDownLine PropertyIsDiagonalUpLine PropertyLeftBorderColor PropertyLeftBorderStyle PropertyLocked PropertyMerged PropertyMergedWith PropertyMergedWithCell PropertyNumberFormat PropertyRightBorderColor PropertyRightBorderStyle PropertyRotation PropertyShrinkToFit PropertyTextDirection PropertyTopBorderColor PropertyTopBorderStyle PropertyType PropertyValue PropertyValueAsDateTime PropertyValueFormatted PropertyWrap PropertyCellFormat ClassCellFormat MembersCellFormat PropertiesAlignmentHorizontal PropertyAlignmentVertical PropertyBottomBorderColor PropertyBottomBorderStyle PropertyDiagonalBorderColor PropertyDiagonalBorderStyle PropertyFillPattern PropertyFillPatternBackColor PropertyFillPatternForeColor PropertyHiddenFormula PropertyIndent PropertyIsDiagonalDownLine PropertyIsDiagonalUpLine PropertyLeftBorderColor PropertyLeftBorderStyle PropertyLockedCell PropertyMerge PropertyRightBorderColor PropertyRightBorderStyle PropertyRotation PropertyShrinkToFit PropertyTextDirection PropertyTopBorderColor PropertyTopBorderStyle PropertyWrap PropertyColumn ClassColumn MembersColumn Fieldsmax Fieldmin FieldColumn PropertiesAlignmentHorizontal PropertyAlignmentVertical PropertyBottomBorderColor PropertyBottomBorderStyle PropertyDiagonalBorderColor PropertyDiagonalBorderStyle PropertyFillPattern PropertyFillPatternBackColor PropertyFillPatternForeColor PropertyFont PropertyFontColor PropertyFontUnderline PropertyFormat PropertyHiddenFormula PropertyIndent PropertyIsDiagonalDownLine PropertyIsDiagonalUpLine PropertyItem PropertyLeftBorderColor PropertyLeftBorderStyle PropertyLocked PropertyNumberFormat PropertyRightBorderColor PropertyRightBorderStyle PropertyRotation PropertyShrinkToFit PropertyTextDirection PropertyTopBorderColor PropertyTopBorderStyle PropertyWidth PropertyWrap PropertyColumns ClassColumns MembersColumns MethodsDelete MethodDelete Method (Int32)Delete Method (Int32, Int32)Insert MethodInsert Method (Int32)Insert Method (Int32, Int32)Columns PropertiesItem PropertyFormulaReferenceException ClassFormulaReferenceException MembersFormulaReferenceException ConstructorFormulaReferenceException ConstructorFormulaReferenceException Constructor (String)FormulaReferenceException Constructor (SerializationInfo, StreamingContext)FormulaReferenceException Constructor (String, Exception)HTMLTemplate ClassHTMLTemplate MembersHTMLTemplate ConstructorHTMLTemplate MethodsSaveAsHTML MethodSaveAsHTML Method (Worksheet, Stream)SaveAsHTML Method (Worksheet, String)SaveHTML MethodHTMLTemplate PropertiesCellHeader PropertyTableHeader PropertyOpenXMLParserException ClassOpenXMLParserException MembersOpenXMLParserException ConstructorOpenXMLParserException ConstructorOpenXMLParserException Constructor (String)OpenXMLParserException Constructor (SerializationInfo, StreamingContext)OpenXMLParserException Constructor (String, Exception)Range ClassRange MembersRange MethodsMerge MethodUnMerge MethodRange PropertiesAlignmentHorizontal PropertyAlignmentVertical PropertyBottomBorderColor PropertyBottomBorderStyle PropertyDiagonalBorderColor PropertyDiagonalBorderStyle PropertyFillPattern PropertyFillPatternBackColor PropertyFillPatternForeColor PropertyFont PropertyFontColor PropertyFontColorIndex PropertyFontEscapement PropertyFontUnderline PropertyFormat PropertyFormula PropertyHiddenFormula PropertyIndent PropertyInnerBorderColor PropertyInnerBorderStyle PropertyIsDiagonalDownLine PropertyIsDiagonalUpLine PropertyLeftBorderColor PropertyLeftBorderStyle PropertyLocked PropertyNumberFormat PropertyOuterBorderColor PropertyOuterBorderStyle PropertyRightBorderColor PropertyRightBorderStyle PropertyRotation PropertyShrinkToFit PropertyTextDirection PropertyTopBorderColor PropertyTopBorderStyle PropertyType PropertyValue PropertyValueFormatted PropertyWrap PropertyRow ClassRow MembersRow Fieldsmax Fieldmin FieldRow MethodsDeleteCell MethodInsertCell MethodRow PropertiesAlignmentHorizontal PropertyAlignmentVertical PropertyBottomBorderColor PropertyBottomBorderStyle PropertycolMax PropertycolMin PropertyDiagonalBorderColor PropertyDiagonalBorderStyle PropertyFillPattern PropertyFillPatternBackColor PropertyFillPatternForeColor PropertyFont PropertyFontColor PropertyFontUnderline PropertyFormat PropertyHeight PropertyHiddenFormula PropertyIndent PropertyIsDiagonalDownLine PropertyIsDiagonalUpLine PropertyItem PropertyLeftBorderColor PropertyLeftBorderStyle PropertyLocked PropertyNumberFormat PropertyRightBorderColor PropertyRightBorderStyle PropertyRotation PropertyShrinkToFit PropertyTextDirection PropertyTopBorderColor PropertyTopBorderStyle PropertyWrap PropertyRows ClassRows MembersRows MethodsDelete MethodDelete Method (Int32)Delete Method (Int32, Int32)Insert MethodInsert Method (Int32)Insert Method (Int32, Int32)Rows PropertiesCount PropertyItem PropertyWorksheet ClassWorksheet MembersWorksheet ConstructorWorksheet FieldsViewOptions FieldWorksheet MethodsCell MethodCell Method (String)Cell Method (Int32, Int32)Range MethodRange Method (String)Range Method (Int32, Int32, Int32, Int32)SaveAsCSV MethodSaveAsCSV Method (Stream)SaveAsCSV Method (String)SaveAsHTML MethodSaveAsHTML Method (Stream)SaveAsHTML Method (String)SaveAsTXT MethodSaveAsTXT Method (Stream)SaveAsTXT Method (String)SaveAsXML MethodSaveAsXML Method (Stream)SaveAsXML Method (String)Worksheet PropertiesActive PropertyColumns PropertyDefaultColumnWidth PropertyFirstColumn PropertyFirstRow PropertyItem PropertyItem Property (String)Item Property (Int32, Int32)LastColumn PropertyLastRow PropertyName PropertyRows PropertyWorkSheets ClassWorkSheets MembersWorkSheets ConstructorWorkSheets MethodsAdd MethodAdd MethodAdd Method (String)ByName MethodDelete MethodDelete Method (Int32)Delete Method (String)DeleteAll MethodIndexOf MethodInsert MethodMove MethodWorkSheets PropertiesCount PropertyItem PropertyItem Property (Int32)Item Property (String)XLSDocEngine ClassXLSDocEngine MembersXLSDocEngine ConstructorXLSDocument ClassXLSDocument MembersXLSDocument ConstructorXLSDocument ConstructorXLSDocument Constructor (Stream)XLSDocument Constructor (String)XLSDocument Constructor (Stream, CacheType)XLSDocument Constructor (Stream, StreamType)XLSDocument Constructor (String, CacheType)XLSDocument Constructor (Stream, StreamType, CacheType)XLSDocument MethodsClose MethodDispose MethodFinalize MethodSaveAs MethodSaveToStream MethodWorksheet MethodXLSDocument PropertiesCache PropertyWorkBook PropertyXLSException ClassXLSException MembersXLSException ConstructorXLSException ConstructorXLSException Constructor (String)XLSException Constructor (SerializationInfo, StreamingContext)XLSException Constructor (String, Exception)XLSFormulaException ClassXLSFormulaException MembersXLSFormulaException ConstructorXLSFormulaException ConstructorXLSFormulaException Constructor (String)XLSFormulaException Constructor (SerializationInfo, StreamingContext)XLSFormulaException Constructor (String, Exception)XLSReferenceException ClassXLSReferenceException MembersXLSReferenceException ConstructorXLSReferenceException ConstructorXLSReferenceException Constructor (String)XLSReferenceException Constructor (SerializationInfo, StreamingContext)XLSReferenceException Constructor (String, Exception)XLSWorkBook ClassXLSWorkBook MembersXLSWorkBook ConstructorXLSWorkBook PropertiesBIFF8 PropertyDefaultFont PropertyWorksheets PropertyBytescout.XLS.BaseClasses NamespaceViewOptions StructureViewOptions MembersViewOptions PropertiesShowGridLines PropertyShowSheetHeaders PropertyShowZeroValues PropertyBytescout.XLS.Constants NamespaceAlignmentHorizontal EnumerationAlignmentVertical EnumerationBIFF_VERSION EnumerationCellType EnumerationFontEscapementType EnumerationFontUnderlineStyle EnumerationFormatType EnumerationFORMULAERROR EnumerationLineStyle EnumerationPatternStyle EnumerationReadingOrder EnumerationStreamType EnumerationXLSPallette ClassXLSPallette MembersXLSPallette 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 MethodInstallation TasksLicense AgreementHow To Buy