Examples of HSSFWorkbook

Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook

122
123
124
125
126
127
128
129
130
131
132
133
        }
    }

    static Workbook createEmptyWorkbookFor(String path) {
        if (isHssf(path)) {
            return new HSSFWorkbook();
        } else if (isXssf(path)) {
            return new XSSFWorkbook();
        } else {
            return new HSSFWorkbook();
        }
    }
View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook

111
112
113
114
115
116
117
118
119
120
121
     * @throws IOException Excelファイルの読み出しに失敗した場合
     */
    public ExcelUtils(String filename) throws IOException {
        this.filename = filename;
        InputStream is = new FileInputStream(filename);
        workbook = new HSSFWorkbook(is);
        inputDataSheet = workbook.getSheet(Constants.INPUT_DATA_SHEET_NAME);
        if (inputDataSheet == null) {
            throw new IOException("Excelファイル: " + filename + "に入力データのシートが存在しません");
        }
        outputDataSheet = workbook.getSheet(Constants.OUTPUT_DATA_SHEET_NAME);
View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook

471
472
473
474
475
476
477
478
479
480
481
482
    public void testGetXXXOption() throws Exception {
        String filename = "src/test/data/Excel/ExcelUtils/ALLT_TYPES.xls";

        // テスト対象のEXCELシートを取得
        InputStream is = new FileInputStream(filename);
        HSSFWorkbook workbook = new HSSFWorkbook(is);
        HSSFSheet sheet = workbook.getSheet(Constants.OUTPUT_DATA_SHEET_NAME);

        // テスト対象のExcelUtilsオブジェクトを生成
        ExcelUtils excelUtils =  new ExcelUtils(filename);

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook

95
96
97
98
99
100
101
102
103
104
105
    public void build(File outputDirectory) throws IOException, SQLException {
        // カラム情報の取得
        columnInfos = DatabaseSchema.collectColumns(conn, databaseName, tableName);

        // ワークブックを生成
        workbook = new HSSFWorkbook();

        // セルスタイルを作成
        configureColumnStyle();

        // 入力データのシートと出力データのシートを生成
View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook

76
77
78
79
80
81
82
83
84
85
86
    //Get the URL
    File excelDataFile = new File(EXCEL_DATA_FILE);

    //Call the rule engine passing in the excel data file, the rules we want to use, and name of the spreadsheet that we log rules to
    HSSFWorkbook wb = ruleRunner.callRules(excelDataFile,ruleSource, EXCEL_LOG_WORKSHEET_NAME);


    //Output the workbook as a file,
    SpreadSheetOutputter.outputToFile(wb, EXCEL_LOG_WORKSHEET_NAME);
View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook

91
92
93
94
95
96
97
98
99
100
101
    // Create a new Excel Logging object
    SpreadSheetLogger spreadsheetLogger = new SpreadSheetLogger();

    // Convert this into a (POI) Workbook
    HSSFWorkbook wb = new HSSFWorkbook(new POIFSFileSystem(inputFromExcel));

    // Convert the cell
    RangeHolder ranges = RangeConvertor.convertExcelToCells(wb);

    //Call the overloaded method to actually run the rules
View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook

65
66
67
68
69
70
71
72
73
74
75
    //Get the URL
    File excelDataFile = new File(EXCEL_DATA_FILE);

    //Call the rule engine passing in the excel data file, the rules we want to use, and name of the spreadsheet that we log rules to
    HSSFWorkbook wb = ruleRunner.callRules(excelDataFile,ruleSource, EXCEL_LOG_WORKSHEET_NAME);


    //Output the workbook as a file,
    SpreadSheetOutputter.outputToFile(wb, EXCEL_LOG_WORKSHEET_NAME);
View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook

63
64
65
66
67
68
69
70
71
72
73
    } else {
      log.info("found file:" + EXCEL_DATA_FILE);
    }

    // Convert this into a (POI) Workbook
    HSSFWorkbook wb = new HSSFWorkbook(new POIFSFileSystem(inputFromExcel));

    // Convert the cell
    RangeHolder ranges = RangeConvertor.convertExcelToCells(wb);
    HashMap<String, Object> globals = new HashMap<String, Object>();
View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook

67
68
69
70
71
72
73
74
75
76
77
    } else {
      log.info("found file:" + EXCEL_DATA_FILE);
    }

    // Convert this into a (POI) Workbook
    HSSFWorkbook wb = new HSSFWorkbook(new POIFSFileSystem(inputFromExcel));

    // Convert the cell
    RangeHolder ranges = RangeConvertor.convertExcelToCells(wb);
    HashMap<String, Object> globals = new HashMap<String, Object>();
View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook

71
72
73
74
75
76
77
78
79
80
81
    //Get the URL
    File excelDataFile = new File(EXCEL_DATA_FILE);

    //Call the rule engine passing in the excel data file, the rules we want to use, and name of the spreadsheet that we log rules to
    HSSFWorkbook wb = sheetRuleRunner.callRules(excelDataFile,ruleSource, EXCEL_LOG_WORKSHEET_NAME);


    //Output the workbook as a file,
    SpreadSheetOutputter.outputToFile(wb, EXCEL_LOG_WORKSHEET_NAME);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.