Java 类org.apache.poi.ss.usermodel.Workbook 实例源码

项目：file-download-upload-zip-demo 文件：FileController.java

@RequestMapping(value = "/test2.xlsx", produces = MediaType.APPLICATION_OCTET_STREAM_VALUE)
@ResponseBody
byte[] testDown() throws IOException, InvalidFormatException {
    Workbook workbook = new SXSSFWorkbook();
    Sheet sheet = workbook.createSheet();
    for (int i = 0; i < 60000; i++) {
        Row newRow = sheet.createRow(i);
        for (int j = 0; j < 100; j++) {
            newRow.createCell(j).setCellValue("test" + Math.random());
        }
    }
    ByteArrayOutputStream os = new ByteArrayOutputStream();
    workbook.write(os);
    byte[] bytes = os.toByteArray();
    return bytes;
}

项目：vaadin-gridexport 文件：ExcelExport.java

/**
 * Returns the default data cell style. Obtained from:
 * http://svn.apache.org/repos/asf/poi
 * /trunk/src/examples/src/org/apache/poi/ss/examples/TimesheetDemo.java
 *
 * @param wb the wb
 * @return the cell style
 */
protected CellStyle defaultDataCellStyle(final Workbook wb) {
    CellStyle style;
    style = wb.createCellStyle();
    style.setAlignment(HorizontalAlignment.CENTER);
    style.setWrapText(true);
    style.setBorderRight(BorderStyle.THIN);
    style.setRightBorderColor(IndexedColors.BLACK.getIndex());
    style.setBorderLeft(BorderStyle.THIN);
    style.setLeftBorderColor(IndexedColors.BLACK.getIndex());
    style.setBorderTop(BorderStyle.THIN);
    style.setTopBorderColor(IndexedColors.BLACK.getIndex());
    style.setBorderBottom(BorderStyle.THIN);
    style.setBottomBorderColor(IndexedColors.BLACK.getIndex());
    style.setDataFormat(doubleDataFormat);
    return style;
}

项目：bdf2 文件：AbstractStyleBuilder.java

public void setCellStyleFont(Workbook workbook, CellStyle style, int i) {
    Font font = workbook.createFont();
    if (i == 0) {
        // 正常
    } else if (i == 4) {
        // 下划线
        font.setUnderline(Font.U_SINGLE);
        style.setFont(font);
    } else if (i == 2) {
        // 倾斜
        font.setItalic(true);
        style.setFont(font);
    } else if (i == 1) {
        // 加粗
        font.setBold(true);
        style.setFont(font);
    }
}

项目：bdf2 文件：GridStyleBuilder.java

public CellStyle createIndentationCellStyle(Workbook workbook, int s) {
    CellStyle dataStyle1 = this.createBorderCellStyle(workbook, true);
    Font dataFont = workbook.createFont();
    dataFont.setColor((short) 12);
    dataFont.setFontHeightInPoints((short) 10);
    dataStyle1.setFillPattern(FillPatternType.SOLID_FOREGROUND);
    dataStyle1.setFillForegroundColor((short) 11);
    dataStyle1.setFont(dataFont);
    dataStyle1.setVerticalAlignment(VerticalAlignment.CENTER);
    dataStyle1.setAlignment(HorizontalAlignment.LEFT);
    dataStyle1.setIndention(Short.valueOf(String.valueOf((s))));
    return dataStyle1;
}

项目：UtilsMaven 文件：TestBeanToMap.java

@Test
public void test2() throws IOException {
    User user = new User("小红", "女", new Date());
    user.setPet(new Pet("小猫", new Date()));
    user.setAge(90);
    user.setAddress("uiijji");
    List<User> list = new ArrayList<User>();
    list.add(user);
    Workbook workbook = new HSSFWorkbook();
    //        workbook
    File file = new File("C:\\Users\\h_kx1\\Desktop\\test.xls");
    OutputStream os = new FileOutputStream(file);

    WriteExcelUtils.writeWorkBook(workbook, list);
    WriteExcelUtils.writeWorkBookToExcel(workbook, os);
    CommonUtils.closeIOStream(null, os);
}

项目：excel-utils 文件：ExcelImportUtil.java

public static <T>  ImportResult<T> importExcel(ExcelFileType fileType,InputStream inputStream,Class<T> clazz) throws Exception{
    if(importInfoMap.get(clazz) == null){//初始化信息
        initTargetClass(clazz);         
    }
    ImportInfo importInfo = importInfoMap.get(clazz);
    Integer headRow = importInfo.getHeadRow();
    Workbook workbook = createWorkbook(fileType, inputStream);

    int sheetNum = workbook.getNumberOfSheets();
    if(sheetNum < 1 ){
        return null;
    }
    Sheet sheet = workbook.getSheetAt(0);
    int rowCount = sheet.getPhysicalNumberOfRows();
    if(rowCount < (headRow+1)){//
        return null;
    }
    List<String> headNameList = createHeadNameList(sheet, headRow);
    return readData(clazz, importInfo, workbook,headNameList);
}

项目：excel-utils 文件：TestUser.java

/**
 * 分批写出20w条数据
 * 
 * @throws IOException 
 */
@Test
public void batchesExport() throws IOException {
    Map<String, String> map = new HashMap<String,String>();
    map.put("msg", "用户信息导出报表");
    map.put("status", "导出成功");

    Workbook workbook = null;
    //分两次写入20w条数据
    List<UserPlus> list;
    for(int i = 0 ; i < 2 ; i++){
        list = getData(i*100000, 100000);
        workbook = ExcelExportUtil.exportExcel03(UserPlus.class, list, map,workbook);

    }
    FileOutputStream outputStream = new FileOutputStream("D:/test/user1.xls");
    workbook.write(outputStream);
    outputStream.flush();
    outputStream.close();
}

项目：excel-utils 文件：TestUser.java

/**@throws IOException 
 * @Excel(headRow=2,dataRow=5,sheetName="用户统计表",sheetSize=65536)
 * 分sheet测试  
 */
@Test
public void separateSheet() throws IOException {
    //获取10w条数据
    List<UserPlus> list = getData(0, 100000);
    Map<String, String> map = new HashMap<String,String>();
    map.put("msg", "用户信息导出报表");
    map.put("status", "导出成功");
    long start = System.currentTimeMillis();
    Workbook workbook = ExcelExportUtil.exportExcel03(UserPlus.class, list, map);
    long end = System.currentTimeMillis();
    System.out.println("耗时：" + (end - start ) + "毫秒");
    FileOutputStream outputStream = new FileOutputStream("D:/test/user.xls");
    workbook.write(outputStream);
    outputStream.flush();
    outputStream.close();
}

项目：excel-utils 文件：TestUser.java

@Test
public void testExcel07() throws IOException{
    List<UserPlus> list = getData(0, 20000);
    Map<String, String> map = new HashMap<String,String>();
    map.put("msg", "用户信息导出报表");
    map.put("status", "导出成功");
    long start = System.currentTimeMillis();
    Workbook workbook = ExcelExportUtil.exportExcel07(UserPlus.class, list, map, true);
    long end = System.currentTimeMillis();
    System.out.println("耗时：" + (end - start ) + "毫秒");
    FileOutputStream outputStream = new FileOutputStream("D:/test/user.xlsx");
    workbook.write(outputStream);
    if(SXSSFWorkbook.class.equals(workbook.getClass())){
        SXSSFWorkbook wb = (SXSSFWorkbook)workbook;
        wb.dispose();
    }
    outputStream.flush();
    outputStream.close();
}

项目：spring-i18n-support 文件：ExcelWriter.java

/**
 * Creates an excel file to export message data.
 * The excel workbook will have several sheets named after the map key.
 * Each sheet of the file will have the default form:
 * <ul>
 * <li>Line 1 (Header): KEY | de | fr | more iso-language-codes ...</li>
 * <li>Line 2..n (Values): message.key | Deutsch | Francaise | other translation</li>
 * </ul>
 * The header columns are defined by the provided languages in the resources lists.
 * The concrete row and column numbers can be configured to match more requirements like comments.
 * 
 * @param input a list of message information to write to excel
 * @param output if you want to create xls (Excel 97-2003) files, DO NOT use BufferedOutputStream due to library
 *            issue.
 * @param format use constants FORMAT_EXCEL_97 or FORMAT_EXCEL_2007
 * @throws I18nException if a problem occures
 */
public void createExcel(Map<String, List<MessageResourceEntry>> input,
                        OutputStream output,
                        String format) throws I18nException
{
    Workbook wb = createWorkbook(format);
    for (Entry<String, List<MessageResourceEntry>> entry : input.entrySet())
    {
        createSheet(entry.getValue(), entry.getKey(), wb);
    }
    try
    {
        LOG.info("Write data to output stream");
        wb.write(output);
    }
    catch (IOException e)
    {
        throw new I18nException("Problem writing to stream", e);
    }
}