- Radar - Static variable in class com.smartxls.ChartShape
-
- RangeArea - Class in com.smartxls
-
represent one cell or range
- RangeArea(int, int, int, int) - Constructor for class com.smartxls.RangeArea
-
- RangeStyle - Class in com.smartxls
-
this class present creating and returning information about cell formats.
- read(InputStream) - Method in class com.smartxls.WorkBook
-
Reads workbook from the specified input stream.
- read(InputStream, String) - Method in class com.smartxls.WorkBook
-
Reads workbook from the specified input stream.
- read(String) - Method in class com.smartxls.WorkBook
-
Reads workbook from the specified file.
- read(String, String) - Method in class com.smartxls.WorkBook
-
Reads workbook from the specified file.
- readCSV(String) - Method in class com.smartxls.WorkBook
-
load csv content from csv file
- readXLSB(String) - Method in class com.smartxls.WorkBook
-
Reads workbook from xlsb file.
- readXLSB(InputStream) - Method in class com.smartxls.WorkBook
-
Reads workbook from Excel2007+ xlsb file inputstream.
- readXLSB(String, String) - Method in class com.smartxls.WorkBook
-
Reads workbook from xlsb file.
- readXLSB(InputStream, String) - Method in class com.smartxls.WorkBook
-
reads workbook with xlsb format
- readXLSX(String) - Method in class com.smartxls.WorkBook
-
Reads a worksheet or workbook from excel xlsx file.
- readXLSX(InputStream) - Method in class com.smartxls.WorkBook
-
Reads a worksheet or workbook from Excel2003 spreadsheetxml inputstream.
- readXLSX(String, String) - Method in class com.smartxls.WorkBook
-
reads workbook
- readXLSX(InputStream, String) - Method in class com.smartxls.WorkBook
-
reads workbook with xlsx format
- readXML(InputStream) - Method in class com.smartxls.WorkBook
-
Reads a worksheet or workbook from excel xlsx inputstream.
- recalc() - Method in class com.smartxls.WorkBook
-
Recalculate the workbook
- Rectangle - Static variable in class com.smartxls.AutoShape
-
- refresh() - Method in class com.smartxls.BookPivotRange
-
refresh the selected pivot range
- refreshRange() - Method in class com.smartxls.BookPivotRange
-
refresh the pivot table from the data source
- refreshRange(BookPivotRange) - Method in class com.smartxls.BookPivotRangeModel
-
- releaseLock() - Method in class com.smartxls.WorkBook
-
Release the lock previously acquired with getLock
- removeChart(int) - Method in class com.smartxls.WorkBook
-
remove specified index chart from current sheet
- removeColPageBreak(int) - Method in class com.smartxls.WorkBook
-
Removes a vertical page break adjacent to the left edge of the specified column.
- removeComment(CommentShape) - Method in class com.smartxls.WorkBook
-
remove the specified comment from the current sheet
- removeFormControl(int, int) - Method in class com.smartxls.WorkBook
-
remove the specified index formcontrol from the current sheet
- removeHyperlink(HyperLink) - Method in class com.smartxls.WorkBook
-
remove the specified hyperlink object
- removeLegendItem(int) - Method in class com.smartxls.ChartShape
-
remove the legend item
- removePicture(int) - Method in class com.smartxls.WorkBook
-
remove specified index image from current sheet
- removeRowPageBreak(int) - Method in class com.smartxls.WorkBook
-
Removes a horizontal page break adjacent to the current cell.
- removeSeries(int) - Method in class com.smartxls.ChartShape
-
Removes the specified series.
- replace(String, String) - Method in class com.smartxls.WorkBook
-
find all the range cells with specified search string in current selected sheet,replace with the other string.
- replace(int, int, int, int, String, String) - Method in class com.smartxls.WorkBook
-
- replace(String, String, boolean) - Method in class com.smartxls.WorkBook
-
find all the range cells with specified search string in current selected sheet,replace with the other string.
- resetFormat() - Method in class com.smartxls.RangeStyle
-
reset the format settings,this will clear all setting had been set before
- resetRowInfo(int, int) - Method in class com.smartxls.WorkBook
-
reset the row info to default
- row - Static variable in class com.smartxls.BookPivotRange
-