@Override public Schema createSchema(String schemaName) throws Exception { final MutableSchema schema = new MutableSchema(schemaName); final OPCPackage pkg = openOPCPackage(); try { final XSSFReader xssfReader = new XSSFReader(pkg); final XlsxWorkbookToTablesHandler workbookToTables = new XlsxWorkbookToTablesHandler(schema, _tableNamesToInternalIds); buildTables(xssfReader, workbookToTables); for (Entry<String, String> entry : _tableNamesToInternalIds.entrySet()) { final String tableName = entry.getKey(); final String relationshipId = entry.getValue(); final MutableTable table = (MutableTable) schema.getTableByName(tableName); buildColumns(table, relationshipId, xssfReader); } } finally { pkg.revert(); } return schema; }
@Override public Schema createSchema(String schemaName) throws Exception { final MutableSchema schema = new MutableSchema(schemaName); final OPCPackage pkg = openOPCPackage(); try { final XSSFReader xssfReader = new XSSFReader(pkg); final XlsxWorkbookToTablesHandler workbookToTables = new XlsxWorkbookToTablesHandler(schema, _tableNamesToInternalIds); buildTables(xssfReader, workbookToTables); for (Entry<String, String> entry : _tableNamesToInternalIds.entrySet()) { final String tableName = entry.getKey(); final String relationshipId = entry.getValue(); final MutableTable table = (MutableTable) schema.getTableByName(tableName); buildColumns(table, relationshipId, xssfReader); } } finally { pkg.revert(); } return schema; }
if (attributes.length > 0 || textContent != null || hasSiblings(element)) { MutableTable table = (MutableTable) _schema.getTableByName(tableName); Column idColumn; MutableColumn foreignKeyColumn;