- addAutoShape(double, double, double, double, short) - Method in class com.smartxls.WorkBook
-
Creates and adds a AutoShape to the active worksheet.
- addCalcField(String, String) - Method in class com.smartxls.BookPivotRange
-
add a calculated item to the data area
- addCalcItem(String, String) - Method in class com.smartxls.BookPivotField
-
add a calculated item to the field list items
- addCalculatedColumn(String, String) - Method in interface com.smartxls.Table
-
- addChart(double, double, double, double) - Method in class com.smartxls.WorkBook
-
Creates and adds a chart to the active worksheet.
- addChartSheet(int) - Method in class com.smartxls.WorkBook
-
Creates and adds a chart to the book and make it a chart sheet.
- addColPageBreak(int) - Method in class com.smartxls.WorkBook
-
Adds a vertical page break to the left edge of the specified column.
- addComment(int, int, String, String) - Method in class com.smartxls.WorkBook
-
add a comment to the cell in the current sheet
- addField(BookPivotField) - Method in class com.smartxls.BookPivotArea
-
- addField(String, BookPivotArea) - Method in class com.smartxls.BookPivotRange
-
Returns the Field with the specified name.
- addFormControl(double, double, double, double, int) - Method in class com.smartxls.WorkBook
-
Creates and adds a FormControl to the active worksheet.
- addHyperlink(int, int, int, int, String, int, String) - Method in class com.smartxls.WorkBook
-
Adds a hyperlink to the range in the current worksheet.
- addPicture(double, double, double, double, String) - Method in class com.smartxls.WorkBook
-
Adds a picture object to the worksheet
- addPicture(double, double, double, double, byte[]) - Method in class com.smartxls.WorkBook
-
Adds a picture object to the worksheet
- addPivotRange(int, int, int, int, int, int, int, int) - Method in class com.smartxls.WorkBook
-
create new pivot table range with source link range and dest location
- addPivotRange(com.smartxls.data.SXQuery, int, int, int) - Method in class com.smartxls.WorkBook
-
create new pivot table range with external data source and dest location
- addPivotRange(String, String) - Method in class com.smartxls.WorkBook
-
create new pivot table range with external data source and dest location
- addRowPageBreak(int) - Method in class com.smartxls.WorkBook
-
Adds a horizontal page break adjacent to the top edge of the specified row.
- addSeries() - Method in class com.smartxls.ChartShape
-
Adds a series to the chart.
- addTable(String, int, int, int, int, TableBuiltInStyles) - Method in class com.smartxls.WorkBook
-
add the table object to current selected sheet
- addTrendLine(int) - Method in class com.smartxls.ChartShape
-
- Area - Static variable in class com.smartxls.ChartShape
-
- areaAll - Static variable in class com.smartxls.BookPivotRange
-
- areaBlankColumnHeader - Static variable in class com.smartxls.BookPivotRange
-
- areaData - Static variable in class com.smartxls.BookPivotRange
-
- areaHeaders - Static variable in class com.smartxls.BookPivotRange
-
- areaTopLeft - Static variable in class com.smartxls.BookPivotRange
-
- autoFilter() - Method in class com.smartxls.WorkBook
-
Creates an AutoFilter using this range to identify the bounds.
- AutoShape - Class in com.smartxls
-
This class represents a drawing shape object.