nmap.parser.ExcelLayout.java Source code

Introduction

Here is the source code for nmap.parser.ExcelLayout.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package nmap.parser;

import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.Map;
import java.util.Set;
import java.util.TreeMap;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

/**
 *
 * @author Maricone.A.StaMaria
 */
public class ExcelLayout {

    public void Layouting(String nmap, String folderpath) throws FileNotFoundException, IOException {
        MainList ml = new MainList();
        ml.Mainlist(nmap, folderpath);
        //  System.out.println(ml.getHeadertemp());
        //System.out.println(ml.getPopulatefield());

        XSSFWorkbook workbook = new XSSFWorkbook();
        //Create a blank sheet
        XSSFSheet spreadsheet = workbook.createSheet(" PORT STATUS ");
        //Create row object
        XSSFRow row;
        //This data needs to be written (Object[])
        //setHeadertemp(header);
        // setPopulatefield(fieldlayout);
        //    String s = fieldlayout.get(0).toString();
        //System.out.println("MainList class: "+s);
        Map<String, Object[]> empinfo = new TreeMap<String, Object[]>();
        empinfo.put("1", ml.getHeadertemp().toArray());
        int ind = 2;
        //  empinfo.put("2", fieldlayout.get(0).toArray());
        for (int h = 0; h < ml.getPopulatefield().size(); h++) {
            String index = Integer.toString(ind);
            empinfo.put(index, ml.getPopulatefield().get(h).toArray());
            ind++;
        }

        Set<String> keyid = empinfo.keySet();
        int rowid = 0;
        for (String key : keyid) {
            row = spreadsheet.createRow(rowid++);
            Object[] objectArr = empinfo.get(key);
            int cellid = 0;
            for (Object obj : objectArr) {
                XSSFCell cell = row.createCell(cellid++);
                cell.setCellValue((String) obj);
            }
        }
        // Write the workbook in file system
        String hhaha = "Kingkunta.xlsx";
        FileOutputStream out = new FileOutputStream(new File(hhaha));
        workbook.write(out);
        out.close();
        System.out.println(hhaha + ".xlsx written successfully");

    }
}