import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.poifs.filesystem.POIFSFileSystem; import java.io.File; import java.io.FileOutputStream; import java.io.FileInputStream; import java.util.Iterator; import java.util.ArrayList; public class ExcelConverterTest { public ExcelConverterTest () { } public static void main (String [] args) { String inpFileName = args[0]; System.out.println("Started..."); try { ExcelConverterTest converter = new ExcelConverterTest(); FileInputStream ipStream = new FileInputStream(inpFileName); POIFSFileSystem fileSystem = new POIFSFileSystem(ipStream); HSSFWorkbook workBook = new HSSFWorkbook(fileSystem); HSSFSheet singleSheet = workBook.getSheetAt(0); System.out.println("last row = "+singleSheet.getLastRowNum()); HSSFRow row = singleSheet.getRow(0); System.out.println("last column = "+row.getLastCellNum()); ipStream.close(); } catch (Exception e) { System.out.println("Encountered exception with message - "+e.getMessage()); } } }