Example usage for org.apache.poi.hssf.usermodel HSSFWorkbook write

List of usage examples for org.apache.poi.hssf.usermodel HSSFWorkbook write

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.hssf.usermodel.*
  5. HSSFWorkbook
  6. write

Introduction

In this page you can find the example usage for org.apache.poi.hssf.usermodel HSSFWorkbook write.

Prototype

private void write(POIFSFileSystem fs) throws IOException

Source Link

Document

Writes the workbook out to a brand new, empty POIFS

Usage

From source file:excel.PoiWriteExcelFile.java

public static int generarReporte() {

    //Calendar cal=Calendar.getInstance();
    Calendar cal = WorkMonitorUI.instante;

    try {/*from  w  w  w  . ja va2  s  .c om*/
        FileOutputStream fileOut = new FileOutputStream("HH_"
                + instante.getDisplayName(Calendar.MONTH, Calendar.SHORT_FORMAT, Locale.getDefault())
                        .toUpperCase()
                + "_" + persona.getNombre().toUpperCase().charAt(0) + "." + persona.getApellido().toUpperCase()
                + "_" + instante.get(Calendar.YEAR) + ".xls");
        HSSFWorkbook workbook = new HSSFWorkbook();
        HSSFSheet worksheet = workbook.createSheet(
                cal.getDisplayName(Calendar.MONTH, Calendar.SHORT_FORMAT, Locale.getDefault()).toUpperCase()
                        + "-" + cal.get(Calendar.YEAR));

        HSSFCellStyle cellStyle = workbook.createCellStyle();
        cellStyle.setFillForegroundColor(HSSFColor.YELLOW.index);
        cellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
        HSSFFont font = workbook.createFont();
        font.setFontHeightInPoints((short) 12);
        font.setFontName("Calibri");
        font.setItalic(false);
        font.setBold(true);
        font.setColor(HSSFColor.BLACK.index);
        cellStyle.setFont(font);
        cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        cellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);
        cellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
        cellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);
        cellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);
        cellStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);

        HSSFCellStyle diasStyle = workbook.createCellStyle();
        diasStyle.setFillForegroundColor(HSSFColor.SEA_GREEN.index);
        diasStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
        font = workbook.createFont();
        font.setFontHeightInPoints((short) 11);
        font.setFontName("Calibri");
        font.setItalic(false);
        font.setBold(true);
        font.setColor(HSSFColor.WHITE.index);
        diasStyle.setFont(font);
        diasStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        diasStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);
        diasStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
        diasStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);
        diasStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);
        diasStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);

        HSSFCellStyle schedStyle = workbook.createCellStyle();
        schedStyle.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);
        schedStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
        HSSFFont font3 = workbook.createFont();
        font3.setFontHeightInPoints((short) 11);
        font3.setFontName("Calibri");
        font3.setItalic(false);
        font3.setColor(HSSFColor.BLACK.index);
        schedStyle.setFont(font3);
        schedStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        schedStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);
        schedStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
        schedStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);
        schedStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);
        schedStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);

        HSSFCellStyle workdayStyle = workbook.createCellStyle();
        //workdayStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);                        
        workdayStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        workdayStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);
        workdayStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
        workdayStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);
        workdayStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);
        workdayStyle.setWrapText(true);
        HSSFFont font2 = workbook.createFont();
        font2.setFontHeightInPoints((short) 8);
        font2.setFontName("Serif");
        font2.setItalic(false);
        //font2.setColor(HSSFColor.YELLOW.index);
        workdayStyle.setFont(font2);
        workdayStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);

        HSSFCellStyle weekendStyle = workbook.createCellStyle();
        weekendStyle.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);
        weekendStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
        weekendStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        weekendStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);
        weekendStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
        weekendStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);
        weekendStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);
        weekendStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);

        HSSFCellStyle horarioStyle = workbook.createCellStyle();
        horarioStyle.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);
        horarioStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
        horarioStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        horarioStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);
        horarioStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
        horarioStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);
        horarioStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);
        horarioStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);
        HSSFFont font4 = workbook.createFont();
        font4.setFontHeightInPoints((short) 10);
        font4.setFontName("Serif");
        font4.setItalic(false);
        font4.setBold(true);
        //font2.setColor(HSSFColor.YELLOW.index);
        horarioStyle.setFont(font4);

        // index from 0,0... cell A1 is cell(0,0)
        HSSFRow row1 = worksheet.createRow((short) 0);
        row1.setHeight((short) 500);

        //System.out.println("cal.get(Calendar.YEAR)="+cal.get(Calendar.YEAR));

        HSSFCell cellA1 = row1.createCell((short) 0);
        cellA1.setCellValue(
                cal.getDisplayName(Calendar.MONTH, Calendar.SHORT_FORMAT, Locale.getDefault()).toUpperCase()
                        + "-" + cal.get(Calendar.YEAR));
        cellA1.setCellStyle(cellStyle);

        HSSFRow row2 = worksheet.createRow((short) 1);
        HSSFCell cellA4 = row2.createCell((short) 0);
        cellA4.setCellValue("Horario");
        cellA4.setCellStyle(horarioStyle);
        //row2.setHeight((short)500);

        HSSFRow row3 = worksheet.createRow((short) 2);
        HSSFCell cellA3 = row3.createCell((short) 0);
        cellA3.setCellValue("Inicio - Trmino");
        cellA3.setCellStyle(diasStyle);

        Calendar hora = Calendar.getInstance();

        hora.set(Calendar.HOUR_OF_DAY, 9);
        hora.set(Calendar.MINUTE, 0);
        hora.set(Calendar.SECOND, 0);

        SimpleDateFormat sdf = new SimpleDateFormat("HH:mm");

        HSSFCell cellXn;

        for (int i = 0; i < 29; ++i) {
            HSSFRow row = worksheet.createRow((short) i + 3);
            row.setHeight((short) 500);

            cellXn = row.createCell((short) 0);
            String horaIni = sdf.format(hora.getTime());
            hora.add(Calendar.MINUTE, 30);
            String horaFin = sdf.format(hora.getTime());
            cellXn.setCellValue(horaIni + " - " + horaFin);
            cellXn.setCellStyle(schedStyle);
        }

        System.out.println("cal.get(Calendar.MONTH)1=" + cal.get(Calendar.MONTH));

        cal.add(Calendar.DAY_OF_MONTH, -cal.get(Calendar.DAY_OF_MONTH) + 1);

        int diasMes = cal.getActualMaximum(Calendar.DAY_OF_MONTH);

        System.out.println("cal.get(Calendar.MONTH)2=" + cal.get(Calendar.MONTH));

        sdf = new SimpleDateFormat("EEEE d");

        System.out.println(
                "cal.getActualMaximum(Calendar.DAY_OF_MONTH)1=" + cal.getActualMaximum(Calendar.DAY_OF_MONTH));

        for (int i = 0; i < diasMes; ++i) {
            cellXn = row2.createCell((short) i + 1);
            String dia = sdf.format(cal.getTime());
            dia = Character.toUpperCase(dia.charAt(0)) + dia.substring(1);
            cellXn.setCellValue(dia);
            cellXn.setCellStyle(horarioStyle);
            //System.out.println("cal.get(Calendar.DAY_OF_MONTH)="+cal.get(Calendar.DAY_OF_MONTH));
            cal.add(Calendar.DAY_OF_MONTH, 1);
        }

        for (int i = 0; i < diasMes; ++i) {
            cellXn = row3.createCell((short) i + 1);
            cellXn.setCellValue("Descripcin");
            cellXn.setCellStyle(diasStyle);
        }

        System.out.println(
                "cal.getActualMaximum(Calendar.DAY_OF_MONTH)2=" + cal.getActualMaximum(Calendar.DAY_OF_MONTH));

        // Retroceder mes para que quede como estaba
        cal.add(Calendar.MONTH, -1);
        //cal.add(Calendar.DAY_OF_MONTH, -1);    

        System.out.println(
                "cal.getActualMaximum(Calendar.DAY_OF_MONTH)3=" + cal.getActualMaximum(Calendar.DAY_OF_MONTH));

        HhDao hhDao = new HhDao();
        Object[][] hh = new Object[29][cal.getActualMaximum(Calendar.DAY_OF_MONTH)];

        hh = hhDao.getByMes(WorkMonitorUI.persona.getId(), cal.getTime());

        cal.set(Calendar.DAY_OF_MONTH, 1);

        Sheet sheet = workbook.getSheetAt(0);

        sdf = new SimpleDateFormat("EEEE");

        HSSFPatriarch _drawing = (HSSFPatriarch) sheet.createDrawingPatriarch();
        CreationHelper factory = workbook.getCreationHelper();

        for (int i = 0; i < 29; ++i) {
            Row r = sheet.getRow(i + 3);
            for (int j = 0; j < diasMes; ++j) {
                if (hh[i][j].toString() != "") {
                    cellXn = (HSSFCell) r.createCell((short) j + 1);
                    Hh _hh = (Hh) hh[i][j];
                    cellXn.setCellValue(
                            _hh.getTarea().getNombre().trim() + ": " + _hh.getActividad().getNombre().trim());

                    HSSFAnchor anchor = new HSSFClientAnchor(0, 0, 0, 0, (short) 4, 2, (short) 6, 5);
                    org.apache.poi.ss.usermodel.Comment comment = _drawing.createComment(anchor);
                    String comentario = _hh.getTarea().getComentario().toLowerCase();
                    if (_hh.getComentario() != null)
                        comentario = comentario + _hh.getComentario().toLowerCase();
                    RichTextString str = factory.createRichTextString(comentario);

                    comment.setString(str);

                    cellXn.setCellComment(comment);
                } else {
                    cellXn = (HSSFCell) r.createCell((short) j + 1);
                    cellXn.setCellValue("");
                }
                //System.out.println("sdf.format(cal.getTime())="+sdf.format(cal.getTime()));
                if (Arrays.asList("sbado", "domingo").contains(sdf.format(cal.getTime())))
                    cellXn.setCellStyle(weekendStyle);
                else
                    cellXn.setCellStyle(workdayStyle);
                sheet.setColumnWidth(j, 5000);

                cal.add(Calendar.DAY_OF_MONTH, 1);
                //sheet.autoSizeColumn(j);
            }
            // Retroceder mes para que quede como estaba                
            cal.add(Calendar.MONTH, -1);
            System.out.println("cal.get(Calendar.MONTH)3=" + cal.get(Calendar.MONTH));
            cal.set(Calendar.DAY_OF_MONTH, 1);
        }
        sheet.setColumnWidth(diasMes, 5000);

        WorkMonitorUI.instante = Calendar.getInstance();
        sheet.setColumnWidth(0, 5000);
        sheet.createFreezePane(1, 3);
        // Freeze just one row
        //sheet.createFreezePane( 0, 1, 0, 1 );

        workbook.write(fileOut);
        fileOut.flush();
        fileOut.close();
    } catch (FileNotFoundException e) {
        e.printStackTrace();
        return -1;
    } catch (IOException e) {
        e.printStackTrace();
        return -2;
    }
    return 1;
}

From source file:ExportadoreExcel.TestExportador.java

/**
 * Crea una hoja Excel con el contenido especificado.
 *
 * @param lista List con los datos a escribir en la hoja.
 * @param nombre nombre de la hoja./*from  w w  w  .ja  v a2 s .co m*/
 */
private void crearExcel(List lista, String nombre) {
    //        try {
    HSSFWorkbook libro = new HSSFWorkbook();
    // Se crea una hoja dentro del libro
    HSSFSheet hoja = libro.createSheet();
    int filas = lista.size();
    for (int i = 0; i < filas; i++) {
        List<Object> fila = (List<Object>) lista.get(i);
        Row row = hoja.createRow((short) i);
        int j = 0;
        for (Object token : fila) {
            createCell(row, j, token);
            j = j + 1;
        }
    }
    //////
    JFileChooser fc = new JFileChooser(System.getProperty("user.dir"));
    FileNameExtensionFilter filter = new FileNameExtensionFilter("Archivos Excel", "xls");
    fc.setFileFilter(filter);
    fc.showSaveDialog(null);//Muestra el dilogo
    File guardar = fc.getSelectedFile();
    if (guardar != null) {
        try {
            FileOutputStream archivo = new FileOutputStream(guardar + ".xls");
            libro.write(archivo);
            archivo.close();
            JOptionPane.showMessageDialog(null, "Exportado Correctamente");

        } catch (IOException ex) {
            JOptionPane.showMessageDialog(null, "Error al Exportar", "Error", JOptionPane.ERROR_MESSAGE);
        }
    } /////////
    //            File tempFile = File.createTempFile(nombre, null);
    //            //tempFile.deleteOnExit();
    //            try (FileOutputStream archivo = new FileOutputStream(tempFile)) {
    //                libro.write(archivo);
    //            }
    //            System.out.println("Se exportaron los " + nombre);
    //            return tempFile;
    //        } catch (IOException ex) {
    //            System.out.println("Error exportando " + nombre + ": " + ex);
    //            return null;
    //        }

}

From source file:facade.SincronizaFacade.java

/**
 * Crea una hoja Excel con el contenido especificado.
 *
 * @param lista List con los datos a escribir en la hoja.
 * @param nombre nombre de la hoja./*from  w ww. j  a v  a 2  s.c  om*/
 */
private File crearExcel(List lista, String nombre) {
    try {
        HSSFWorkbook libro = new HSSFWorkbook();
        // Se crea una hoja dentro del libro
        HSSFSheet hoja = libro.createSheet();
        int filas = lista.size();
        for (int i = 0; i < filas; i++) {
            List<Object> fila = (List<Object>) lista.get(i);
            Row row = hoja.createRow((short) i);
            int j = 0;
            for (Object token : fila) {
                createCell(row, j, token);
                j = j + 1;
            }
        }
        File tempFile = File.createTempFile(nombre, null);
        tempFile.deleteOnExit();
        try (FileOutputStream archivo = new FileOutputStream(tempFile)) {
            libro.write(archivo);
        }
        System.out.println("Se exportaron los " + nombre);
        return tempFile;
    } catch (IOException ex) {
        System.out.println("Error exportando " + nombre + ": " + ex);
        return null;
    }

}

From source file:facebook.metrics.FacebookMetricsGroup.java

public static void main(String[] args) {

    try {//from  w  ww  .j a v a 2 s.com
        // Se crea el libro
        HSSFWorkbook libro = new HSSFWorkbook();

        // Se crea una hoja dentro del libro
        HSSFSheet hoja = libro.createSheet();

        // Se crea una fila dentro de la hoja
        HSSFRow fila = hoja.createRow(0);

        // Se crea una celda dentro de la fila
        HSSFCell celda = fila.createCell(1);

        // Se crea el contenido de la celda y se mete en ella.
        HSSFRichTextString texto = new HSSFRichTextString("Metricas de Grupo Cinepolitos");
        celda.setCellValue(texto);
        /************************************/
        /*Mongo DB Conection*/
        MongoClient mongoClient = new MongoClient("localhost", 27017);

        DB db = mongoClient.getDB("JavaMongoFacebookGroup");

        DBCollection datos = db.getCollection("Datos");

        /********************/
        Facebook facebook = new FacebookFactory().getInstance();

        facebook.setOAuthAppId("603320016402931", "202694064e7a4e77f0c0042b1a16ebd4");

        System.out.println(facebook.getOAuthAppAccessToken().getToken());

        ResponseList<Post> feedX = facebook.getGroupFeed("17761155026", new Reading().limit(1135));

        List<ResponseList<Post>> X = new ArrayList<ResponseList<Post>>();

        do {

            X.add(feedX);
            Paging<Post> pag1 = feedX.getPaging();
            feedX = facebook.fetchNext(pag1);

        } while (feedX.getPaging() != null);

        fila = hoja.createRow(2);
        celda = fila.createCell(1);
        celda.setCellValue(new HSSFRichTextString("Id Post:"));
        celda = fila.createCell(2);
        celda.setCellValue(new HSSFRichTextString("Fecha del Post:"));
        celda = fila.createCell(3);
        celda.setCellValue(new HSSFRichTextString("Usuario que posteo:"));
        celda = fila.createCell(4);
        celda.setCellValue(new HSSFRichTextString("Post:"));
        celda = fila.createCell(5);
        celda.setCellValue(new HSSFRichTextString("# de Likes del Post:"));
        celda = fila.createCell(6);
        celda.setCellValue(new HSSFRichTextString("# de Comentarios del Post:"));
        celda = fila.createCell(7);
        celda.setCellValue(new HSSFRichTextString("Comentarios del Post:"));

        int filasX = 3;

        for (int j = 0; j < X.size(); j++) {

            ResponseList<Post> feed = X.get(j);
            System.out.println(feed.size());

            for (int i = 0; i < feed.size(); i++) {

                System.out.println("Feed:  " + i);

                BasicDBObject obj = new BasicDBObject();
                ResponseList<Like> likes = facebook.getPostLikes(feed.get(i).getId(),
                        new Reading().limit(1135));
                ResponseList<Comment> comments = facebook.getPostComments(feed.get(i).getId(),
                        new Reading().limit(1135));

                obj.append("idPost", feed.get(i).getId() + "");

                if (feed.get(i).getMessage() == null) {
                    obj.append("Post", "   ");
                    //System.out.println("Null");
                } else {
                    obj.append("Post", feed.get(i).getMessage());
                }

                obj.append("Likes", likes.size() + "");
                obj.append("Comments", comments.size() + "");

                datos.insert(obj);

                fila = hoja.createRow(filasX);
                celda = fila.createCell(1);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getId() + ""));
                celda = fila.createCell(2);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getCreatedTime() + ""));
                celda = fila.createCell(3);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getFrom().getName()));
                celda = fila.createCell(4);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getMessage()));
                celda = fila.createCell(5);
                celda.setCellValue(new HSSFRichTextString(likes.size() + ""));
                celda = fila.createCell(6);
                celda.setCellValue(new HSSFRichTextString(comments.size() + ""));

                filasX++;

                for (int y = 0; y < comments.size(); y++) {
                    fila = hoja.createRow(filasX);
                    celda = fila.createCell(7);
                    celda.setCellValue(new HSSFRichTextString(comments.get(y).getMessage() + ""));
                    filasX++;
                }

            }
            System.out.println();

        }

        FileOutputStream elFichero = new FileOutputStream("Metricas_Cinepolitos.xls");
        libro.write(elFichero);
        elFichero.close();

    } catch (Exception e) {
        System.err.println("Fatal Error:   " + e);
    }

}

From source file:facebook.metrics.FacebookMetricsPage.java

public static void main(String[] args) throws IOException {
    int varFeed = 0;
    int filasX = 0;
    HSSFRow fila = null;// w  w w  . ja v a2s  .  co m
    HSSFRow filam = null;
    HSSFCell celda = null;
    List<ResponseList<Post>> X = null;
    int j = 0;
    int i = 0;
    HSSFSheet hoja = null;
    Facebook facebook = null;
    HSSFWorkbook libro = null;
    try {
        // Se crea el libro
        libro = new HSSFWorkbook();

        hoja = libro.createSheet();

        fila = hoja.createRow(0);

        celda = fila.createCell(1);

        HSSFRichTextString texto = new HSSFRichTextString("Metricas de Infinitum");
        celda.setCellValue(texto);
        /************************************/
        /*Mongo DB Conection*/
        MongoClient mongoClient = new MongoClient("localhost", 27017);

        DB db = mongoClient.getDB("JavaMongoFacebookGroup");

        DBCollection datos = db.getCollection("Datos");

        /********************/
        facebook = new FacebookFactory().getInstance();

        facebook.setOAuthAppId("603320016402931", "202694064e7a4e77f0c0042b1a16ebd4");

        System.out.println(facebook.getOAuthAppAccessToken().getToken());

        ResponseList<Post> feedX = facebook.getFeed("216786388331757", new Reading().limit(1000));

        X = new ArrayList<ResponseList<Post>>();
        int ui = 0;
        do {

            X.add(feedX);
            Paging<Post> pag1 = feedX.getPaging();
            feedX = facebook.fetchNext(pag1);
            System.out.println("" + ui);
            ui++;
        } while (feedX.getPaging() != null && ui < 25);

        fila = hoja.createRow(2);

        celda = fila.createCell(1);
        celda.setCellValue(new HSSFRichTextString("Id Post:"));
        celda = fila.createCell(2);
        celda.setCellValue(new HSSFRichTextString("Fecha del Post:"));
        celda = fila.createCell(3);
        celda.setCellValue(new HSSFRichTextString("Usuario que posteo:"));
        celda = fila.createCell(4);
        celda.setCellValue(new HSSFRichTextString("Post:"));
        celda = fila.createCell(5);
        celda.setCellValue(new HSSFRichTextString("# de Likes del Post:"));
        celda = fila.createCell(6);
        celda.setCellValue(new HSSFRichTextString("# de Comentarios del Post:"));
        celda = fila.createCell(7);
        celda.setCellValue(new HSSFRichTextString("Comentarios del Post:"));
        celda = fila.createCell(8);
        celda.setCellValue(new HSSFRichTextString("Tipo de Post:"));

        filasX = 4;

        for (j = 0; j < X.size(); j++) {

            ResponseList<Post> feed = X.get(j);

            System.out.println(feed.size());

            for (i = 0; i < feed.size(); i++) {

                System.out.println("Feed:  " + i);

                BasicDBObject obj = new BasicDBObject();
                ResponseList<Like> likes = facebook.getPostLikes(feed.get(i).getId(),
                        new Reading().limit(1135));
                ResponseList<Comment> comments = facebook.getPostComments(feed.get(i).getId(),
                        new Reading().limit(1135));

                obj.append("idPost", feed.get(i).getId() + "");

                if (feed.get(i).getMessage() == null) {
                    obj.append("Post", "   ");
                    //System.out.println("Null");
                } else {
                    obj.append("Post", feed.get(i).getMessage());
                }

                obj.append("Likes", likes.size() + "");
                obj.append("Comments", comments.size() + "");

                datos.insert(obj);

                filam = hoja.createRow(filasX);
                celda = filam.createCell(1);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getId() + ""));
                celda = filam.createCell(2);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getCreatedTime() + ""));
                celda = filam.createCell(3);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getFrom().getName()));
                celda = filam.createCell(4);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getMessage()));
                celda = filam.createCell(5);
                celda.setCellValue(new HSSFRichTextString(likes.size() + ""));
                celda = filam.createCell(6);
                celda.setCellValue(new HSSFRichTextString(comments.size() + ""));
                celda = filam.createCell(8);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getType() + ""));

                filasX++;

                for (int y = 0; y < comments.size(); y++) {
                    filam = hoja.createRow(filasX);
                    celda = filam.createCell(7);
                    celda.setCellValue(new HSSFRichTextString(comments.get(y).getMessage() + ""));
                    filasX++;
                }

            }
        }

        FileOutputStream elFichero = new FileOutputStream("Metricas_Infinitum.xls");
        libro.write(elFichero);
        elFichero.close();

    } catch (Exception e) {

        System.err.println("Fatal Error:   " + e);
        FacebookMetricsPage s = new FacebookMetricsPage();

        s.porsi(i, j, filasX + 1, filam, celda, facebook, X, hoja, libro);

    }

}

From source file:facebook.metrics.FacebookMetricsPage.java

public void porsi(int ii, int jj, int filasX, HSSFRow fila, HSSFCell celda, Facebook facebook,
        List<ResponseList<Post>> X, HSSFSheet hoja, HSSFWorkbook libro) throws IOException {

    try {// ww  w . j a  va  2 s. c  o  m

        for (int j = jj; j < X.size(); j++) {

            ResponseList<Post> feed = X.get(j);

            System.out.println(feed.size());

            for (int i = ii; i < feed.size(); i++) {

                System.out.println("Feed:  " + i);

                BasicDBObject obj = new BasicDBObject();
                ResponseList<Like> likes = facebook.getPostLikes(feed.get(i).getId(),
                        new Reading().limit(1135));
                ResponseList<Comment> comments = facebook.getPostComments(feed.get(i).getId(),
                        new Reading().limit(1135));

                //                            obj.append("idPost",feed.get(i).getId()+"");
                //
                //                            if(feed.get(i).getMessage()==null){
                //                                obj.append("Post","   ");
                //                                //System.out.println("Null");
                //                            }else{
                //                                obj.append("Post",feed.get(i).getMessage());
                //                            }
                //
                //                            obj.append("Likes",likes.size()+"");
                //                            obj.append("Comments",comments.size()+"");
                //
                //                            datos.insert(obj);

                fila = hoja.createRow(filasX);
                celda = fila.createCell(1);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getId() + ""));
                celda = fila.createCell(2);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getCreatedTime() + ""));
                celda = fila.createCell(3);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getFrom().getName()));
                celda = fila.createCell(4);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getMessage()));
                celda = fila.createCell(5);
                celda.setCellValue(new HSSFRichTextString(likes.size() + ""));
                celda = fila.createCell(6);
                celda.setCellValue(new HSSFRichTextString(comments.size() + ""));
                celda = fila.createCell(8);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getType() + ""));

                filasX++;

                for (int y = 0; y < comments.size(); y++) {
                    fila = hoja.createRow(filasX);
                    celda = fila.createCell(7);
                    celda.setCellValue(new HSSFRichTextString(comments.get(y).getMessage() + ""));
                    filasX++;
                }

            }
        }

        FileOutputStream elFichero = new FileOutputStream("Metricas_Infinitum.xls");
        libro.write(elFichero);
        elFichero.close();

    } catch (Exception e) {
        System.err.println("Fatal Error 2:   " + e);
        FileOutputStream elFichero;
        try {
            elFichero = new FileOutputStream("Metricas_Infinitum.xls");
            libro.write(elFichero);
            elFichero.close();
        } catch (FileNotFoundException ex) {
            Logger.getLogger(FacebookMetricsPage.class.getName()).log(Level.SEVERE, null, ex);
        }

    }

}

From source file:facebook.metrics.FacebookMetricsPage2.java

public static void main(String[] args) throws IOException {
    int varFeed = 0;
    int filasX = 0;
    HSSFRow fila = null;/* w  ww .ja  va 2s. c o m*/
    HSSFCell celda = null;
    List<ResponseList<Post>> X = null;
    int j = 0;
    int i = 0;
    HSSFSheet hoja = null;
    Facebook facebook = null;
    HSSFWorkbook libro = null;
    try {
        // Se crea el libro
        libro = new HSSFWorkbook();

        // Se crea una hoja dentro del libro
        hoja = libro.createSheet();

        // Se crea una fila dentro de la hoja
        fila = hoja.createRow(0);

        // Se crea una celda dentro de la fila
        celda = fila.createCell(1);

        // Se crea el contenido de la celda y se mete en ella.
        HSSFRichTextString texto = new HSSFRichTextString("Metricas de Sony Futbol");
        celda.setCellValue(texto);
        /************************************/
        /*Mongo DB Conection*/
        MongoClient mongoClient = new MongoClient("localhost", 27017);

        DB db = mongoClient.getDB("JavaMongoFacebookGroup");

        DBCollection datos = db.getCollection("Datos");

        /********************/
        facebook = new FacebookFactory().getInstance();

        facebook.setOAuthAppId("603320016402931", "202694064e7a4e77f0c0042b1a16ebd4");

        System.out.println(facebook.getOAuthAppAccessToken().getToken());

        ResponseList<Post> feedX = facebook.getFeed("120472297979101", new Reading().limit(1000));

        X = new ArrayList<ResponseList<Post>>();
        int ui = 0;
        do {

            X.add(feedX);
            Paging<Post> pag1 = feedX.getPaging();
            feedX = facebook.fetchNext(pag1);
            System.out.println("" + ui);
            ui++;
        } while (feedX.getPaging() != null && ui < 5);

        fila = hoja.createRow(2);
        celda = fila.createCell(1);
        celda.setCellValue(new HSSFRichTextString("Id Post:"));
        celda = fila.createCell(2);
        celda.setCellValue(new HSSFRichTextString("Fecha del Post:"));
        celda = fila.createCell(3);
        celda.setCellValue(new HSSFRichTextString("Usuario que posteo:"));
        celda = fila.createCell(4);
        celda.setCellValue(new HSSFRichTextString("Post:"));
        celda = fila.createCell(5);
        celda.setCellValue(new HSSFRichTextString("# de Likes del Post:"));
        celda = fila.createCell(6);
        celda.setCellValue(new HSSFRichTextString("# de Comentarios del Post:"));
        celda = fila.createCell(7);
        celda.setCellValue(new HSSFRichTextString("Comentarios del Post:"));
        celda = fila.createCell(8);
        celda.setCellValue(new HSSFRichTextString("Tipo de Post:"));

        filasX = 3;

        for (j = 0; j < X.size(); j++) {

            ResponseList<Post> feed = X.get(j);

            System.out.println(feed.size());

            for (i = 0; i < feed.size(); i++) {

                System.out.println("Feed:  " + i);

                BasicDBObject obj = new BasicDBObject();
                ResponseList<Like> likes = facebook.getPostLikes(feed.get(i).getId(),
                        new Reading().limit(1135));
                ResponseList<Comment> comments = facebook.getPostComments(feed.get(i).getId(),
                        new Reading().limit(1135));

                obj.append("idPost", feed.get(i).getId() + "");

                if (feed.get(i).getMessage() == null) {
                    obj.append("Post", "   ");
                    //System.out.println("Null");
                } else {
                    obj.append("Post", feed.get(i).getMessage());
                }

                obj.append("Likes", likes.size() + "");
                obj.append("Comments", comments.size() + "");

                datos.insert(obj);

                fila = hoja.createRow(filasX);
                celda = fila.createCell(1);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getId() + ""));
                celda = fila.createCell(2);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getCreatedTime() + ""));
                celda = fila.createCell(3);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getFrom().getName()));
                celda = fila.createCell(4);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getMessage()));
                celda = fila.createCell(5);
                celda.setCellValue(new HSSFRichTextString(likes.size() + ""));
                celda = fila.createCell(6);
                celda.setCellValue(new HSSFRichTextString(comments.size() + ""));
                celda = fila.createCell(8);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getType() + ""));

                filasX++;

                for (int y = 0; y < comments.size(); y++) {
                    fila = hoja.createRow(filasX);
                    celda = fila.createCell(7);
                    celda.setCellValue(new HSSFRichTextString(comments.get(y).getMessage() + ""));
                    filasX++;
                }

            }
        }

        FileOutputStream elFichero = new FileOutputStream("Metricas_SonyFutbol.xls");
        libro.write(elFichero);
        elFichero.close();

    } catch (Exception e) {

        System.err.println("Fatal Error:   " + e);
        FacebookMetricsPage s = new FacebookMetricsPage();

        s.porsi(i, j, filasX, fila, celda, facebook, X, hoja, libro);

    }

}

From source file:facebook.metrics.FacebookMetricsPage2.java

public void porsi(int ii, int jj, int filasX, HSSFRow fila, HSSFCell celda, Facebook facebook,
        List<ResponseList<Post>> X, HSSFSheet hoja, HSSFWorkbook libro) throws IOException {

    try {/*from   w  w w . j a  va 2s .c  o  m*/

        for (int j = jj; j < X.size(); j++) {

            ResponseList<Post> feed = X.get(j);

            System.out.println(feed.size());

            for (int i = ii; i < feed.size(); i++) {

                System.out.println("Feed:  " + i);

                BasicDBObject obj = new BasicDBObject();
                ResponseList<Like> likes = facebook.getPostLikes(feed.get(i).getId(),
                        new Reading().limit(1135));
                ResponseList<Comment> comments = facebook.getPostComments(feed.get(i).getId(),
                        new Reading().limit(1135));

                //                            obj.append("idPost",feed.get(i).getId()+"");
                //
                //                            if(feed.get(i).getMessage()==null){
                //                                obj.append("Post","   ");
                //                                //System.out.println("Null");
                //                            }else{
                //                                obj.append("Post",feed.get(i).getMessage());
                //                            }
                //
                //                            obj.append("Likes",likes.size()+"");
                //                            obj.append("Comments",comments.size()+"");
                //
                //                            datos.insert(obj);

                fila = hoja.createRow(filasX);
                celda = fila.createCell(1);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getId() + ""));
                celda = fila.createCell(2);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getCreatedTime() + ""));
                celda = fila.createCell(3);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getFrom().getName()));
                celda = fila.createCell(4);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getMessage()));
                celda = fila.createCell(5);
                celda.setCellValue(new HSSFRichTextString(likes.size() + ""));
                celda = fila.createCell(6);
                celda.setCellValue(new HSSFRichTextString(comments.size() + ""));
                celda = fila.createCell(8);
                celda.setCellValue(new HSSFRichTextString(feed.get(i).getType() + ""));

                filasX++;

                for (int y = 0; y < comments.size(); y++) {
                    fila = hoja.createRow(filasX);
                    celda = fila.createCell(7);
                    celda.setCellValue(new HSSFRichTextString(comments.get(y).getMessage() + ""));
                    filasX++;
                }

            }
        }

        FileOutputStream elFichero = new FileOutputStream("Metricas_SonyFutbol.xls");
        libro.write(elFichero);
        elFichero.close();

    } catch (Exception e) {
        System.err.println("Fatal Error 2:   " + e);
        FileOutputStream elFichero;
        try {
            elFichero = new FileOutputStream("Metricas_SonyFutbol.xls");
            libro.write(elFichero);
            elFichero.close();
        } catch (FileNotFoundException ex) {
            Logger.getLogger(FacebookMetricsPage.class.getName()).log(Level.SEVERE, null, ex);
        }

    }

}

From source file:featurescomparison.workingwithformattingfeatures.cellalignment.java.ApacheCellAlignment.java

License:Apache License

public static void main(String[] args) throws IOException {
    String dataPath = "src/featurescomparison/workingwithformattingfeatures/cellalignment/data/";

    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet("new sheet");
    HSSFRow row = sheet.createRow(2);//  w  ww.  j ava 2  s. c o m
    createCell(wb, row, 0, HSSFCellStyle.ALIGN_CENTER);
    createCell(wb, row, 1, HSSFCellStyle.ALIGN_CENTER_SELECTION);
    createCell(wb, row, 2, HSSFCellStyle.ALIGN_FILL);
    createCell(wb, row, 3, HSSFCellStyle.ALIGN_GENERAL);
    createCell(wb, row, 4, HSSFCellStyle.ALIGN_JUSTIFY);
    createCell(wb, row, 5, HSSFCellStyle.ALIGN_LEFT);
    createCell(wb, row, 6, HSSFCellStyle.ALIGN_RIGHT);

    // Write the output to a file
    FileOutputStream fileOut = new FileOutputStream(dataPath + "ApahceAlignment.xls");
    wb.write(fileOut);
    fileOut.close();
    System.out.println("Done.");
}