A B C D E F G H I J K L M N O P Q R S T U V W X Y Z _

A

B

C

compareTwoCells(Cell, Cell, boolean) - Method in ExcelKeywords

Compare two excel cells

compareTwoExcels(Workbook, Workbook, boolean) - Method in ExcelKeywords

Compare value of two excel workbooks

compareTwoRows(Row, Row, boolean) - Method in ExcelKeywords

Compare two excel rows

compareTwoSheets(Sheet, Sheet, boolean) - Method in ExcelKeywords

Compare two excel sheets

createExcelFile(String) - Method in ExcelKeywords

Create a new excel file

createExcelSheet(Workbook, String) - Method in ExcelKeywords

Add a new sheet to workbook

createExcelSheets(Workbook, List<String>) - Method in ExcelKeywords

Add multiple sheets to workbook

createWorkbook(String) - Method in ExcelKeywords

Create new workbook

D

E

ExcelKeywords - Class in com.kms.katalon.keyword.excel

F

G

getCellByAddress(Sheet, String) - Method in ExcelKeywords

Get cell by address

getCellByIndex(Sheet, int, int) - Method in ExcelKeywords

Get cell by index

getCellFormula(Cell) - Method in ExcelKeywords

Get cell formula

getCellIndexByAddress(Sheet, String) - Method in ExcelKeywords

Get cell position by address

getCellValue(Cell) - Method in ExcelKeywords

Read data from a single cell

getCellValueByAddress(Sheet, String) - Method in ExcelKeywords

Get cell value by address

getCellValueByIndex(Sheet, int, int) - Method in ExcelKeywords

Get cell value by index

getCellValueByRangeAddress(Sheet, String, String) - Method in ExcelKeywords

Get cell values by addresses

getCellValuesByRangeIndexes(Sheet, int, int, int, int) - Method in ExcelKeywords

Get cell values by indexes

getColumnsByIndex(Sheet, List<Integer>) - Method in ExcelKeywords

Get map of columns data

getDataRows(Sheet, List<Integer>) - Method in ExcelKeywords

Get data rows from a list of row indexes

getExcelSheet(Workbook, String) - Method in ExcelKeywords

Get an Excel sheet from an opening workbook

getExcelSheetByName(String, String) - Method in ExcelKeywords

Get an Excel sheet by name

getMapOfKeyValueRows(Sheet, int, int) - Method in ExcelKeywords

Get a map of {{key1:value1},...

getRowIndexByCellContent(Sheet, String, int) - Method in ExcelKeywords

Get row index by cell content

getSheetNames(Workbook) - Method in ExcelKeywords

Get name of sheets in workbook

getTableContent(Sheet, int, int) - Method in ExcelKeywords

Get the excel data to a list of rows

getWorkbook(String) - Method in ExcelKeywords

Get workbook from existing excel file

H

I

J

K

L

locateCell(Sheet, def) - Method in ExcelKeywords

Locate the first position of the cell based on the cell content

M

N

O

P

Q

R

S

saveWorkbook(String, Workbook) - Method in ExcelKeywords

Save workbook into file

setValueToCell(Cell, def) - Method in ExcelKeywords

Set value to cell

setValueToCellByAddress(Sheet, String, def) - Method in ExcelKeywords

Set value to cell by cell Address

setValueToCellByAddresses(Sheet, Map) - Method in ExcelKeywords

Set multiple values to multiple cells with cell addresses

setValueToCellByIndex(Sheet, int, int, def) - Method in ExcelKeywords

Set value to cell by cell index

T

U

V

W

X

Y

Z

_