org.imaginea.test.automation.framework.util.readers

Class CsvReader

java.lang.Object

org.imaginea.test.automation.framework.util.readers.CsvReader

public class CsvReader
extends Object

Util class to read csv files.

Author:

Varun Menon

Constructor Summary

Constructors

Constructor and Description
CsvReader(File inpFile)
CsvReader(File inpFile, char separator, char quotechar) Creates the CsvReader class object
CsvReader(File inpFile, String separator, String quotechar)
CsvReader(Reader reader, char separator, char quotechar) Creates the CsvReader class object
CsvReader(String filePath)
CsvReader(String filePath, char separator, char quotechar) Creates the CsvReader class object

Method Summary

Methods

Modifier and Type	Method and Description
String	getData(int row, int column) Gets the data from csv file based on column and row number
int	getNoOfColumn() Return the number of column in the first row of the csv file
int	getNoOfColumn(int rowNo) Returns the number of the column of the said row number passed
int	getNoOfRows() Get the number of rows in the said csv file

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

CsvReader

public CsvReader(String filePath,
         char separator,
         char quotechar)
          throws IOException

Creates the CsvReader class object

Parameters:

filePath - - File path of the csv file to be read

separator - - Data separator to be used. Default value is ','

quotechar - - Quote character for the data. Default value is '"'

Throws:

IOException

CsvReader

public CsvReader(File inpFile,
         char separator,
         char quotechar)
          throws IOException

Creates the CsvReader class object

Parameters:

inpFile - - Input csv file to be read

separator - - Data separator to be used. Default value is ','

quotechar - - Quote character for the data. Default value is '"'

Throws:

IOException

CsvReader

public CsvReader(File inpFile,
         String separator,
         String quotechar)
          throws IOException

Throws:

IOException

CsvReader

public CsvReader(String filePath)
          throws IOException

Throws:

IOException

CsvReader

public CsvReader(File inpFile)
          throws IOException

Throws:

IOException

CsvReader

public CsvReader(Reader reader,
         char separator,
         char quotechar)
          throws IOException

Creates the CsvReader class object

Parameters:

reader - - Reader object of the file to be read

separator - - Data separator to be used. Default value is ','

quotechar - - Quote character for the data. Default value is '"'

Throws:

IOException

Method Detail

getData

public String getData(int row,
             int column)

Gets the data from csv file based on column and row number

Parameters:

column - Column number

row - Row number

Returns:

The data at the said position. If the said row or column don't exists then return an empty string

getNoOfRows

public int getNoOfRows()

Get the number of rows in the said csv file

Returns:

Return no of rows present in the said csv file

getNoOfColumn

public int getNoOfColumn()

Return the number of column in the first row of the csv file

Returns:

return the no. of column in the first row of the csv file

getNoOfColumn

public int getNoOfColumn(int rowNo)

Returns the number of the column of the said row number passed

Parameters:

rowNo - - row number for which the number columns needs to be returned.

Returns:

return the no. of column in the specified row of the csv file