ExcelBuilder ClassWorkbook:
XLWorkbookpublicClosedXML workbook instance.Worksheets:
Worksheet[]publicWorksheet instances associated with the ExcelBuilder.ExcelBuilder(params Worksheet[] worksheets)
publicExcelBuilder class. It creates a new XLWorkbook, sets the provided Worksheets, and initializes components by adding worksheets to the workbook.Datasets(params ExcelTable[] tables)
public staticIExcelBuilderExcelBuilder instance with one worksheet named "data" and specified Excel tables.Datasets(string workSheetName, params ExcelTable[] tables)
public staticIExcelBuilderExcelBuilder instance with one worksheet and specified name, along with Excel tables.Datasets(params Worksheet[] worksheets)
public staticIExcelBuilderExcelBuilder instance with specified worksheets.Build()
publicIExcelExtractorpublicExcelBuilder instance and associated resources.SaveAsFile(string fileName)
publicIDisposableGetStream()
publicMemoryStreamHere is the breakdown for the Worksheet class, starting with the constructor, followed by properties, and then methods:
Accessibility: public
Description: Initializes a new instance of the Worksheet class with the specified name and associated Excel tables.
ShowGridLines Property:
boolpublicfalse.Name Property:
stringpublicTables Property:
IEnumerable<ExcelTable>publicColumnsWidth Property:
List<double>publicExcelTable
Accessibility: public
Description: Initializes a new instance of the ExcelTable class. It creates new lists for columns and rows.
AlignTableEnd Property:
boolpublicEmptyRowsBeforePresentation Property:
intpublicColumns Property:
List<ExcelColumn>publicExcelColumn associated with the table.Rows Property:
List<ExcelRow>publicExcelRow instances associated with the table.MaxCellsCount Property:
intpublicStartColumnNumber Property:
intpublicLastColumnNumber Property:
intpublicStartingRowNumber Property:
intpublicLastRowNumber Property:
intpublicLinkedTable Property:
ExcelTablepublicGetColumn Method:
publicExcelColumn with the specified column name or actual name.GetColumn Method:
publicExcelColumn with the specified column number.Link Method:
publicExcelTable.ExcelRow Class:Default Constructor:
publicExcelRow class with an empty list of cells and the default row style.Constructor with Cell Values:
publicExcelRow class with specified cell values. Calls the default constructor internally.Constructor with RowStyle and Cell Values:
publicExcelRow class with a specified row style and cell values. Calls the default constructor internally.Constructor with RowStyle:
publicExcelRow class with a specified row style. Calls the default constructor internally.Cells:
List<ExcelCell>publicExcelCell instances associated with the row.RowStyle:
RowStylepublicRowStyle for the row.SpanRowToMaxColumns:
boolpublicIsFrozen:
boolpublicRowNumber:
intinternalSpanToMaxRowCells:
publicSpanRowToMaxColumns property to true.Freeze:
publicNow, let's proceed to the ExcelColumn class.
ExcelColumn Class:
Constructor with ColumnName and ActualColumnName:
publicExcelColumn class with the specified column name, actual column name, and the default column style.Constructor with ColumnName, ActualColumnName, and ColumnStyle:
publicExcelColumn class with the specified column name, actual column name, and column style.ColumnName:
stringpublicActualName:
stringpublicColumnStyle:
ColumnStylepublicColumnStyle for the column.ColumnNumber:
intinternalSpannedLastColumnNumber:
int
internalExcelStyle Class:Default Constructor:
publicExcelStyle class.Constructor with AllowCellsToBeBordered:
publicExcelStyle class with the specified option to allow cells to be bordered.FontBold:
bool?publicAlignmentHorizontal:
XLAlignmentHorizontalValues?publicAlignmentVertical:
XLAlignmentVerticalValues?publicBackroundColor:
XLColor?publicFontColor:
XLColor?publicFontSize:
doublepublicTopBorder:
XLBorderStyleValues?publicBottomBorder:
XLBorderStyleValues?publicLeftBorder:
XLBorderStyleValues?publicRightBorder:
XLBorderStyleValues?publicAddCellsToSpan:
boolpublicAllowCellsToBeBordered:
bool?publicpublic virtualIXLStyle with the style properties.ColumnStyle Class:publicColumnStyle class.intpublicCellStyle Class:publicCellStyle class with the specified option to allow cells to be bordered.Colspan:
intpublic virtualRowspan:
intpublic virtualIsWrapped:
boolpublicpublic overrideIXLStyle with the style properties, including wrap text.RowStyle Class:publicRowStyle class with the specified option to allow cells to be bordered.doublepublicExcelCell Class:Default Constructor:
publicExcelCell class with the default cell style and an empty rich text.Constructor with CellStyle:
publicExcelCell class with the specified cell style.Constructor with Value:
publicExcelCell class with the specified cell value.Constructor with RichText:
publicExcelCell class with the specified rich text.Constructor with RichText and CellStyle:
publicExcelCell class with the specified rich text and cell style.Constructor with Value and CellStyle:
publicExcelCell class with the specified cell value and cell style.CellStyle:
CellStylepublicCellStyle for the cell.Value:
stringpublicCellNumber:
intinternalRichText:
RichTextpublicRichTextValue Class:Bold:
boolpublicFontColor:
XLColor?publicItalic:
boolpublicStrikeThrough:
boolpublicValue:
stringpublicUpdateStyleTo:
publicIXLRichString with the properties of the RichTextValue.RichText Class:publicRichText class with an empty list of RichTextValue instances.boolpublicAdd:
publicRichTextValue to the list.AddALine:
publicRichTextValue in the list.GetValues:
publicRichTextValue instances.This concludes the breakdown for the ExcelCell, RichTextValue, and RichText classes. Let me know if you'd like to proceed with another class.
ExcelCollectionEx Class:AddCell Method (1):
public staticExcelCell with the specified value to the collection.AddCell Method (2):
public staticExcelCell with the specified value and ExcelTable.CellStyle to the collection. If AddCellsToSpan is true in the provided cellStyle, additional cells are added to the collection to match the colspan.AddCell Method (3):
public staticExcelCell with the specified value and ExcelTable.CellStyle to the ExcelRow collection. If AddCellsToSpan is true in the provided cellStyle, additional cells are added to the row to match the colspan.Values Method:
public staticExcelRow by extracting values from each ExcelCell.AddColumn Method:
internal staticExcelColumn to the collection with the specified column name, actual column name, and ExcelTable.ColumnStyle.AddCell Method (4):
public staticExcelCell to the ExcelRow collection.Add Method (1):
public staticExcelRow to the collection with the specified cell values.Add Method (2):
public staticExcelRow to the collection. It is intended for representing an empty row.Add Method (3):
public staticExcelRow to the collection with the specified row style and cell values.Add Method (4):
public staticExcelRow to the collection with the specified ExcelTable.CellStyle and cell values.Add Method (5):
public staticExcelRow to the collection with the specified ExcelTable.RowStyle, ExcelTable.CellStyle, and cell values.Add Method (6):
public staticExcelCell to the ExcelRow collection.Add Method (7):
public staticExcelCell to the ExcelRow collection with the specified ExcelTable.RowStyle.AddRange Method (1):
public staticExcelTable.ExcelCell to the collection with the specified ExcelTable.CellStyle and cell values.AddRange Method (2):
public staticExcelCell to the ExcelRow collection.AddRange Method (3):
public staticExcelCell to the ExcelRow collection with the specified ExcelTable.RowStyle.