/*
* Copyright 2014 Objectos, Fábrica de Software LTDA.
*
* Licensed under the Apache License, Version 2.0 (the "License"); you may not
* use this file except in compliance with the License. You may obtain a copy of
* the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
* WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
* License for the specific language governing permissions and limitations under
* the License.
*/
package br.com.objectos.way.io;
import static br.com.objectos.way.base.testing.WayMatchers.equalTo;
import static org.hamcrest.MatcherAssert.assertThat;
import java.io.IOException;
import java.util.List;
import org.testng.annotations.BeforeClass;
import org.testng.annotations.Test;
import br.com.objectos.way.base.io.Directory;
/**
* @author marcio.endo@objectos.com.br (Marcio Endo)
*/
@Test
public class WorkbookXlsTest {
private WorkbookXls xls;
@BeforeClass
public void setUp() {
List<Entity> entities = FakeEntities.getAll();
SheetXls sheet0 = EntityWriter.INSTANCE.writeAll(entities)
.asSheetXls();
SheetXls sheet1 = EntityWriter.INSTANCE.writeAll(entities)
.asSheetXlsNamed("second");
xls = WayIO.newWorkbookXls()
.add(sheet0)
.add(sheet1)
.named("way-io.xls");
}
public void write_to() throws IOException {
Directory dir = Directory.JAVA_IO_TMPDIR;
xls.writeTo(dir);
List<Entity> res = WayIO.tableReaderOf(Entity.class)
.xls()
.skipFirstLines(1)
.parseWith(new EntityParser())
.filterWith(new EntityFilter())
.build()
.readFile(xls.toFileAt(dir))
.sheetNamed("second")
.getRows();
assertThat(res.size(), equalTo(3));
}
}