Package guru.interlis.convconf.file

Class XlsxWorkbookAdapter

java.lang.Object

guru.interlis.convconf.file.XlsxWorkbookAdapter

All Implemented Interfaces:

FileSourceReader, FileTargetWriter, RecordSourceReader, RecordTargetWriter

public final class XlsxWorkbookAdapter
extends Object
implements FileSourceReader, FileTargetWriter

File source/writer using one XLSX workbook with one sheet per source/target name.

Constructor Summary

Constructors

Constructor	Description
XlsxWorkbookAdapter(Path workbook)

Method Summary

Modifier and Type	Method	Description
List<Map<String,Object>>	read(String sourceName, Map<String,String> equalsFilter)	Reads rows from a backend object with an equality filter.
void	write(String targetName, List<Map<String,Object>> rows)	Writes rows to a backend object.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

XlsxWorkbookAdapter

public XlsxWorkbookAdapter(Path workbook)

Method Details

read

public List<Map<String,Object>> read(String sourceName,
 Map<String,String> equalsFilter)
                              throws Exception

Description copied from interface: RecordSourceReader

Reads rows from a backend object with an equality filter.

Specified by:

read in interface RecordSourceReader

Parameters:

sourceName - backend-specific source object name

equalsFilter - key/value equality filter (column -> required value)

Returns:

list of rows as column/value maps

Throws:

Exception - on backend access failures

write

public void write(String targetName,
 List<Map<String,Object>> rows)
           throws Exception

Description copied from interface: RecordTargetWriter

Writes rows to a backend object.

Specified by:

write in interface RecordTargetWriter

Parameters:

targetName - backend-specific target object name

rows - rows to write as column/value maps

Throws:

Exception - on backend access failures