public class Employee {
private String name;
private int age;
// Getters and setters
}
public class EmployeeExcelData {
private int id;
private List<Employee> employees;
// Getters and setters
}
@ExcelImportConfig(
startRow = 2,
configFile = "importConfig.xml"
)
public interface EmployeeImporter {
@ExcelImport
List<EmployeeExcelData> importEmployees();
}
@ExcelExportConfig(
configFile = "exportConfig.xml"
)
public interface EmployeeExporter {
@ExcelExport
void exportEmployees(List<EmployeeExcelData> employeeData);
}
<import-config>
<mapping>
<column index="0" field="id"/>
<column index="1" field="employees"/>
</mapping>
</import-config>
<export-config>
<mapping>
<column index="0" field="id"/>
<column index="1" field="employees"/>
</mapping>
</export-config>
EmployeeImporter importer = ExcelImporterFactory.create(EmployeeImporter.class);
List<EmployeeExcelData> employeeData = importer.importEmployees();
EmployeeExporter exporter = ExcelExporterFactory.create(EmployeeExporter.class);
exporter.exportEmployees(employeeData);
