Package io.github.mbenincasa.javaexcelutils.tools

Class ExcelUtility

java.lang.Object

io.github.mbenincasa.javaexcelutils.tools.ExcelUtility

public class ExcelUtility
extends Object

ExcelUtility is the static class with the implementations of some utilities on Excel files

Since:

0.2.0

Author:

Mirko Benincasa

Constructor Summary

Constructors

Constructor	Description
ExcelUtility()

Method Summary

Modifier and Type	Method	Description
static String	checkExcelExtension(String filename)	Check if the extension is that of an Excel file
static int[]	getCellIndexes(String cellName)	Return an array containing column and row indexes
static String	getCellName(int row, int col)	Returns the cell name
static Boolean	isValidExcelExtension(String extension)	Check if the extension is that of an Excel file

Methods inherited from class java.lang.Object

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

Constructor Details

ExcelUtility

public ExcelUtility()

Method Details

checkExcelExtension

public static String checkExcelExtension(String filename)
                                  throws ExtensionNotValidException

Check if the extension is that of an Excel file

Parameters:

filename - The name of the file with extension

Returns:

The name of the extension

Throws:

ExtensionNotValidException - If the filename extension does not belong to an Excel file

isValidExcelExtension

public static Boolean isValidExcelExtension(String extension)

Check if the extension is that of an Excel file

Parameters:

extension - The file's extension

Returns:

true if it is the extension of an Excel file

getCellName

public static String getCellName(int row,
 int col)

Returns the cell name

Parameters:

row - row index

col - column index

Returns:

cell name

Since:

0.4.2

getCellIndexes

public static int[] getCellIndexes(String cellName)

Return an array containing column and row indexes

Parameters:

cellName - cell name

Returns:

an array containing column and row indexes

Since:

0.4.2