net.technearts

Class ExcelFile

java.lang.Object

net.technearts.ExcelFile

All Implemented Interfaces:

AutoCloseable

public class ExcelFile
extends Object
implements AutoCloseable

Constructor Summary

Constructors

Constructor and Description
ExcelFile(File file)
ExcelFile(Path path)

Method Summary

Modifier and Type	Method and Description
void	close()
int	getColumn(String sheetName, Predicate<org.apache.poi.ss.usermodel.Cell> predicate)
SortedSet<Integer>	getRows(String sheetName, Predicate<org.apache.poi.ss.usermodel.Row> predicate)
String	read(String sheetName, int line, int column)
String	read(String sheetName, int line, int column, Consumer<String> action)
<T> T	read(String sheetName, int line, int column, Converter<T> function)
<T> T	read(String sheetName, int line, int column, Converter<T> function, Consumer<T> action)
void	save(File file)
void	save(Path path)
net.technearts.ExcelFile.ExcelSheet	sheet(String sheetName)
<T> void	write(String sheetName, int line, int column, T value)

Methods inherited from class java.lang.Object

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

Constructor Detail

ExcelFile

public ExcelFile(Path path)
          throws FileNotFoundException,
                 IOException

Throws:

FileNotFoundException

IOException

ExcelFile

public ExcelFile(File file)
          throws FileNotFoundException,
                 IOException

Throws:

FileNotFoundException

IOException

Method Detail

read

public <T> T read(String sheetName,
                  int line,
                  int column,
                  Converter<T> function,
                  Consumer<T> action)

read

public <T> T read(String sheetName,
                  int line,
                  int column,
                  Converter<T> function)

read

public String read(String sheetName,
                   int line,
                   int column,
                   Consumer<String> action)

read

public String read(String sheetName,
                   int line,
                   int column)

write

public <T> void write(String sheetName,
                      int line,
                      int column,
                      T value)

getRows

public SortedSet<Integer> getRows(String sheetName,
                                  Predicate<org.apache.poi.ss.usermodel.Row> predicate)

getColumn

public int getColumn(String sheetName,
                     Predicate<org.apache.poi.ss.usermodel.Cell> predicate)

sheet

public net.technearts.ExcelFile.ExcelSheet sheet(String sheetName)

save

public void save(Path path)

save

public void save(File file)

close

public void close()

Specified by:

close in interface AutoCloseable