Package org.apache.poi.hssf.usermodel

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
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
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
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
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
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
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
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
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
78
79
80
81
82
83
84
85
86
87
88
      log.info("Using Excel File"+excelFile);


      URL url = new URL(excelFile);

      HSSFWorkbook wb;
      try {
        wb = commonSpreadsheetUtils.callRules(url,ruleSource, RedConstants.EXCEL_LOG_WORKSHEET_NAME);


View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.usermodel.HSSFWorkbook

  • bad.robot.excel.DateCellTest
  • bad.robot.excel.matchers.StubCell
  • bg.smoc.web.servlet.ResultsServlet
  • com.asakusafw.testdriver.excel.Util
  • com.canoo.ant.table.ExcelPropertyTable
  • com.canoo.webtest.plugins.exceltest.AbstractExcelStep
  • com.dtrules.compiler.excel.util.ImportRuleSets
  • com.dtrules.compiler.excel.util.Rules2Excel
  • com.google.refine.importers.ExcelImporter
  • com.jfinal.ext.interceptor.excel.ExcelExporter
    • 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.