Example usage for org.apache.poi.xssf.usermodel XSSFWorkbook createSheet

Introduction

In this page you can find the example usage for org.apache.poi.xssf.usermodel XSSFWorkbook createSheet.

Prototype

@Override
public XSSFSheet createSheet() 

Source Link

Document

Create an XSSFSheet for this workbook, adds it to the sheets and returns the high level representation.

Usage

From source file:vistas.MantenedorReportes.java

private void btnExportarProductosActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnExportarProductosActionPerformed
    // TODO add your handling code here:
    Thread t;/*from w  w w  .  ja v  a  2 s . c  o  m*/
    t = new Thread() {
        @Override
        public void run() {
            XSSFWorkbook workbook = new XSSFWorkbook();
            XSSFSheet hoja = workbook.createSheet();

            XSSFRow fila = hoja.createRow(0);
            fila.createCell(0).setCellValue("N");
            fila.createCell(1).setCellValue("Codigo");
            fila.createCell(2).setCellValue("Nombre");
            fila.createCell(3).setCellValue("Marca");
            fila.createCell(4).setCellValue("Precio Compra");
            fila.createCell(5).setCellValue("Precio Venta");
            fila.createCell(6).setCellValue("Utilidad Unitaria");
            fila.createCell(7).setCellValue("Cantidad vendida");
            fila.createCell(8).setCellValue("Utilidad Final");
            fila.createCell(9).setCellValue("Periodo anterior");

            pbProductos.setMaximum(tbGastosExtras.getRowCount());
            XSSFRow filas;
            Rectangle rect;

            for (int i = 0; i < tbProductos.getRowCount(); i++) {
                rect = tbProductos.getCellRect(i, 0, true);

                tbProductos.scrollRectToVisible(rect);

                tbProductos.setRowSelectionInterval(i, i);

                pbProductos.setValue((i + 1));
                filas = hoja.createRow((i + 1));

                filas.createCell(0).setCellValue(tbProductos.getValueAt(i, 0).toString());
                filas.createCell(1).setCellValue(tbProductos.getValueAt(i, 1).toString());
                filas.createCell(2).setCellValue(tbProductos.getValueAt(i, 2).toString());
                filas.createCell(3).setCellValue(tbProductos.getValueAt(i, 3).toString());
                filas.createCell(4).setCellValue(tbProductos.getValueAt(i, 4).toString());
                filas.createCell(5).setCellValue(tbProductos.getValueAt(i, 5).toString());
                filas.createCell(6).setCellValue(tbProductos.getValueAt(i, 6).toString());
                filas.createCell(7).setCellValue(tbProductos.getValueAt(i, 7).toString());
                filas.createCell(8).setCellValue(tbProductos.getValueAt(i, 8).toString());
                filas.createCell(9).setCellValue(tbProductos.getValueAt(i, 9).toString());

            }

            pbProductos.setValue(0);
            try {

                workbook.write(new FileOutputStream(new File("Excel.xlsx")));
                Desktop.getDesktop().open(new File("Excel.xlsx"));

            } catch (Exception e) {

            }

        }
    };
    t.start();

}

---

From source file:vistas.MantenedorReportes.java

private void btnExportarVendedoresActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnExportarVendedoresActionPerformed
    // TODO add your handling code here:
    Thread t;//from w ww.ja  va2 s .co m
    t = new Thread() {
        @Override
        public void run() {
            XSSFWorkbook workbook = new XSSFWorkbook();
            XSSFSheet hoja = workbook.createSheet();

            XSSFRow fila = hoja.createRow(0);
            fila.createCell(0).setCellValue("N");
            fila.createCell(1).setCellValue("Vendedor");
            fila.createCell(2).setCellValue("Ventas totales");
            fila.createCell(3).setCellValue("Utilidades");
            fila.createCell(4).setCellValue("Das trabajados");
            fila.createCell(5).setCellValue("Horas trabajadas");

            pbVendedores.setMaximum(tbVendedores.getRowCount());
            XSSFRow filas;
            Rectangle rect;

            for (int i = 0; i < tbVendedores.getRowCount(); i++) {
                rect = tbVendedores.getCellRect(i, 0, true);

                tbVendedores.scrollRectToVisible(rect);

                tbVendedores.setRowSelectionInterval(i, i);

                pbVendedores.setValue((i + 1));
                filas = hoja.createRow((i + 1));

                filas.createCell(0).setCellValue(tbVendedores.getValueAt(i, 0).toString());
                filas.createCell(1).setCellValue(tbVendedores.getValueAt(i, 1).toString());
                filas.createCell(2).setCellValue(tbVendedores.getValueAt(i, 2).toString());
                filas.createCell(3).setCellValue(tbVendedores.getValueAt(i, 3).toString());
                filas.createCell(4).setCellValue(tbVendedores.getValueAt(i, 4).toString());
                filas.createCell(5).setCellValue(tbVendedores.getValueAt(i, 5).toString());

            }

            pbVendedores.setValue(0);
            try {

                workbook.write(new FileOutputStream(new File("Excel.xlsx")));
                Desktop.getDesktop().open(new File("Excel.xlsx"));

            } catch (Exception e) {

            }

        }
    };
    t.start();
}

---

From source file:vistas.MantenedorReportes.java

private void btnExportarInventarioActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnExportarInventarioActionPerformed
    // TODO add your handling code here:
    Thread t;/*w ww.j  a  va2 s.  c o m*/
    t = new Thread() {
        @Override
        public void run() {
            XSSFWorkbook workbook = new XSSFWorkbook();
            XSSFSheet hoja = workbook.createSheet();

            XSSFRow fila = hoja.createRow(0);
            fila.createCell(0).setCellValue("N");
            fila.createCell(1).setCellValue("Codigo");
            fila.createCell(2).setCellValue("Nombre");
            fila.createCell(3).setCellValue("Marca");
            fila.createCell(4).setCellValue("Stock");

            pbInventario.setMaximum(tbInventario.getRowCount());
            XSSFRow filas;
            Rectangle rect;

            for (int i = 0; i < tbInventario.getRowCount(); i++) {
                rect = tbInventario.getCellRect(i, 0, true);

                tbInventario.scrollRectToVisible(rect);

                tbInventario.setRowSelectionInterval(i, i);

                pbInventario.setValue((i + 1));
                filas = hoja.createRow((i + 1));

                filas.createCell(0).setCellValue(tbInventario.getValueAt(i, 0).toString());
                filas.createCell(1).setCellValue(tbInventario.getValueAt(i, 1).toString());
                filas.createCell(2).setCellValue(tbInventario.getValueAt(i, 2).toString());
                filas.createCell(3).setCellValue(tbInventario.getValueAt(i, 3).toString());
                filas.createCell(4).setCellValue(tbInventario.getValueAt(i, 4).toString());

            }

            pbInventario.setValue(0);
            try {

                workbook.write(new FileOutputStream(new File("Excel.xlsx")));
                Desktop.getDesktop().open(new File("Excel.xlsx"));

            } catch (Exception e) {

            }

        }
    };
    t.start();
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• »