Examples of org.apache.poi.xssf.usermodel.XSSFSheet.createRow()

Class org.apache.poi.xssf.usermodel.XSSFSheet

Examples of org.apache.poi.xssf.usermodel.XSSFSheet.createRow()

org.apache.poi.xssf.usermodel.XSSFSheet.createRow()
Create a new row within the sheet and return the high level representation @param rownum row number @return High level {@link XSSFRow} object representing a row in the sheet @see #removeRow(org.apache.poi.ss.usermodel.Row)

    sheet.setColumnWidth(5, 50*255);    
    sheet.setColumnWidth(6, 15*255);    
    sheet.setColumnWidth(7, 20*255);  
    sheet.setColumnWidth(8, 10*255);    
    //创建第一行
    XSSFRow row=sheet.createRow(0);
    //表头样式
        XSSFFont fonttitle=wb.createFont();
        fonttitle.setItalic(true);
        fonttitle.setFontName("微软雅黑");
        fonttitle.setBoldweight(XSSFFont.BOLDWEIGHT_BOLD);//粗体

View Full Code Here

    }
    
    // 写入内容行
    for (int i = 0; i < datas.size(); i++) {
      String[] rowvalue = datas.get(i);
      XSSFRow nextrow = sheet.createRow(sheet.getLastRowNum() + 1);// 创建一行
      for (int j = 0; j < rowvalue.length; j++) {
        XSSFCell cell = nextrow
            .createCell(j, XSSFCell.CELL_TYPE_STRING);
        cell.setCellValue(new XSSFRichTextString(rowvalue[j]));
        if (rowvalue[j].equals("Fail")) {

View Full Code Here

    Row r5 = sheet1.getRow(4);
    Comment cc5 = r5.getCell(2).getCellComment();
    cc5.setAuthor("Apache POI");
    cc5.setString(new XSSFRichTextString("Hello!"));
    
    Row r2s2 = sheet2.createRow(2);
    Cell c1r2s2 = r2s2.createCell(1);
    assertNull(c1r2s2.getCellComment());
    
    Comment cc2 = sheet2.createComment();
    cc2.setAuthor("Also POI");

View Full Code Here

    sheet.setColumnWidth(5, 50*255);    
    sheet.setColumnWidth(6, 15*255);    
    sheet.setColumnWidth(7, 20*255);  
    sheet.setColumnWidth(8, 10*255);    
    //创建第一行
    XSSFRow row=sheet.createRow(0);
    //表头样式
        XSSFFont fonttitle=wb.createFont();
        fonttitle.setItalic(true);
        fonttitle.setFontName("微软雅黑");
        fonttitle.setBoldweight(XSSFFont.BOLDWEIGHT_BOLD);//粗体

View Full Code Here

    }
    
    // 写入内容行
    for (int i = 0; i < datas.size(); i++) {
      String[] rowvalue = datas.get(i);
      XSSFRow nextrow = sheet.createRow(sheet.getLastRowNum() + 1);// 创建一行
      for (int j = 0; j < rowvalue.length; j++) {
        XSSFCell cell = nextrow
            .createCell(j, XSSFCell.CELL_TYPE_STRING);
        cell.setCellValue(new XSSFRichTextString(rowvalue[j]));
        if (rowvalue[j].equals("Fail")) {

View Full Code Here

0 1 2

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.