{"id":335,"date":"2017-06-22T11:38:56","date_gmt":"2017-06-22T11:38:56","guid":{"rendered":"http:\/\/www.codeinsightacademy.com\/blog\/?p=335"},"modified":"2017-06-22T11:44:30","modified_gmt":"2017-06-22T11:44:30","slug":"apache-poi-poor-obfuscation-implementation-file-system","status":"publish","type":"post","link":"https:\/\/codeinsightacademy.com\/blog\/java\/apache-poi-poor-obfuscation-implementation-file-system\/","title":{"rendered":"Apache POI (Poor Obfuscation Implementation File System)"},"content":{"rendered":"

Prerequisite
\nDownload all poi jar files
\nhttps:\/\/poi.apache.org\/download.html<\/a><\/p>\n

\n
    \n
  1. \u00a0Terms\n
      \n
    • Workbook – The file contains number of sheets<\/li>\n
    • Sheet – Matrix contains rows and cell<\/li>\n
    • Row – Record of an entity in one row<\/li>\n
    • Cell – A single cell which hold value<\/li>\n<\/ul>\n<\/li>\n
    • \n
      JFileChooser fileChooser = new JFileChooser();\r\n        int returnValue = fileChooser.showDialog(null, \"Select File\");\r\n        \r\n        if(returnValue == JFileChooser.APPROVE_OPTION) {\r\n            Workbook workbook = new HSSFWorkbook(new FileInputStream(fileChooser.getSelectedFile()));\r\n            \r\n            Sheet sheet = workbook.getSheetAt(0);\r\n            \r\n            for(Iterator<Row> rit = sheet.rowIterator(); rit.hasNext();){\r\n                for(Iterator<Cell> cit = rit.next().cellIterator(); cit.hasNext();){\r\n                    System.out.println(cit.next());\r\n                }\r\n                System.out.println(\"\");\r\n            }\r\n        } else {\r\n            System.out.println(\"Invalid output\");\r\n        }<\/pre>\n<\/li>\n
    • \n
      JFileChooser fileChooser = new JFileChooser();\r\n        int returnValue = fileChooser.showDialog(null, \"Select File\");\r\n        \r\n        if(returnValue == JFileChooser.APPROVE_OPTION) {\r\n            FileInputStream excelFile = new FileInputStream(fileChooser.getSelectedFile());\r\n            Workbook workbook = new XSSFWorkbook(excelFile);\r\n            \r\n            Sheet sheet = workbook.getSheetAt(0);\r\n            \r\n            for(Iterator<Row> rit = sheet.rowIterator(); rit.hasNext();) {\r\n                for(Iterator<Cell> cit = rit.next().cellIterator(); cit.hasNext();) {\r\n                    System.out.print(cit.next() + \"\\t\" + cit.next());\r\n                }\r\n                System.out.println(\"\");\r\n            }\r\n        }<\/pre>\n<\/li>\n
    • \n
       Workbook workbook = new HSSFWorkbook();\r\n        \r\n        Sheet sheet1 = workbook.createSheet(\"movies\");\r\n\/\/        Sheet sheet2 = workbook.createSheet(\"Test Cases\");\r\n\/\/        Sheet sheet3 = workbook.createSheet(WorkbookUtil.createSafeSheetName(\"$*(^&?\"));\r\n        \r\n        Row row = sheet1.createRow(0);\r\n        \r\n\/\/        Cell cell = row.createCell(4);\r\n\/\/        cell.setCellValue(\"Hello World\");\r\n\/\/        Cell cell2 = row.createCell(3);\r\n\/\/        cell2.setCellValue(\"terminator\");\r\n\/\/        System.out.println(cell.getRichStringCellValue().toString());\r\n\/\/        System.out.println(cell2.getRichStringCellValue().toString());\r\n\r\n        Cell cell1 = row.createCell(0);\r\n        Cell cell2 = row.createCell(1);\r\n        Cell cell3 = row.createCell(2);\r\n        Cell cell4 = row.createCell(3);\r\n        Cell cell5 = row.createCell(4);\r\n        \r\n        cell1.setCellValue(5);\r\n        cell2.setCellValue(\"+\");\r\n        cell3.setCellValue(6);\r\n        cell4.setCellValue(\"=\");\r\n        cell5.setCellFormula(\"A1+C1\");\r\n        \r\n        try {\r\n            FileOutputStream outputStream = new FileOutputStream(\"test1.xlsx\");\r\n            workbook.write(outputStream);\r\n            outputStream.close();\r\n        } catch (Exception e) {\r\n            e.printStackTrace();\r\n        }<\/pre>\n<\/li>\n
    • \u00a0Complete Program\n
      import java.io.FileInputStream;\r\nimport java.io.FileNotFoundException;\r\nimport java.io.FileOutputStream;\r\nimport java.io.IOException;\r\nimport java.util.Iterator;\r\nimport javax.swing.JFileChooser;\r\nimport org.apache.poi.hssf.usermodel.HSSFWorkbook;\r\nimport org.apache.poi.ss.usermodel.Workbook;\r\nimport org.apache.poi.ss.usermodel.Sheet;\r\nimport org.apache.poi.ss.util.WorkbookUtil;\r\nimport org.apache.poi.ss.usermodel.Row;\r\nimport org.apache.poi.ss.usermodel.Cell;\r\nimport org.apache.poi.xssf.usermodel.XSSFWorkbook;\r\n\r\n\/**\r\n *\r\n * @author Shailesh Sonare\r\n *\/\r\npublic class ApachePOIDemo {\r\n\r\n    \/**\r\n     * @param args the command line arguments\r\n     *\/\r\n    public static void main(String[] shailesh) throws IOException {\r\n        \r\n        \/*\r\n        \r\n        Workbook workbook = new HSSFWorkbook();\r\n        \r\n        Sheet sheet1 = workbook.createSheet(\"movies\");\r\n\/\/        Sheet sheet2 = workbook.createSheet(\"Test Cases\");\r\n\/\/        Sheet sheet3 = workbook.createSheet(WorkbookUtil.createSafeSheetName(\"$*(^&?\"));\r\n        \r\n        Row row = sheet1.createRow(0);\r\n        \r\n\/\/        Cell cell = row.createCell(4);\r\n\/\/        cell.setCellValue(\"Hello World\");\r\n\/\/        Cell cell2 = row.createCell(3);\r\n\/\/        cell2.setCellValue(\"terminator\");\r\n\/\/        System.out.println(cell.getRichStringCellValue().toString());\r\n\/\/        System.out.println(cell2.getRichStringCellValue().toString());\r\n\r\n        Cell cell1 = row.createCell(0);\r\n        Cell cell2 = row.createCell(1);\r\n        Cell cell3 = row.createCell(2);\r\n        Cell cell4 = row.createCell(3);\r\n        Cell cell5 = row.createCell(4);\r\n        \r\n        cell1.setCellValue(5);\r\n        cell2.setCellValue(\"+\");\r\n        cell3.setCellValue(6);\r\n        cell4.setCellValue(\"=\");\r\n        cell5.setCellFormula(\"A1+C1\");\r\n        \r\n        try {\r\n            FileOutputStream outputStream = new FileOutputStream(\"test1.xlsx\");\r\n            workbook.write(outputStream);\r\n            outputStream.close();\r\n        } catch (Exception e) {\r\n            e.printStackTrace();\r\n        }\r\n        *\/\r\n        \/*\r\n        JFileChooser fileChooser = new JFileChooser();\r\n        int returnValue = fileChooser.showDialog(null, \"Select File\");\r\n        \r\n        if(returnValue == JFileChooser.APPROVE_OPTION) {\r\n            Workbook workbook = new HSSFWorkbook(new FileInputStream(fileChooser.getSelectedFile()));\r\n            \r\n            Sheet sheet = workbook.getSheetAt(0);\r\n            \r\n            for(Iterator<Row> rit = sheet.rowIterator(); rit.hasNext();){\r\n                for(Iterator<Cell> cit = rit.next().cellIterator(); cit.hasNext();){\r\n                    System.out.println(cit.next());\r\n                }\r\n                System.out.println(\"\");\r\n            }\r\n        } else {\r\n            System.out.println(\"Invalid output\");\r\n        }\r\n        *\/\r\n        \r\n        JFileChooser fileChooser = new JFileChooser();\r\n        int returnValue = fileChooser.showDialog(null, \"Select File\");\r\n        \r\n        if(returnValue == JFileChooser.APPROVE_OPTION) {\r\n            FileInputStream excelFile = new FileInputStream(fileChooser.getSelectedFile());\r\n            Workbook workbook = new XSSFWorkbook(excelFile);\r\n            \r\n            Sheet sheet = workbook.getSheetAt(0);\r\n            \r\n            for(Iterator<Row> rit = sheet.rowIterator(); rit.hasNext();) {\r\n                for(Iterator<Cell> cit = rit.next().cellIterator(); cit.hasNext();) {\r\n                    System.out.print(cit.next() + \"\\t\" + cit.next());\r\n                }\r\n                System.out.println(\"\");\r\n            }\r\n        }\r\n        \r\n    }    \r\n}\r\n<\/pre>\n
       <\/p>\n
       <\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
      Prerequisite Download all poi jar files https:\/\/poi.apache.org\/download.html \u00a0Terms Workbook – The file contains number of sheets Sheet – Matrix contains rows and cell Row – Record of an entity in one row Cell – A single cell which hold value JFileChooser fileChooser = new JFileChooser(); int returnValue = fileChooser.showDialog(null, “Select File”); if(returnValue == JFileChooser.APPROVE_OPTION) { […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[],"_links":{"self":[{"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/posts\/335"}],"collection":[{"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/comments?post=335"}],"version-history":[{"count":8,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/posts\/335\/revisions"}],"predecessor-version":[{"id":343,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/posts\/335\/revisions\/343"}],"wp:attachment":[{"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/media?parent=335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/categories?post=335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/codeinsightacademy.com\/blog\/wp-json\/wp\/v2\/tags?post=335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}