Example usage for org.apache.poi.xssf.usermodel XSSFWorkbook XSSFWorkbook

List of usage examples for org.apache.poi.xssf.usermodel XSSFWorkbook XSSFWorkbook

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.xssf.usermodel.*
  5. XSSFWorkbook
  6. XSSFWorkbook

Introduction

In this page you can find the example usage for org.apache.poi.xssf.usermodel XSSFWorkbook XSSFWorkbook.

Prototype

public XSSFWorkbook(PackagePart part) throws IOException

Source Link

Document

Constructs a XSSFWorkbook object using Package Part.

Usage

From source file:com.dataart.spreadsheetanalytics.engine.ConverterUtils.java

License:Apache License

/** Creates an instance of new {@link XSSFWorkbook} from {@link InputStream}. */
public static Workbook newWorkbook(InputStream original) {
    try {//from w ww  .j  av a2s  .  c o  m
        Workbook book = new XSSFWorkbook(original);
        book.addToolPack(Functions.getUdfFinder());
        return book;
    } catch (IOException e) {
        throw new CalculationEngineException(e);
    }
}

From source file:com.dataart.spreadsheetanalytics.test.functions.dslookup.Monthly_Data_Query_Test.java

License:Apache License

@BeforeClass
public static void before() throws Exception {
    dataModel = Converters.toDataModel(new XSSFWorkbook(pathDataModel));

    CacheManager cacheManager = Caching.getCachingProvider().getCacheManager();

    MutableConfiguration config = new MutableConfiguration();
    config.setStoreByValue(false).setExpiryPolicyFactory(AccessedExpiryPolicy.factoryOf(Duration.ETERNAL))
            .setStatisticsEnabled(false);

    cacheManager.createCache(CacheBasedDataSetAccessor.DATA_SET_TO_ID_CACHE_NAME,
            config.setTypes(IDataModelId.class, IDataSet.class));
    cacheManager.createCache(CacheBasedDataSetAccessor.DATA_SET_TO_NAME_CACHE_NAME,
            config.setTypes(String.class, IDataSet.class));
    cacheManager.createCache(DataSetOptimisationsCache.DATA_SET_TO_LAZY_PARAMETERS,
            config.setTypes(ILazyDataSet.Parameters.class, IDataSet.class));
    cacheManager.createCache(DataSetOptimisationsCache.DATA_SET_DS_LOOKUP_PARAMETERS,
            config.setTypes(DsLookupParameters.class, List.class));

    final ExternalServices external = ExternalServices.INSTANCE;

    DataSetAccessor dataSetStorage = new CacheBasedDataSetAccessor();

    external.setDataSetAccessor(dataSetStorage);
    external.setDataSetOptimisationsCache(new DataSetOptimisationsCache());

    final IDataSet dataSet = Converters.toDataSet(new XSSFWorkbook(pathDataSet));
    dataSetStorage.add(dataSet);//  www. j  av  a  2  s .  c  om

    expectedValues = new HashMap<>();

    evaluator = new SpreadsheetEvaluator(dataModel);
    for (int i = expectedRowStart; i <= expectedRowEnd; i++) {
        ICellValue value = evaluator.evaluate(A1Address.fromA1Address(expectedColumn + i)).getResult();
        expectedValues.put(expectedColumn + i, value.get());
    }
}

From source file:com.dataart.spreadsheetanalytics.test.functions.funcexec.FuncexecNoSingleton_Test.java

License:Apache License

@BeforeClass
public static void before() throws Exception {
    dataModel = Converters.toDataModel(new XSSFWorkbook(pathDataModel));

    CacheManager cacheManager = Caching.getCachingProvider().getCacheManager();

    MutableConfiguration config = new MutableConfiguration();
    config.setStoreByValue(false).setExpiryPolicyFactory(AccessedExpiryPolicy.factoryOf(Duration.ETERNAL))
            .setStatisticsEnabled(false);

    cacheManager.createCache(CacheBasedDataModelAccessor.DATA_MODEL_TO_ID_CACHE_NAME,
            config.setTypes(IDataModelId.class, IDataModel.class));
    cacheManager.createCache(CacheBasedDataModelAccessor.DATA_MODEL_TO_NAME_CACHE_NAME,
            config.setTypes(String.class, IDataModel.class));
    cacheManager.createCache(CacheBasedMetaFunctionAccessor.META_FUNCTIONS_CACHE_NAME,
            config.setTypes(String.class, FunctionMeta.class));

    DataModelAccessor dataModelAccessor = new CacheBasedDataModelAccessor();
    MetaFunctionAccessor metaFunctionAccessor = new CacheBasedMetaFunctionAccessor();

    globalContext = new EvaluationContext();
    globalContext.set(DataModelAccessor.class, dataModelAccessor);
    globalContext.set(MetaFunctionAccessor.class, metaFunctionAccessor);

    dataModelAccessor.add(dataModel); //execution model

    Map<DefineFunctionMeta, IDataModel> defineModels = Converters
            .toMetaFunctions(new XSSFWorkbook(pathDataModel), DefineFunctionMeta.class);
    defineModels.forEach((k, v) -> {/*  w  w w .j a v a 2s.co  m*/
        metaFunctionAccessor.add(k); //defein meta info with link to DataModel
        dataModelAccessor.add(v); //define model
    });
}

From source file:com.dataart.spreadsheetanalytics.test.functions.funcexec.Funcexec_Test.java

License:Apache License

@BeforeClass
public static void before() throws Exception {
    dataModel = Converters.toDataModel(new XSSFWorkbook(pathDataModel));

    CacheManager cacheManager = Caching.getCachingProvider().getCacheManager();

    MutableConfiguration config = new MutableConfiguration();
    config.setStoreByValue(false).setExpiryPolicyFactory(AccessedExpiryPolicy.factoryOf(Duration.ETERNAL))
            .setStatisticsEnabled(false);

    cacheManager.createCache(CacheBasedDataModelAccessor.DATA_MODEL_TO_ID_CACHE_NAME,
            config.setTypes(IDataModelId.class, IDataModel.class));
    cacheManager.createCache(CacheBasedDataModelAccessor.DATA_MODEL_TO_NAME_CACHE_NAME,
            config.setTypes(String.class, IDataModel.class));
    cacheManager.createCache(CacheBasedMetaFunctionAccessor.META_FUNCTIONS_CACHE_NAME,
            config.setTypes(String.class, FunctionMeta.class));

    final ExternalServices external = ExternalServices.INSTANCE;

    DataModelAccessor dataModelAccessor = new CacheBasedDataModelAccessor();
    MetaFunctionAccessor metaFunctionAccessor = new CacheBasedMetaFunctionAccessor();

    external.setDataModelAccessor(dataModelAccessor);
    external.setMetaFunctionAccessor(metaFunctionAccessor);

    dataModelAccessor.add(dataModel); //execution model

    Map<DefineFunctionMeta, IDataModel> defineModels = Converters
            .toMetaFunctions(new XSSFWorkbook(pathDataModel), DefineFunctionMeta.class);
    defineModels.forEach((k, v) -> {//from ww  w  . ja v a 2  s  .  c  o  m
        metaFunctionAccessor.add(k); //defein meta info with link to DataModel
        dataModelAccessor.add(v); //define model
    });

    expectedValues = new HashMap<>();

    evaluator = new SpreadsheetEvaluator(dataModel);
    for (int i = expectedRowStart; i <= expectedRowEnd; i++) {
        ICellValue value = evaluator.evaluate(A1Address.fromA1Address(expectedColumn + i)).getResult();
        expectedValues.put(expectedColumn + i, value.get());
    }
}

From source file:com.dataart.spreadsheetanalytics.test.functions.query.Skills_Sql_Table_Test.java

License:Apache License

@BeforeClass
public static void before() throws Exception {
    dataModel = Converters.toDataModel(new XSSFWorkbook(pathDataModel));

    CacheManager cacheManager = Caching.getCachingProvider().getCacheManager();

    MutableConfiguration config = new MutableConfiguration();
    config.setStoreByValue(false).setExpiryPolicyFactory(AccessedExpiryPolicy.factoryOf(Duration.ETERNAL))
            .setStatisticsEnabled(false);

    cacheManager.createCache(CacheBasedDataModelAccessor.DATA_MODEL_TO_ID_CACHE_NAME,
            config.setTypes(IDataModelId.class, IDataModel.class));
    cacheManager.createCache(CacheBasedDataModelAccessor.DATA_MODEL_TO_NAME_CACHE_NAME,
            config.setTypes(String.class, IDataModel.class));
    cacheManager.createCache(CacheBasedDataSetAccessor.DATA_SET_TO_ID_CACHE_NAME,
            config.setTypes(IDataModelId.class, IDataSet.class));
    cacheManager.createCache(CacheBasedDataSetAccessor.DATA_SET_TO_NAME_CACHE_NAME,
            config.setTypes(String.class, IDataSet.class));
    cacheManager.createCache(CacheBasedDataSourceHub.DATA_SOURCE_CACHE_NAME,
            config.setTypes(Object.class, DataSource.class));
    cacheManager.createCache(DataSetOptimisationsCache.DATA_SET_TO_LAZY_PARAMETERS,
            config.setTypes(ILazyDataSet.Parameters.class, IDataSet.class));
    cacheManager.createCache(DataSetOptimisationsCache.DATA_SET_DS_LOOKUP_PARAMETERS,
            config.setTypes(DsLookupParameters.class, List.class));

    final ExternalServices external = ExternalServices.INSTANCE;

    DataModelAccessor dataModelStorage = new CacheBasedDataModelAccessor();
    DataSetAccessor dataSetStorage = new CacheBasedDataSetAccessor();
    DataSourceHub dataSourceHub = new CacheBasedDataSourceHub();
    MetaFunctionAccessor attributeFunctionStorage = new CacheBasedMetaFunctionAccessor();

    external.setDataModelAccessor(dataModelStorage);
    external.setDataSetAccessor(dataSetStorage);
    external.setDataSourceHub(dataSourceHub);
    external.setMetaFunctionAccessor(attributeFunctionStorage);
    external.setDataSetOptimisationsCache(new DataSetOptimisationsCache());

    dataSourceHub.add(new TempSqlDataSource());

    dataSetStorage.add(new SqlDataSet("AllSkills", "SELECT * FROM skills"));
    dataSetStorage.add(new SqlDataSet("SkillsInCity", "SELECT * FROM skills WHERE CITY = '?' OR CITY = '?'"));
    dataSetStorage.add(new SqlDataSet("SkillsForQualification",
            "SELECT FirstName, LastName FROM skills WHERE Qualification = '?'"));
    dataSetStorage.add(/*from  ww  w  . j  a  va  2  s.c o m*/
            new SqlDataSet("SkillsForNotLevelOfEnglish", "SELECT * FROM skills WHERE LevelOfEnglish is not ?"));
    dataSetStorage.add(new SqlDataSet("SkillsForLevelOfEnglish",
            "SELECT FirstName, LastName, Level FROM skills WHERE LevelOfEnglish in (?, ?, ?)"));

    expectedValues = new HashMap<>();

    evaluator = new SpreadsheetEvaluator(dataModel);
    for (int i = expectedRowStart; i <= expectedRowEnd; i++) {
        ICellValue value = evaluator.evaluate(A1Address.fromA1Address(expectedColumn + i)).getResult();
        expectedValues.put(expectedColumn + i, value.get());
    }
}

From source file:com.dataart.spreadsheetanalytics.test.functions.validate.ValidateWithFuncexec_Function_Test.java

License:Apache License

@BeforeClass
public static void before() throws Exception {
    dataModel = Converters.toDataModel(new XSSFWorkbook(pathDataModel));

    CacheManager cacheManager = Caching.getCachingProvider().getCacheManager();

    MutableConfiguration config = new MutableConfiguration();
    config.setStoreByValue(false).setExpiryPolicyFactory(AccessedExpiryPolicy.factoryOf(Duration.ETERNAL))
            .setStatisticsEnabled(false);

    cacheManager.createCache(CacheBasedDataSetAccessor.DATA_SET_TO_ID_CACHE_NAME,
            config.setTypes(IDataModelId.class, IDataSet.class));
    cacheManager.createCache(CacheBasedDataSetAccessor.DATA_SET_TO_NAME_CACHE_NAME,
            config.setTypes(String.class, IDataSet.class));
    cacheManager.createCache(CacheBasedDataModelAccessor.DATA_MODEL_TO_ID_CACHE_NAME,
            config.setTypes(IDataModelId.class, IDataModel.class));
    cacheManager.createCache(CacheBasedDataModelAccessor.DATA_MODEL_TO_NAME_CACHE_NAME,
            config.setTypes(String.class, IDataModel.class));
    cacheManager.createCache(CacheBasedMetaFunctionAccessor.META_FUNCTIONS_CACHE_NAME,
            config.setTypes(String.class, FunctionMeta.class));

    DataModelAccessor dataModelAccessor = new CacheBasedDataModelAccessor();
    MetaFunctionAccessor metaFunctionAccessor = new CacheBasedMetaFunctionAccessor();

    dataModelAccessor.add(dataModel); //execution model

    Map<DefineFunctionMeta, IDataModel> defineModels = new HashMap<>();
    defineModels.putAll(Converters.toMetaFunctions(new XSSFWorkbook(pathDataModel), DefineFunctionMeta.class));
    defineModels/*from w ww .  ja  v a2s . co m*/
            .putAll(Converters.toMetaFunctions(new XSSFWorkbook(pathFuncexecLevel1), DefineFunctionMeta.class));
    defineModels
            .putAll(Converters.toMetaFunctions(new XSSFWorkbook(pathFuncexecLevel2), DefineFunctionMeta.class));

    defineModels.forEach((k, v) -> {
        metaFunctionAccessor.add(k); //defein meta info with link to DataModel
        dataModelAccessor.add(v); //define model
    });

    ExternalServices.INSTANCE.setDataSetAccessor(new CacheBasedDataSetAccessor());
    ExternalServices.INSTANCE.setDataModelAccessor(dataModelAccessor);
    ExternalServices.INSTANCE.setMetaFunctionAccessor(metaFunctionAccessor);
}

From source file:com.dataart.spreadsheetanalytics.test.functions.validate.Validate_Function_Test.java

License:Apache License

@BeforeClass
public static void before() throws Exception {
    dataModel = Converters.toDataModel(new XSSFWorkbook(pathDataModel));

    CacheManager cacheManager = Caching.getCachingProvider().getCacheManager();

    MutableConfiguration config = new MutableConfiguration();
    config.setStoreByValue(false).setExpiryPolicyFactory(AccessedExpiryPolicy.factoryOf(Duration.ETERNAL))
            .setStatisticsEnabled(false);

    cacheManager.createCache(CacheBasedDataSetAccessor.DATA_SET_TO_ID_CACHE_NAME,
            config.setTypes(IDataModelId.class, IDataSet.class));
    cacheManager.createCache(CacheBasedDataSetAccessor.DATA_SET_TO_NAME_CACHE_NAME,
            config.setTypes(String.class, IDataSet.class));

    ExternalServices.INSTANCE.setDataSetAccessor(new CacheBasedDataSetAccessor());

    expectedValues = new HashMap<>();

    SpreadsheetEvaluator evaluator = new SpreadsheetEvaluator(dataModel);
    for (int i = expectedRowStart; i <= expectedRowEnd; i++) {
        ICellValue value = evaluator.evaluate(A1Address.fromA1Address(expectedColumn + i)).getResult();
        expectedValues.put(expectedColumn + i, value.get());
    }/*from  ww w  . ja va  2s  .c  o  m*/
}

From source file:com.dataart.spreadsheetanalytics.test.graph.nonstandard.Excel_Index_Itself_D4_Test.java

License:Apache License

@Test(expected = CalculationEngineException.class)
public void assert_ExcelFile_SerializedGraph() throws IOException {
    //given/*ww w .  j av  a 2  s  .c om*/
    final IDataModel model = Converters.toDataModel(new XSSFWorkbook(path));

    final IAuditor auditor = new SpreadsheetAuditor(model);
    final ICellAddress addr = new CellAddress(model.getDataModelId(), A1Address.fromA1Address(address));
    graph = auditor.buildExecutionGraph(addr.a1Address());

    //when
    graph.getRootVertex();

    //then
    //Exception
}

From source file:com.dataart.spreadsheetanalytics.test.graph.nonstandard.Excel_Iserror_Fx_All_Test.java

License:Apache License

@Before
public void beforeTest() throws Exception {
    final IDataModel model = Converters.toDataModel(new XSSFWorkbook(path));
    GraphTestUtil.initExternalServices(model);
    auditor = new SpreadsheetAuditor(model);
}

From source file:com.dataart.spreadsheetanalytics.test.SerializedGraphTest.java

License:Apache License

public void before(String path, String address) throws Exception {

    final IDataModel model = Converters.toDataModel(new XSSFWorkbook(path));

    GraphTestUtil.initExternalServices(model);

    final IAuditor auditor = new SpreadsheetAuditor(model);
    final ICellAddress addr = new CellAddress(model.getDataModelId(), A1Address.fromA1Address(address));

    //build//from   w ww. j  av a 2 s. com
    graph = auditor.buildExecutionGraph(addr.a1Address());
}