Uses of Package
bld.generator.report.excel.annotation

Packages that use bld.generator.report.excel.annotation

Package	Description
bld.generator.report.excel	In this package, each object is used to extend and implement personal objects used to build Excel file.
bld.generator.report.excel.annotation.impl	In this package, each class represents an annotation in the form of entities and are used to manage sheets with dynamic columns.
bld.generator.report.excel.data
bld.generator.report.excel.impl	In this package there are the main functions for generating Excel files.

Classes in bld.generator.report.excel.annotation used by bld.generator.report.excel

Class and Description
ExcelChart The Interface ExcelChart.

Classes in bld.generator.report.excel.annotation used by bld.generator.report.excel.annotation.impl

Class and Description
ExcelBorder The Interface ExcelBorder.
ExcelCellLayout The Interface ExcelCellLayout.
ExcelChart The Interface ExcelChart.
ExcelColumn The Interface ExcelColumn.
ExcelColumnWidth The Interface ExcelColumnWidth.
ExcelDate The Interface ExcelDate. ExcelDate is used to set the date format and it is set on fields of the classes: RowSheet SheetSummary
ExcelDropDown The Interface ExcelDropDown. Excel Drop Down is used to create a drop down list that references another table within the Excel file.
ExcelFont The Interface ExcelFont. ExcelFont defines the following properties: Font - to set font type Bold - to enable/disable bold Italic - to enable/disable italic Underline - to set underline type Size - to set font size It is a property of the following annotations: ExcelCellLayout ExcelHeaderCellLayout
ExcelFunction The Interface ExcelFunction. ExcelFunction is used to define the excel functions through: Function - to set function NameFunction - function identifier AnotherTable - it is enabled if the function is referred to another table Here are a series of examples: How to sum the records on a column? - You must concatenate column name with RowStart and RowEnd, example sum(${fieldNameRowStart}:${fieldNameRowEnd}), in the same way on a merged cell you can obtain the sum of a group of rows. The names of the two fields must be the same How to sum the records on a row? - Here You will use 2 different fields names and the function will be written as follows: sum(${fieldName1}:${fiedlName2}), indexes should not be written ExcelFunction is a property of the following annotations: ExcelFunctionMergeRow ExcelFunctionRow Below an example to calculate functions on rows and columns.
ExcelFunctionMergeRow The Interface ExcelFunctionMergeRow. ExcelFunctionMergeRow is used to configure the cell layout merged and define the excel function. It is composed from: ExcelCellsLayout - to define cell layout ExcelColumn - to define the header description and the position of column ExcelMergeRow - it is used to merge cells after checking the equality the reference field values ExcelFunction - to define the function ExcelColumnWidth - to set column width<7li> ExcelFunctionMergeRow is parameter of the annotation ExcelFunctionRows.
ExcelFunctionRow The Interface ExcelFunctionRow.
ExcelFunctionRows The Interface ExcelFunctionRows. ExcelFunctionRows is used to manage 2 lists: excelFunctions excelFunctionMerges It must be managed on RowSheet classes.
ExcelHeaderCellLayout The Interface ExcelHeaderCellLayout.
ExcelHeaderLayout The Interface ExcelHeaderLayout. ExcelHeaderLayout is used to configure the header of the table. It is composed by: RowHeight - to set row height ExcelHeaderCellLayout - to set the header cell style It must be to managed in SheetData classes.
ExcelMergeRow The Interface ExcelMergeRow. ExcelMergeRow works as follows: It is used to merge cells after checking the equality the reference field values. ReferenceField is empty only to the field identifier of the table and it must be in the first column. ExcelMergeRow is an annotation of the fields within RowSheet classes.
ExcelRgbColor The Interface ExcelRgbColor. ExcelRgbColor is used to set the color by the RGB color model.
ExcelRowHeight The Interface ExcelRowHeight. ExcelRowHeight is used to set the row height in centimeters. It is set on RowSheet classes or it added on field within of SheetSummary classes.

Classes in bld.generator.report.excel.annotation used by bld.generator.report.excel.data

Class and Description
ExcelCellLayout The Interface ExcelCellLayout.
ExcelColumn The Interface ExcelColumn.
ExcelColumnWidth The Interface ExcelColumnWidth.
ExcelDate The Interface ExcelDate. ExcelDate is used to set the date format and it is set on fields of the classes: RowSheet SheetSummary
ExcelDropDown The Interface ExcelDropDown. Excel Drop Down is used to create a drop down list that references another table within the Excel file.
ExcelFunction The Interface ExcelFunction. ExcelFunction is used to define the excel functions through: Function - to set function NameFunction - function identifier AnotherTable - it is enabled if the function is referred to another table Here are a series of examples: How to sum the records on a column? - You must concatenate column name with RowStart and RowEnd, example sum(${fieldNameRowStart}:${fieldNameRowEnd}), in the same way on a merged cell you can obtain the sum of a group of rows. The names of the two fields must be the same How to sum the records on a row? - Here You will use 2 different fields names and the function will be written as follows: sum(${fieldName1}:${fiedlName2}), indexes should not be written ExcelFunction is a property of the following annotations: ExcelFunctionMergeRow ExcelFunctionRow Below an example to calculate functions on rows and columns.
ExcelHeaderCellLayout The Interface ExcelHeaderCellLayout.
ExcelMergeRow The Interface ExcelMergeRow. ExcelMergeRow works as follows: It is used to merge cells after checking the equality the reference field values. ReferenceField is empty only to the field identifier of the table and it must be in the first column. ExcelMergeRow is an annotation of the fields within RowSheet classes.

Classes in bld.generator.report.excel.annotation used by bld.generator.report.excel.impl

Class and Description
ExcelBorder The Interface ExcelBorder.
ExcelCellLayout The Interface ExcelCellLayout.
ExcelDate The Interface ExcelDate. ExcelDate is used to set the date format and it is set on fields of the classes: RowSheet SheetSummary
ExcelFont The Interface ExcelFont. ExcelFont defines the following properties: Font - to set font type Bold - to enable/disable bold Italic - to enable/disable italic Underline - to set underline type Size - to set font size It is a property of the following annotations: ExcelCellLayout ExcelHeaderCellLayout
ExcelHeaderCellLayout The Interface ExcelHeaderCellLayout.