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

Introduction

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

Prototype

public XSSFWorkbook() 

Source Link

Document

Create a new SpreadsheetML workbook.

Usage

From source file:cherry.goods.excel.ExcelWriterTest.java

License:Apache License

@Test
public void testWrite_2_COLS_2_ROWS_WITH_NULL() throws IOException {
    try (Workbook workbook = new XSSFWorkbook()) {
        // // ww w  .  j  a v  a2  s  .co m
        Sheet sheet = workbook.createSheet("CREATED 0");
        Row row0 = sheet.createRow(0);
        row0.createCell(0);
        row0.createCell(1);

        // 
        try (ExcelWriter writer = new ExcelWriter(workbook)) {
            writer.write("CELL 00", null);
            writer.write(null, "CELL 11");

            assertEquals("CELL 00", sheet.getRow(0).getCell(0).getStringCellValue());
            assertNull(sheet.getRow(0).getCell(1));
            assertNull(sheet.getRow(1).getCell(0));
            assertEquals("CELL 11", sheet.getRow(1).getCell(1).getStringCellValue());
        }
    }
}

---

From source file:cherry.goods.excel.ExcelWriterTest.java

License:Apache License

@Test
public void testWrite_WITH_OFFSET() throws IOException {
    try (Workbook workbook = new XSSFWorkbook()) {
        // //from  w  w w  .j a  va 2 s  .  c o  m
        Sheet sheet = workbook.createSheet("CREATED 0");

        // 
        try (ExcelWriter writer = new ExcelWriter(workbook)) {
            writer.write(2, "CELL 00", "CELL 01");

            assertEquals("CELL 00", sheet.getRow(0).getCell(2).getStringCellValue());
            assertEquals("CELL 01", sheet.getRow(0).getCell(3).getStringCellValue());
        }
    }
}

---

From source file:cherry.goods.excel.ExcelWriterTest.java

License:Apache License

@Test
public void testSkipRows() throws IOException {
    try (Workbook workbook = new XSSFWorkbook()) {
        // //  w w w . j a  va2 s. co m
        Sheet sheet = workbook.createSheet("CREATED 0");

        // 
        try (ExcelWriter writer = new ExcelWriter(workbook)) {
            writer.write("CELL 00", "CELL 01");
            writer.skipRows(1);
            writer.write("CELL 20", "CELL 21");

            assertEquals("CELL 00", sheet.getRow(0).getCell(0).getStringCellValue());
            assertEquals("CELL 01", sheet.getRow(0).getCell(1).getStringCellValue());
            assertNull(sheet.getRow(1));
            assertEquals("CELL 20", sheet.getRow(2).getCell(0).getStringCellValue());
            assertEquals("CELL 21", sheet.getRow(2).getCell(1).getStringCellValue());
        }
    }
}

---

From source file:chocanproject.MemberReportGUI.java

private void writeToExcel() {
    XSSFWorkbook wb = new XSSFWorkbook();
    XSSFSheet ws = wb.createSheet();/*from w ww .  j ava2 s . c om*/
    //Load data to Treemap
    TreeMap<String, Object[]> data = new TreeMap<>();
    //Add column headers
    data.put("-1",
            new Object[] { dm.getColumnName(0), dm.getColumnName(1), dm.getColumnName(2), dm.getColumnName(3),
                    dm.getColumnName(4), dm.getColumnName(5), dm.getColumnName(6), dm.getColumnName(7),
                    dm.getColumnName(8), dm.getColumnName(9), dm.getColumnName(10) });
    //Add rows and cells
    for (int i = 0; i < dm.getRowCount(); i++) {
        data.put(Integer.toString(i),
                new Object[] { getCellValue(i, 0), getCellValue(i, 1), getCellValue(i, 2), getCellValue(i, 3),
                        getCellValue(i, 4), getCellValue(i, 5), getCellValue(i, 6), getCellValue(i, 7),
                        getCellValue(i, 8), getCellValue(i, 9), getCellValue(i, 10) });
    }
    //write to excel file
    Set<String> ids = data.keySet();
    XSSFRow row;
    int rowID = 0;
    for (String key : ids) {
        row = ws.createRow(rowID++);
        //get data as per key
        Object[] values = data.get(key);
        int cellID = 0;
        for (Object o : values) {
            Cell cell = row.createCell(cellID++);
            cell.setCellValue(o.toString());
        }
    }
    //write to filesystem
    try {
        String MName, fName;
        DateFormat dateFormat = new SimpleDateFormat("MM-dd-YYYY");
        Date date = new Date();
        String Cdate;
        MName = fn.toString();
        Cdate = (dateFormat.format(date));
        fName = MName + "_" + Cdate;
        FileOutputStream fos = new FileOutputStream(new File("D:/Excel/" + fName + ".xlsx"));
        wb.write(fos);
        fos.close();
    } catch (FileNotFoundException ex) {
        ex.printStackTrace();
        // Logger.getLogger(WorkBookNSheet.class.getName()).log(Level.SEVERE, null, ex);
    } catch (IOException ex) {
        ex.printStackTrace();
        //Logger.getLogger(MemberReportGUI.class.getName()).log(Level.SEVERE, null, ex);

    }
}

---

From source file:chocanproject.ProviderReportGUI.java

private void writeToExcel() {
    XSSFWorkbook wb = new XSSFWorkbook();
    XSSFSheet ws = wb.createSheet();//from   w  w w  .j a  v a  2s. c  o  m
    //Load data to Treemap
    TreeMap<String, Object[]> data = new TreeMap<>();
    //Add column headers
    data.put("-1",
            new Object[] { dp.getColumnName(0), dp.getColumnName(1), dp.getColumnName(2), dp.getColumnName(3),
                    dp.getColumnName(4), dp.getColumnName(5), dp.getColumnName(6), dp.getColumnName(7),
                    dp.getColumnName(8), dp.getColumnName(9), dp.getColumnName(10), dp.getColumnName(11),
                    dp.getColumnName(12), dp.getColumnName(13) });
    //Add rows and cells
    for (int i = 0; i < dp.getRowCount(); i++) {
        data.put(Integer.toString(i),
                new Object[] { getCellValue(i, 0), getCellValue(i, 1), getCellValue(i, 2), getCellValue(i, 3),
                        getCellValue(i, 4), getCellValue(i, 5), getCellValue(i, 6), getCellValue(i, 7),
                        getCellValue(i, 8), getCellValue(i, 9), getCellValue(i, 10), getCellValue(i, 11),
                        getCellValue(i, 12), getCellValue(i, 13) });
    }
    //write to excel file
    Set<String> ids = data.keySet();
    XSSFRow row;
    int rowID = 0;
    for (String key : ids) {
        row = ws.createRow(rowID++);
        //get data as per key
        Object[] values = data.get(key);
        int cellID = 0;
        for (Object o : values) {
            Cell cell = row.createCell(cellID++);
            cell.setCellValue(o.toString());
        }
    }
    //write to filesystem
    try {
        String fName;
        DateFormat dateFormat = new SimpleDateFormat("MM-dd-YYYY");
        Date date = new Date();
        String Cdate;
        Cdate = (dateFormat.format(date));
        fName = pfn + "_" + Cdate;
        FileOutputStream fos = new FileOutputStream(new File("D:/Excel/" + fName + ".xlsx"));
        wb.write(fos);
        fos.close();
    } catch (FileNotFoundException ex) {
        ex.printStackTrace();
        // Logger.getLogger(WorkBookNSheet.class.getName()).log(Level.SEVERE, null, ex);
    } catch (IOException ex) {
        ex.printStackTrace();
        //Logger.getLogger(MemberReportGUI.class.getName()).log(Level.SEVERE, null, ex);

    }
}

---

From source file:chocanproject.SummaryReports.java

private void writeToExcel() {
    XSSFWorkbook wb = new XSSFWorkbook();
    XSSFSheet ws = wb.createSheet();/*from   w w w  .jav a 2s. c o m*/
    //Load data to Treemap
    TreeMap<String, Object[]> data = new TreeMap<>();
    //Add column headers
    data.put("-1", new Object[] { dm.getColumnName(0), dm.getColumnName(1), dm.getColumnName(2) });
    //Add rows and cells
    for (int i = 0; i < dm.getRowCount(); i++) {
        data.put(Integer.toString(i),
                new Object[] { getCellValue(i, 0), getCellValue(i, 1), getCellValue(i, 2) });
    }
    //write to excel file
    Set<String> ids = data.keySet();
    XSSFRow row;
    int rowID = 0;
    for (String key : ids) {
        row = ws.createRow(rowID++);
        //get data as per key
        Object[] values = data.get(key);
        int cellID = 0;
        for (Object o : values) {
            Cell cell = row.createCell(cellID++);
            cell.setCellValue(o.toString());
        }
    }
    //write to filesystem
    try {
        DateFormat dateFormat = new SimpleDateFormat("MM-dd-YYYY");
        Date date = new Date();
        String Cdate;
        Cdate = (dateFormat.format(date));
        FileOutputStream fos = new FileOutputStream(
                new File("D:/Excel/SummaryReport-ToBePaid" + Cdate + ".xlsx"));
        wb.write(fos);
        fos.close();
    } catch (FileNotFoundException ex) {
        ex.printStackTrace();
        // Logger.getLogger(WorkBookNSheet.class.getName()).log(Level.SEVERE, null, ex);
    } catch (IOException ex) {
        ex.printStackTrace();
        //Logger.getLogger(MemberReportGUI.class.getName()).log(Level.SEVERE, null, ex);

    }
}

---

From source file:chocanproject.TotalSummaryReport.java

private void writeToExcel() {
    XSSFWorkbook wb = new XSSFWorkbook();
    XSSFSheet ws = wb.createSheet();//from   ww  w . j ava2  s  .  co m
    //Load data to Treemap
    TreeMap<String, Object[]> data = new TreeMap<>();
    //Add column headers
    data.put("-1", new Object[] { dm.getColumnName(0), dm.getColumnName(1), dm.getColumnName(2) });
    //Add rows and cells
    for (int i = 0; i < dm.getRowCount(); i++) {
        data.put(Integer.toString(i),
                new Object[] { getCellValue(i, 0), getCellValue(i, 1), getCellValue(i, 2) });
    }
    //write to excel file
    Set<String> ids = data.keySet();
    XSSFRow row;
    int rowID = 0;
    for (String key : ids) {
        row = ws.createRow(rowID++);
        //get data as per key
        Object[] values = data.get(key);
        int cellID = 0;
        for (Object o : values) {
            Cell cell = row.createCell(cellID++);
            cell.setCellValue(o.toString());
        }
    }
    //write to filesystem
    try {
        DateFormat dateFormat = new SimpleDateFormat("MM-dd-YYYY");
        Date date = new Date();
        String Cdate;
        Cdate = (dateFormat.format(date));
        FileOutputStream fos = new FileOutputStream(new File("D:/Excel/TotalSummaryReport" + Cdate + ".xlsx"));
        wb.write(fos);
        fos.close();
    } catch (FileNotFoundException ex) {
        ex.printStackTrace();
        // Logger.getLogger(WorkBookNSheet.class.getName()).log(Level.SEVERE, null, ex);
    } catch (IOException ex) {
        ex.printStackTrace();
        //Logger.getLogger(MemberReportGUI.class.getName()).log(Level.SEVERE, null, ex);

    }
}

---

From source file:cib.ladnyik.MyVaadinApplication.java

License:Apache License

@Override
public void init() {
    Workbook wb = new XSSFWorkbook();
    window = new Window("My Vaadin Application");
    setMainWindow(window);//w ww  .j  av a2s. c  om
    Button button = new Button("Click Me Two Times Three Times XXX");
    button.addListener(new Button.ClickListener() {
        public void buttonClick(ClickEvent event) {
            window.addComponent(new Label("Thank you for clicking"));
            System.out.println("Thank you for clicking");
        }
    });
    window.addComponent(button);

}

---

From source file:cl.a2r.wsmicampov2.common.utils.Excel.java

public static void GenerateExcel(String fileUrl, String sheetName, List<Integer> dataList) {

    File archivo = new File(fileUrl);
    Workbook workbook = new XSSFWorkbook();
    Sheet sheet = workbook.createSheet(sheetName);

    int rowNum = 1;
    for (Integer data : dataList) {

        Row row = sheet.createRow(rowNum++);

        row.createCell(0).setCellValue(data);
    }/*www .  j  a  va  2s.  co  m*/
    try {
        FileOutputStream salida = new FileOutputStream(archivo);
        workbook.write(salida);
        workbook.close();

    } catch (FileNotFoundException ex) {
        AppLog.logInfo(ex.getMessage(), ex);

    } catch (IOException ex) {
        AppLog.logInfo(ex.getMessage(), ex);
    } catch (Exception ex) {
        AppLog.logInfo(ex.getMessage(), ex);

    }

}

---

From source file:clummy.classes.WriteToExcel.java

public WriteToExcel(List<String> nameSourceList, List<String> addressSourceList, List<String> dobSourceList,
        List<String> genderSourceList, List<String> raceSourceList) {
    this.nameSourceList = nameSourceList;
    this.addressSourceList = addressSourceList;
    this.dobSourceList = dobSourceList;
    this.genderSourceList = genderSourceList;
    this.raceSourceList = raceSourceList;

    //Blank workbook
    workbook = new XSSFWorkbook();
    dataHandlingClass = new DataHandlingClass();
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• »