Rob Prime wrote:Where does class csmip.EvpnExcelParser come from? Is it your own, or did you download it from somewhere?
Its my own class.
this is the method used in EVnExcelParser class
public void displayFromExcel (
String xlsPath) throws Exception
{
InputStream inputStream = null;
try
{
inputStream = new FileInputStream (xlsPath);
}
catch (FileNotFoundException e)
{
log.out("File not found in the specified path.");
throw new Exception(e);
}
POIFSFileSystem fileSystem = null;
try
{
fileSystem = new POIFSFileSystem (inputStream);
HSSFWorkbook workBook = new HSSFWorkbook (fileSystem);
HSSFSheet sheet = workBook.getSheetAt (0);
HSSFRow row = null;
HSSFCell cell=null;
int rows=sheet.getPhysicalNumberOfRows();
int cols=sheet.getRow(1).getPhysicalNumberOfCells();