com.todo.csvutil

Class CSVUtil

java.lang.Object

com.todo.csvutil.CSVUtil

public class CSVUtil
extends java.lang.Object

CSVUtil handles specific operations that might be done to a csvFile. This class provides abstraction so the user has no need to mess with data first hand.

Author:

robal

Constructor Summary

Constructors

Constructor and Description
CSVUtil(java.lang.String inputFileName)
CSVUtil(java.lang.String inputFileName, java.lang.String outputFileName)

Method Summary

Modifier and Type	Method and Description
void	appendChanges()
void	close()
int	Count(int col, java.lang.String value)
java.lang.String	CSVDataget(int i, int j)
void	displayFile() Display entire file
void	duplicateFile() Creates a copy of file loaded
void	exportHTML() Exports the file to HTML tabel
CSVData	get(int i)
CSVDataContainer	getCSVDataContainer()
int	LinearFind(int col, java.lang.String value)
void	loadFile()
void	merge(java.util.ArrayList<java.lang.String> filePaths, int row, java.lang.String newFile)
void	remove(int row)
void	sortAcending(int column)
void	sortDecending(int column)
void	writeChanges()

Methods inherited from class java.lang.Object

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

Constructor Detail

CSVUtil

public CSVUtil(java.lang.String inputFileName,
               java.lang.String outputFileName)
        throws java.io.IOException

Throws:

java.io.IOException

CSVUtil

public CSVUtil(java.lang.String inputFileName)
        throws java.io.IOException

Throws:

java.io.IOException

Method Detail

loadFile

public void loadFile()
              throws java.io.IOException

Throws:

java.io.IOException

sortAcending

public void sortAcending(int column)
                  throws java.io.IOException

Parameters:

column - - column to sort rows by

Throws:

java.io.IOException - - possibility from file reads

sortDecending

public void sortDecending(int column)
                   throws java.io.IOException

Parameters:

column - - column to sort rows by

Throws:

java.io.IOException - - exception caused by file read

remove

public void remove(int row)

Parameters:

row -

writeChanges

public void writeChanges()
                  throws java.io.IOException

Throws:

java.io.IOException

appendChanges

public void appendChanges()
                   throws java.io.IOException

Throws:

java.io.IOException

close

public void close()
           throws java.io.IOException

Throws:

java.io.IOException

displayFile

public void displayFile()
                 throws java.io.IOException

Display entire file

Throws:

java.io.IOException - - File read exception

duplicateFile

public void duplicateFile()
                   throws java.io.IOException

Creates a copy of file loaded

Throws:

java.io.IOException

exportHTML

public void exportHTML()
                throws java.io.IOException

Exports the file to HTML tabel

Throws:

java.io.IOException

merge

public void merge(java.util.ArrayList<java.lang.String> filePaths,
                  int row,
                  java.lang.String newFile)
           throws java.io.IOException

Throws:

java.io.IOException

Count

public int Count(int col,
                 java.lang.String value)

Parameters:

col - - column of the searched valued

value - - value to be searched for in the specified column

Returns:

number of times a row contains specified value

LinearFind

public int LinearFind(int col,
                      java.lang.String value)

Parameters:

col - - column of the searched value

value - - value to be searched for

Returns:

first csvData(row) of data containing the value in the specified column

get

public CSVData get(int i)

Parameters:

i - - index of data element(row)

Returns:

CSVDataget

public java.lang.String CSVDataget(int i,
                                   int j)

Parameters:

i - - Row index

j - - Column index

Returns:

CSV string element at (i,j)

getCSVDataContainer

public CSVDataContainer getCSVDataContainer()

Returns:

container of CSVdata elements