Unlock 30% off on Manual Testing Annual Plans this Holiday Season.

Copied to Clipboard!

How to use fetchSheet method of com.paypal.selion.platform.dataprovider.impl.ExcelReader class

Best SeLion code snippet using com.paypal.selion.platform.dataprovider.impl.ExcelReader.fetchSheet

Source:ExcelReader.java

...86     * @return rows that are read.87     */88    public List<Row> getAllExcelRows(String sheetName, boolean heading) {89        logger.entering(new Object[] { sheetName, heading });90        Sheet sheet = fetchSheet(sheetName);91        int numRows = sheet.getPhysicalNumberOfRows();92        List<Row> rows = new ArrayList<Row>();93        int currentRow = 1;94        if (heading) {95            currentRow = 0;96        }97        int rowCount = 1;98        while (currentRow <= numRows) {99            Row row = sheet.getRow(currentRow);100            if (row != null) {101                Cell cell = row.getCell(0);102                if (cell != null) {103                    // Did the user mark the current row to be excluded by adding a # ?104                    if (!cell.toString().contains("#")) {105                        rows.add(row);106                    }107                    rowCount = rowCount + 1;108                }109            }110            currentRow = currentRow + 1;111        }112        logger.exiting(rows);113        return rows;114    }115    /**116     * A utility method, which returns {@link Sheet} for a given sheet name.117     * 118     * @param sheetName - A string that represents a valid sheet name.119     * @return - An object of type {@link Sheet}120     */121    protected Sheet fetchSheet(String sheetName) {122        logger.entering(sheetName);123        Sheet sheet = workBook.getSheet(sheetName);124        if (sheet == null) {125            IllegalArgumentException e = new IllegalArgumentException("Sheet '" + sheetName + "' is not found.");126            throw e;127        }128        logger.exiting(sheet);129        return sheet;130    }131    /**132     * A Utility method to find if a sheet exists in the workbook133     * 134     * @param sheetName - A String that represents the Sheet name135     * @return true if the sheet exists, false otherwise136     */137    public boolean sheetExists(String sheetName) {138        return (workBook.getSheet(sheetName) != null);139    }140    /**141     * Using the specified rowIndex to search for the row from the specified Excel sheet, then return the row contents142     * in a list of string format.143     * 144     * @param rowIndex145     *            - The row number from the excel sheet that is to be read. For e.g., if you wanted to read the 2nd row146     *            (which is where your data exists) in your excel sheet, the value for index would be 1. <b>This method147     *            assumes that your excel sheet would have a header which it would EXCLUDE.</b> When specifying index148     *            value always remember to ignore the header, since this method will look for a particular row ignoring149     *            the header row.150     * @param size151     *            - The number of columns to read, including empty and blank column.152     * @return List<String> String array contains the read data.153     */154    public List<String> getRowContents(String sheetName, int rowIndex, int size) {155        logger.entering(new Object[] { sheetName, rowIndex, size });156        Sheet sheet = fetchSheet(sheetName);157        int actualExcelRow = rowIndex - 1;158        Row row = sheet.getRow(actualExcelRow);159        List<String> rowData = getRowContents(row, size);160        logger.exiting(rowData);161        return rowData;162    }163    164    /**165     * Fetches the header row contents of the excel sheet. The first row in the excel sheet is considered to be the166     * header row167     * 168     * @param sheetName169     *            The excel sheet name where header data is to be fetched170     * @param size171     *            The number of columns to read, including empty and blank columns.172     * @return the header row data173     */174    public List<String> getHeaderRowContents(String sheetName, int size) {175        logger.entering(new Object[]{sheetName, size});176        Sheet sheet = fetchSheet(sheetName);177        int actualExcelRow = 0;178        Row row = sheet.getRow(actualExcelRow);179        List<String> rowData = getRowContents(row, size);180        logger.exiting(rowData);181        return rowData;182    }183    /**184     * Return the row contents of the specified row in a list of string format.185     * 186     * @param size - The number of columns to read, including empty and blank column.187     * @return List<String> String array contains the read data.188     */189    public List<String> getRowContents(Row row, int size) {190        logger.entering(new Object[] { row, size });191        List<String> rowData = new ArrayList<String>();192        if (row != null) {193            for (int i = 1; i <= size; i++) {194                String data = null;195                if (row.getCell(i) != null) {196                    data = row.getCell(i).toString();197                }198                rowData.add(data);199            }200        }201        logger.exiting(rowData);202        return rowData;203    }204    /**205     * Search for the input key from the specified sheet name and return the index position of the row that contained206     * the key207     * 208     * @param sheetName209     *            - A String that represents the Sheet name from which data is to be read210     * @param key211     *            - A String that represents the key for the row for which search is being done.212     * @return - An int that represents the row number for which the key matches. Returns -1 if the search did not yield213     *         any results.214     * 215     */216    public int getRowIndex(String sheetName, String key) {217        logger.entering(new Object[] { sheetName, key });218        int index = -1;219        Sheet sheet = fetchSheet(sheetName);220        int rowCount = sheet.getPhysicalNumberOfRows();221        for (int i = 0; i < rowCount; i++) {222            Row row = sheet.getRow(i);223            if (row == null) {224                continue;225            }226            String cellValue = row.getCell(0).toString();227            if ((key.compareTo(cellValue) == 0) && (!cellValue.contains("#"))) {228                index = i;229                break;230            }231        }232        logger.exiting(index);233        return index;234    }235    /**236     *237     * @param sheetName -  A String that represents the Sheet name from which data is to be read238     * @param rowNumber - The row number from the excel sheet that is to be read239     * @return - Single Excel row that was read240     */241    public Row getAbsoluteSingeExcelRow(String sheetName, int rowNumber) {242        logger.entering(new Object[] { sheetName, rowNumber });243        Sheet sheet = fetchSheet(sheetName);244        Row row = sheet.getRow(rowNumber);245        logger.exiting(row);246        return row;247    }248}...

fetchSheet

Using AI Code Generation

1ExcelReader reader = new ExcelReader();2List<Map<String, String>> data = reader.fetchSheet("src/test/resources/ExcelReaderTest.xlsx", "Sheet1");3for (Map<String, String> map : data) {4    System.out.println(map);5}6{A=1, B=2, C=3}7{A=4, B=5, C=6}8{A=7, B=8, C=9}9ExcelReader reader = new ExcelReader();10List<Map<String, String>> data = reader.fetchSheet("src/test/resources/ExcelReaderTest.xlsx", "Sheet1", 1, 3);11for (Map<String, String> map : data) {12    System.out.println(map);13}14{A=4, B=5, C=6}15{A=7, B=8, C=9}16ExcelReader reader = new ExcelReader();17List<Map<String, String>> data = reader.fetchSheet("src/test/resources/ExcelReaderTest.xlsx", "Sheet1", 1, 2, 2, 3);18for (Map<String, String> map : data) {19    System.out.println(map);20}21{B=5, C=6}22{B=8, C=9}23ExcelReader reader = new ExcelReader();24List<Map<String, String>> data = reader.fetchSheet("src/test/resources/ExcelReaderTest.xlsx", "Sheet1", 1, 2, 2, 2);25for (Map<String, String> map : data) {26    System.out.println(map);27}28{B=5}29{B=8}30ExcelReader reader = new ExcelReader();31List<Map<String, String>> data = reader.fetchSheet("src/test/resources/ExcelReaderTest.xlsx", "Sheet1", 1, 2, 2, 2, 2, 2);32for (Map<String, String> map : data) {33    System.out.println(map);34}

fetchSheet

Using AI Code Generation

1String sheetName = "TestSheet";2String excelFilePath = "src/test/resources/TestData.xlsx";3ExcelReader reader = new ExcelReader();4List<Map<String, String>> data = reader.fetchSheet(sheetName, excelFilePath);5for (Map<String, String> row : data) {6    for (String key : row.keySet()) {7        System.out.println("Key: " + key + " Value: " + row.get(key));8    }9}10String sheetName = "TestSheet";11String excelFilePath = "src/test/resources/TestData.xlsx";12ExcelReader reader = new ExcelReader();13List<Map<String, String>> data = reader.fetchSheet(sheetName, excelFilePath);14for (Map<String, String> row : data) {15    for (String key : row.keySet()) {16        System.out.println("Key: " + key + " Value: " + row.get(key));17    }18}19String sheetName = "TestSheet";20String excelFilePath = "src/test/resources/TestData.xlsx";21ExcelReader reader = new ExcelReader();22List<Map<String, String>> data = reader.fetchSheet(sheetName, excelFilePath);23for (Map<String, String> row : data) {24    for (String key : row.keySet()) {25        System.out.println("Key: " + key + " Value: " + row.get(key));26    }27}28String sheetName = "TestSheet";29String excelFilePath = "src/test/resources/TestData.xlsx";30ExcelReader reader = new ExcelReader();31List<Map<String, String>> data = reader.fetchSheet(sheetName, excelFilePath);32for (Map<String, String> row : data) {33    for (String key : row.keySet()) {34        System.out.println("Key: " + key + " Value: " + row.get(key));35    }36}

fetchSheet

Using AI Code Generation

1String[][] data = ExcelReader.fetchSheet("src/test/resources/ExcelReaderData.xlsx", "Sheet1");2String[][] data = ExcelReader.fetchSheet("src/test/resources/ExcelReaderData.xlsx", 0);3String[][] data = ExcelReader.fetchSheet("src/test/resources/ExcelReaderData.xlsx", 0, 1);4String[][] data = ExcelReader.fetchSheet("src/test/resources/ExcelReaderData.xlsx", 0, 1, 1);5String[][] data = ExcelReader.fetchSheet("src/test/resources/ExcelReaderData.xlsx", 0, 1, 1, 2);6String[][] data = ExcelReader.fetchSheet("src/test/resources/ExcelReaderData.xlsx", 0, 1, 1, 2, 2);7String[][] data = ExcelReader.fetchSheet("src/test/resources/ExcelReaderData.xlsx", 0, 1, 1, 2,

fetchSheet

Using AI Code Generation

1import java.util.*;2import com.paypal.selion.platform.dataprovider.impl.ExcelReader;3import com.paypal.selion.platform.dataprovider.impl.ExcelReader.SheetType;4public class TestClass {5    public static void main(String[] args) {6        List<Map<String, String>> data = ExcelReader.fetchSheet("src/test/resources/data.xlsx", "Sheet1", SheetType.XLSX);7        System.out.println(data);8    }9}10[{column1=value1, column2=value2, column3=value3}, {column1=value4, column2=value5, column3=value6}]11ExcelReader excelReader = new ExcelReader("src/test/resources/data.xlsx", "Sheet1", SheetType.XLSX);12Map<String, String> data = excelReader.fetchSheet(1);13System.out.println(data);14{column1=value2, column2=value3, column3=value4}15ExcelReader excelReader = new ExcelReader("src/test/resources/data.xlsx", "Sheet1", SheetType.XLSX);16Map<String, String> data = excelReader.fetchSheet("column1");17System.out.println(data);18{1=value1, 2=value2, 3=value3, 4=value4, 5=value5}

fetchSheet

Using AI Code Generation

1ExcelReader reader = new ExcelReader("testData.xlsx");2List<List<String>> data = reader.fetchSheet("Sheet1");3ExcelReader reader = new ExcelReader("testData.xlsx");4List<List<String>> data = reader.fetchSheet("Sheet1", 0, 0, 1, 2);5List<List<String>> data = reader.fetchSheet("Sheet1", 1, 1, 1, 2);6ExcelReader reader = new ExcelReader("testData.xlsx");7List<List<String>> data = reader.fetchSheet("Sheet1", 0, 0, 1, 2, 1);8List<List<String>> data = reader.fetchSheet("Sheet1", 1, 1, 1, 2, 1);9ExcelReader reader = new ExcelReader("testData.xlsx");10List<List<String>> data = reader.fetchSheet("Sheet1", 0, 0, 1, 2, 1, 1, 2);11List<List<String>> data = reader.fetchSheet("Sheet1", 1, 1, 1, 2, 1, 1, 2);12ExcelReader reader = new ExcelReader("testData.xlsx");13List<List<String>> data = reader.fetchSheet("Sheet1", 0, 0, 1, 2, 1, 1, 2, 1, 2);14List<List<String>> data = reader.fetchSheet("Sheet1", 1, 1, 1, 2, 1, 1, 2,

fetchSheet

Using AI Code Generation

1ExcelReader reader = new ExcelReader("path/to/excel/file");2List<List<String>> data = reader.fetchSheet("sheetName");3ExcelReader reader = new ExcelReader("path/to/excel/file");4List<List<String>> data = reader.fetchSheet("sheetName", 2, 3);5ExcelReader reader = new ExcelReader("path/to/excel/file");6List<List<String>> data = reader.fetchSheet("sheetName", 2, 3, 5, 6);7ExcelReader reader = new ExcelReader("path/to/excel/file");8List<List<String>> data = reader.fetchSheet("sheetName", 2, 3, 5, 6, false);9ExcelReader reader = new ExcelReader("path/to/excel/file");10List<List<String>> data = reader.fetchSheet("sheetName", 2, 3, 5, 6, true);11ExcelReader reader = new ExcelReader("path/to/excel/file");12List<List<String>> data = reader.fetchSheet("sheetName", 2,

fetchSheet

Using AI Code Generation

1package com.paypal.selion.dataprovider;2import java.util.Iterator;3import java.util.List;4import org.testng.annotations.DataProvider;5import org.testng.annotations.Test;6import com.paypal.selion.platform.dataprovider.impl.ExcelReader;7public class TestExcelReader {8    @DataProvider(name = "ExcelDataProvider")9    public Iterator<Object[]> dataProvider() {

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.