Examples of org.apache.metamodel.excel.ExcelDataContext

org.apache.metamodel.excel.ExcelDataContext
{@link DataContext} implementation to use for Excel spreadsheets.This DataContext supports both the "old" .xls format and the "new" .xlsx format, and saves the user the trouble of figuring out which one to use, simply by detecting it at runtime and delegating to the appropriate implementation.

                ExcelConfiguration.DEFAULT_COLUMN_NAME_LINE);
        final boolean skipEmptyLines = getBoolean(params.getSkipEmptyLines(), true);
        final boolean skipEmptyColumns = getBoolean(params.getSkipEmptyColumns(), false);
        final ExcelConfiguration configuration = new ExcelConfiguration(columnNameLineNumber, skipEmptyLines,
                skipEmptyColumns);
        return new ExcelDataContext(resource, configuration);
    }

View Full Code Here

     * @param configuration
     *            the configuration with metadata for reading the spreadsheet
     * @return a DataContext object that matches the request
     */
    public static UpdateableDataContext createExcelDataContext(File file, ExcelConfiguration configuration) {
        return new ExcelDataContext(file, configuration);
    }

View Full Code Here


    @Test
    public void testReadDataContext() {
        assertEquals(ExcelDataContext.class, dataContext.getClass());


        ExcelDataContext excel = (ExcelDataContext) dataContext;
        Resource resource = excel.getResource();


        assertEquals(FileResource.class, resource.getClass());


        assertEquals("example.xlsx", resource.getName());


        assertEquals("[hello, world]", Arrays.toString(excel.getDefaultSchema().getTable(0).getColumnNames()));


        Assert.assertTrue(excel.getConfiguration().isSkipEmptyLines());
        Assert.assertTrue(excel.getConfiguration().isSkipEmptyColumns());
    }

View Full Code Here

     * @param configuration
     *            the configuration with metadata for reading the spreadsheet
     * @return a DataContext object that matches the request
     */
    public static UpdateableDataContext createExcelDataContext(File file, ExcelConfiguration configuration) {
        return new ExcelDataContext(file, configuration);
    }

View Full Code Here

     * @param configuration
     *            the configuration with metadata for reading the spreadsheet
     * @return a DataContext object that matches the request
     */
    public static UpdateableDataContext createExcelDataContext(File file, ExcelConfiguration configuration) {
        return new ExcelDataContext(file, configuration);
    }

View Full Code Here

TOP

Related Classes of org.apache.metamodel.excel.ExcelDataContext

org.apache.metamodel.data.DataSet

org.apache.metamodel.DataContextFactory

org.apache.metamodel.schema.MutableSchema

org.apache.metamodel.schema.Schema

org.apache.metamodel.spring.ExcelDataContextFactoryBeanDelegate

org.apache.metamodel.spring.ExcelSpecifiedConfigurationFromFilenameTest

org.apache.metamodel.util.FileResource

java.io.PushbackInputStream

org.apache.metamodel.MetaModelException

java.io.InputStream

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.