@@ -0,0 +1,1640 @@
+package eyeglassesmain;%0A%0Aimport java.io.File;%0Aimport java.io.FileInputStream;%0Aimport java.util.HashMap;%0A%0Aimport org.apache.poi.hssf.usermodel.HSSFCell;%0Aimport org.apache.poi.hssf.usermodel.HSSFRow;%0Aimport org.apache.poi.hssf.usermodel.HSSFSheet;%0Aimport org.apache.poi.hssf.usermodel.HSSFWorkbook;%0Aimport org.apache.poi.poifs.filesystem.POIFSFileSystem;%0A%0Apublic class EyeglassesMain %7B%0A%09public static void main(String%5B%5D args) throws Exception%7B%0A%09%09try %7B%0A%09%09%09File file = new File(%22/Users/mjohansen15/Documents/GuatemalaGlassesFebruary-20142.xls%22);%0A%09%09%09POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(file));%0A%09%09%09HSSFWorkbook wb = new HSSFWorkbook(fs);%0A%09%09%09HSSFSheet sheet = wb.getSheetAt(0);%0A%09%09%09HSSFRow row;%0A%09%09%09HSSFRow firstRow;%0A%09%09%09HSSFCell cell;%0A%0A%09%09%09int rows; // No of rows%0A%09%09%09rows = sheet.getPhysicalNumberOfRows();%0A%0A%09%09%09int cols = 0; // No of columns%0A%09%09%09int tmp = 0;%0A%0A%09%09%09// This trick ensures that we get the data properly even if it doesn't start from first few rows%0A%09%09%09/*for(int i = 0; i %3C 10 %7C%7C i %3C rows; i++) %7B%0A%09%09%09%09row = sheet.getRow(i);%0A%09%09%09%09if(row != null) %7B%0A%09%09%09%09%09tmp = sheet.getRow(i).getPhysicalNumberOfCells();%0A%09%09%09%09%09if(tmp %3E cols) cols = tmp;%0A%09%09%09%09%7D%0A%09%09%09%7D%0A%0A%09%09%09for(int r = 0; r %3C rows; r++) %7B%0A%09%09%09%09row = sheet.getRow(r);%0A%09%09%09%09if(row != null) %7B%0A%09%09%09%09%09for(int c = 0; c %3C cols; c++) %7B%0A%09%09%09%09%09%09cell = row.getCell(c);%0A%09%09%09%09%09%09if(cell != null) %7B%0A%0A%09%09%09%09%09%09%7D%0A%09%09%09%09%09%7D%0A%09%09%09%09%7D%0A%09%09%09%7D*/%0A%09%09%09%0A%09%09%09HashMap%3CString, String%5B%5D%3E table = new HashMap%3CString, String%5B%5D%3E();%0A%09%09%09%0A%09%09%09firstRow = sheet.getRow(0);%0A%09%09%09%0A%09%09%09int i = 1;%0A%09%09%09do%7B%0A%09%09%09%09row = sheet.getRow(i);%0A%09%09%09%09i = i + 1;%0A%09%09%09%7D while(row != null);%0A%09%09%09%0A%09%09%7D catch(Exception ioe) %7B%0A%09%09%09ioe.printStackTrace();%0A%09%09%7D%0A%09%7D%0A%7D%0A

Create EyeglassesMain.java