Package com.common.platform.excel.entity

Examples of com.common.platform.excel.entity.Sheet


           
            System.out.println();
            Map<String, Sheet> sheets = bigDataReader.getMoreSheetDataList();
            for (String sheetIndex : sheets.keySet()) {
                System.out.println("第" + (Integer.valueOf(sheetIndex) + 1) + "个表格数据:" );
                Sheet currentSheet = sheets.get(sheetIndex);
                System.out.println(currentSheet);
                System.out.println();
            }
            System.out.println("=====================================================================================");
        } catch (Throwable e) {
View Full Code Here


     */
    @Override
    public void handlerRow(int sheetIndex, String sheetName, int currentRow, List<String> rowList) {
        // 判定当前表格索引是否注册
        String key = String.valueOf(sheetIndex);
        Sheet sheet =  this.moreSheetDataList.get(key);
        List<String> singleSheetDataList = null;
        if(null == sheet){
            sheet = new Sheet();
            sheet.setSheetIndex(sheetIndex);
            sheet.setSheetName(sheetName);
            singleSheetDataList = new ArrayList<String>();
            sheet.setDataRows(singleSheetDataList);
            this.moreSheetDataList.put(key, sheet);
        }else{
            singleSheetDataList = sheet.getDataRows();
        }
       
        if(null != rowList && !rowList.isEmpty()){
            StringBuffer rows = new StringBuffer();
            for (int i = 0; i < rowList.size(); i++) {
                String content = rowList.get(i);
                if(null != content){
                    content = content.replaceAll("\\" + dataSeparator, "");
                }
                rows.append(content);
                if(i < rowList.size() - 1){
                    rows.append(dataSeparator);
                }
            }
           
            String rowData = rows.toString();
            if(!rowData.trim().isEmpty()){
                //System.out.println(rowData);
                int index = singleSheetDataList.size();
                singleSheetDataList.add(index, rowData);
                sheet.setRows(singleSheetDataList.size());
            }
        }
    }
View Full Code Here

     *
     * @return List<String> the singleSheetDataList 返回单个sheet表格。
     */
    @Override
    public Sheet getSingleSheetDataList(String sheetIndex) {
        Sheet currentSheet =  this.moreSheetDataList.get(sheetIndex);
        return currentSheet;
    }
View Full Code Here

TOP

Related Classes of com.common.platform.excel.entity.Sheet

Copyright © 2018 www.massapicom. All rights reserved.
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.