{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Courier;}{\f1\fswiss\fcharset0 Arial;}} {\colortbl ;\red127\green0\blue85;\red255\green255\blue255;\red0\green0\blue0;\red63\green95\blue191;\red42\green0\blue255;\red63\green127\blue95;} \viewkind4\uc1\pard\cf1\highlight2\b\f0\fs20 import\cf0\b0 \cf3 java.io.FileInputStream;\cf0\highlight0\par \cf1\highlight2\b import\cf0\b0 \cf3 java.io.FileNotFoundException;\cf0\highlight0\par \cf1\highlight2\b import\cf0\b0 \cf3 java.io.IOException;\cf0\highlight0\par \par \cf1\highlight2\b import\cf0\b0 \cf3 org.apache.poi.hssf.usermodel.HSSFCell;\cf0\highlight0\par \cf1\highlight2\b import\cf0\b0 \cf3 org.apache.poi.hssf.usermodel.HSSFName;\cf0\highlight0\par \cf1\highlight2\b import\cf0\b0 \cf3 org.apache.poi.hssf.usermodel.HSSFRow;\cf0\highlight0\par \cf1\highlight2\b import\cf0\b0 \cf3 org.apache.poi.hssf.usermodel.HSSFSheet;\cf0\highlight0\par \cf1\highlight2\b import\cf0\b0 \cf3 org.apache.poi.hssf.usermodel.HSSFWorkbook;\cf0\highlight0\par \cf1\highlight2\b import\cf0\b0 \cf3 org.apache.poi.hssf.util.AreaReference;\cf0\highlight0\par \cf1\highlight2\b import\cf0\b0 \cf3 org.apache.poi.hssf.util.CellReference;\cf0\highlight0\par \cf1\highlight2\b import\cf0\b0 \cf3 org.apache.poi.poifs.filesystem.POIFSFileSystem;\cf0\highlight0\par \par \cf1\highlight2\b import\cf0\b0 \cf3 java.io.FileOutputStream;\cf0\highlight0\par \par \cf4\highlight2 /**\cf0\highlight0\par \highlight2 \cf4 *\cf0 \cf4 See\cf0 \cf4 main\cf0 \cf4 method\cf0 \cf4 for\cf0 \cf4 switching\cf0 \cf4 test\cf0 \cf4 methods\cf0\highlight0\par \highlight2 \cf4 */\cf0\highlight0\par \cf1\highlight2\b public\cf0\b0 \cf1\b class\cf0\b0 \cf3 Vlookup\cf0 \cf3\{\cf0\highlight0\par \par \highlight2\tab\cf1\b private\cf0\b0 \cf1\b static\cf0\b0 \cf1\b final\cf0\b0 \cf3 String\cf0 \cf3 TESTINGL\cf0 \cf3 =\cf0 \cf5 "C:/temp/VLOOKUP-RECREATE.xls"\cf3 ;\cf0\highlight0\par \highlight2\tab\cf1\b private\cf0\b0 \cf1\b static\cf0\b0 \cf1\b final\cf0\b0 \cf3 String\cf0 \cf3 TESTOUTGL\cf0 \cf3 =\cf0 \cf5 "C:/temp/testoutgl.xls"\cf3 ;\cf0\tab\highlight0\par \highlight2\tab\highlight0\par \highlight2\tab\highlight0\par \highlight2\tab\cf1\b public\cf0\b0 \cf1\b static\cf0\b0 \cf1\b void\cf0\b0 \cf3 main(String[]\cf0 \cf3 args)\cf0 \cf3\{\cf0\highlight0\par \highlight2\tab\tab\cf3 Vlookup pt\cf0 \cf3 =\cf0 \cf1\b new\cf0\b0 \cf3 Vlookup();\cf0\highlight0\par \highlight2\tab\tab\cf6 //pt.testAuto();\cf0\highlight0\par \highlight2\tab\tab\cf3 pt.testGL();\cf0\highlight0\par \highlight2\tab\tab\highlight0\par \highlight2\tab\cf3\}\cf0\highlight0\par \highlight2\tab\cf1\b public\cf0\b0 \cf1\b void\cf0\b0 \cf3 testGL()\cf0 \cf3\{\cf0\highlight0\par \highlight2\tab\tab\highlight0\par \highlight2\tab\tab\cf1\b try\cf0\b0 \cf3\{\cf0\highlight0\par \highlight2\tab\tab\tab\highlight0\par \highlight2\tab\tab\tab\cf3 POIFSFileSystem\cf0 \cf3 fs\cf0 \cf3 =\cf0\highlight0\par \highlight2\tab\tab\tab \cf1\b new\cf0\b0 \cf3 POIFSFileSystem(\cf1\b new\cf0\b0 \cf3 FileInputStream(TESTINGL));\cf0\highlight0\par \highlight2\tab\tab\tab\cf3 HSSFWorkbook\cf0 \cf3 wb\cf0 \cf3 =\cf0 \cf1\b new\cf0\b0 \cf3 HSSFWorkbook(fs);\cf0\highlight0\par \par \highlight2\tab\tab\tab\cf6 // Write the output to a file\cf0\highlight0\par \highlight2\tab\tab\tab\cf3 FileOutputStream\cf0 \cf3 fileOut\cf0 \cf3 =\cf0 \cf1\b new\cf0\b0 \cf3 FileOutputStream(TESTOUTGL);\cf0\highlight0\par \highlight2\tab\tab\tab\cf3 wb.write(fileOut);\cf0\highlight0\par \highlight2\tab\tab\tab\cf3 fileOut.close();\cf0\highlight0\par \highlight2\tab\tab\tab\highlight0\par \highlight2\tab\tab\cf3\}\cf0 \cf1\b catch\cf0\b0 \cf3 (FileNotFoundException\cf0 \cf3 e)\cf0 \cf3\{\cf0\highlight0\par \highlight2\tab\tab\tab\cf3 System.out.println(\cf5 "FNF: "\cf0 \cf3 +e.getMessage());\cf0\highlight0\par \highlight2\tab\tab\cf3\}\cf0 \cf1\b catch\cf0\b0 \cf3 (IOException\cf0 \cf3 e)\cf0 \cf3\{\cf0\highlight0\par \highlight2\tab\tab\tab\cf3 System.out.println(\cf5 "IO: "\cf0 \cf3 +e.getMessage());\cf0\highlight0\par \highlight2\tab\tab\cf3\}\cf0 \cf1\b catch\cf0\b0 \cf3 (Exception\cf0 \cf3 e)\cf0 \cf3\{\cf0\highlight0\par \highlight2\tab\tab\tab\cf3 System.out.println(\cf5 "Exc: "\cf0 \cf3 +e.getClass()\cf0 \cf3 +\cf0 \cf5 " MSG: "\cf0 \cf3 +\cf0 \cf3 e.getMessage());\cf0\highlight0\par \highlight2\tab\tab\cf3\}\cf0\highlight0\par \highlight2\tab\cf3\}\cf0\highlight0\par \par \cf3\highlight2\}\cf0\highlight0\par \f1\par }