/**
*
*/
package test;
import static org.junit.Assert.*;
import org.junit.After;
import org.junit.AfterClass;
import org.junit.Before;
import org.junit.BeforeClass;
import org.junit.Test;
import csvProcessor.Cell;
import csvProcessor.Position;
import csvProcessor.Sheet;
import csvProcessor.SheetImp;
import csvProcessor.SheetWriter;
import static test.TestHelper.*;
/**
* @author Administrator
*
*/
public class SheetImpTest {
/**
* @throws java.lang.Exception
*/
@BeforeClass
public static void setUpBeforeClass() throws Exception {
}
/**
* @throws java.lang.Exception
*/
@AfterClass
public static void tearDownAfterClass() throws Exception {
}
/**
* @throws java.lang.Exception
*/
@Before
public void setUp() throws Exception {
}
/**
* @throws java.lang.Exception
*/
@After
public void tearDown() throws Exception {
}
/**
* Test method for {@link csvParser.SheetImp#hasCell(java.lang.String)}.
*/
/** ================================================================================= */
SheetImp test_1 = new SheetImp("./src/test/test_1.csv");
SheetWriter sw;
@Test
public void testHasCell() {
assertEquals(test_1.hasCell("1"), true);
assertEquals(test_1.hasCell("20"), true);
assertEquals(test_1.hasCell("200"), true);
assertEquals(test_1.hasCell("381"), true);
assertEquals(test_1.hasCell("400"), true);
assertEquals(test_1.hasCell("0"), false);
assertEquals(test_1.hasCell("500"), false);
assertEquals(test_1.hasCell("\t"), false);
assertEquals(test_1.hasCell("#"), false);
}
/**
* Test method for {@link csvParser.SheetImp#findCell(java.lang.String)}.
*/
@Test
public void testFindCell() {
Position pos;
pos = test_1.findCell("1").getPos();
assertEquals(pos.getX_pos(), 0);
assertEquals(pos.getY_pos(), 0);
pos = test_1.findCell("20").getPos();
assertEquals(pos.getX_pos(), 0);
assertEquals(pos.getY_pos(), 19);
pos = test_1.findCell("200").getPos();
assertEquals(pos.getX_pos(), 9);
assertEquals(pos.getY_pos(), 19);
pos = test_1.findCell("381").getPos();
assertEquals(pos.getX_pos(), 19);
assertEquals(pos.getY_pos(), 0);
pos = test_1.findCell("400").getPos();
assertEquals(pos.getX_pos(), 19);
assertEquals(pos.getY_pos(), 19);
assertEquals(test_1.findCell("0"), null);
assertEquals(test_1.findCell("500"), null);
assertEquals(test_1.findCell("\t"), null);
assertEquals(test_1.findCell("#"), null);
}
/**
* Test method for {@link csvParser.SheetImp#getCell(int, int)}.
*/
@Test
public void testGetCell() {
assertEquals(test_1.getCell(0, 0).getValue(), "1");
assertEquals(test_1.getCell(0, 19).getValue(), "20");
assertEquals(test_1.getCell(9, 19).getValue(), "200");
assertEquals(test_1.getCell(19, 0).getValue(), "381");
assertEquals(test_1.getCell(19, 19).getValue(), "400");
}
/**
* Test method for {@link csvParser.SheetImp#getOneRow(int)}.
*/
@SuppressWarnings("deprecation")
@Test
public void testGetOneRow() {
Cell[] exp_cells = new Cell[20];
for (int i = 0; i < exp_cells.length; i++) {
exp_cells[i] = new Cell();
exp_cells[i].setValue((i + 1) + "");
}
Cell[] act_cells = test_1.getOneRow(0);
assertEquals(assertEqualsArray(exp_cells, act_cells), 3);
for (int i = 0; i < exp_cells.length; i++) {
exp_cells[i] = new Cell();
exp_cells[i].setValue((181 + i) + "");
}
act_cells = test_1.getOneRow(9);
assertEquals(assertEqualsArray(exp_cells, act_cells), 3);
for (int i = 0; i < exp_cells.length; i++) {
exp_cells[i] = new Cell();
exp_cells[i].setValue((381 + i) + "");
}
act_cells = test_1.getOneRow(19);
assertEquals(assertEqualsArray(exp_cells, act_cells), 3);
}
/**
* Test method for {@link csvParser.SheetImp#getOneColumn(int)}.
*/
@Test
public void testGetOneColumn() {
Cell[] exp_cells = new Cell[20];
for (int i = 0; i < exp_cells.length; i++) {
exp_cells[i] = new Cell();
exp_cells[i].setValue((i * 20 + 1) + "");
}
Cell[] act_cells = test_1.getOneColumn(0);
assertEquals(assertEqualsArray(exp_cells, act_cells), 3);
for (int i = 0; i < exp_cells.length; i++) {
exp_cells[i] = new Cell();
exp_cells[i].setValue(((i * 20 + 10)) + "");
}
act_cells = test_1.getOneColumn(9);
assertEquals(assertEqualsArray(exp_cells, act_cells), 3);
for (int i = 0; i < exp_cells.length; i++) {
exp_cells[i] = new Cell();
exp_cells[i].setValue((i * 20 + 20) + "");
}
act_cells = test_1.getOneColumn(19);
assertEquals(assertEqualsArray(exp_cells, act_cells), 3);
}
/**
* Test method for {@link csvParser.SheetImp#getZone(int, int, int, int)}.
*/
@Test
public void testGetZone() {
Cell exp_cells[][] = new Cell[10][10];
for (int i = 0; i < exp_cells.length; i++)
for (int j = 0; j < exp_cells[0].length; j++)
exp_cells[i][j] = new Cell(((i + 5) * 20 + 6 + j) + "");
Cell act_cells[][] = test_1.getZone(5, 5, 14, 14);
assertEquals(assertEqualsArray(exp_cells, act_cells), 3);
act_cells = test_1.getZone(5, 14, 14, 5);
assertEquals(assertEqualsArray(exp_cells, act_cells), 3);
act_cells = test_1.getZone(14, 5, 5, 14);
assertEquals(assertEqualsArray(exp_cells, act_cells), 3);
act_cells = test_1.getZone(14, 14, 5, 5);
assertEquals(assertEqualsArray(exp_cells, act_cells), 3);
}
/**
* Test method for
* {@link csvParser.SheetImp#addOneCell(csvParser.Cell, csvParser.Position)}.
*/
@Test
public void testAddOneCell() {
Cell exp_cell = null;
test_1.addOneCell(exp_cell, new Position(3, 4));
assertEquals(test_1.getCell(3, 4), null);
exp_cell = new Cell("10000");
test_1.addOneCell(exp_cell, new Position(3, 4));
assertEquals(test_1.getCell(3, 4), exp_cell);
test_1.addOneCell(exp_cell, new Position(99, 19));
assertEquals(test_1.getCell(99, 19), exp_cell);
test_1.addOneCell(exp_cell, new Position(99, 23));
assertEquals(test_1.getCell(99, 23), exp_cell);
test_1.addOneCell(exp_cell, new Position(101, 24));
assertEquals(test_1.getCell(101, 24), exp_cell);
assertEquals(test_1.getCell(10, 23), null);
assertEquals(test_1.getCell(10, 8).getValue(), (new Cell("209"))
.getValue());
assertEquals(test_1.getNumRows(), 102);
}
/**
* Test method for {@link csvParser.SheetImp#deleteOneRow(int)}.
*/
@Test
public void testDeleteOneRow() {
Cell[] exp_cells = test_1.getOneRow(1);
test_1.deleteOneRow(0);
Cell[] act_cells = test_1.getOneRow(0);
assertEquals(assertEqualsArray(exp_cells, act_cells), 3);
assertEquals(test_1.getNumRows(), 19);
assertEquals(test_1.getNumColumns(), 20);
sw = new SheetWriter("./src/test/testResult/test_1_deleteOneRow.csv");
sw.write(test_1.getCells());
}
/**
* Test method for {@link csvParser.SheetImp#deleteOneColumn(int)}.
*/
@Test
public void testDeleteOneColumn() {
Cell[] exp_cells = test_1.getOneColumn(10);
test_1.deleteOneColumn(9);
Cell[] act_cells = test_1.getOneColumn(9);
assertEquals(assertEqualsArray(exp_cells, act_cells), 3);
assertEquals(test_1.getNumRows(), 20);
assertEquals(test_1.getNumColumns(), 19);
sw = new SheetWriter("./src/test/testResult/test_1_deleteOneColumn.csv");
sw.write(test_1.getCells());
}
/**
* Test method for {@link csvParser.SheetImp#deleteRows(int, int)}.
*/
@Test
public void testDeleteRows() {
Cell[][] exp_cells = test_1.getZone(7, 0, 10, 19);
test_1.deleteRows(1, 5);
Cell[][] act_cells = test_1.getZone(2, 0, 5, 19);
assertEquals(assertEqualsArray(exp_cells, act_cells), 3);
assertEquals(test_1.getNumRows(), 15);
assertEquals(test_1.getNumColumns(), 20);
sw = new SheetWriter("./src/test/testResult/test_1_deleteRows_1.csv");
sw.write(test_1.getCells());
test_1.deleteRows(10, 10);
assertEquals(test_1.getNumRows(), 10);
assertEquals(test_1.getNumCo
java 读写csv文件 csv process
5星 · 超过95%的资源 需积分: 10 131 浏览量
2010-04-17
21:45:23
上传
评论 2
收藏 180KB RAR 举报 
java 读写csv文件 csv process （130个子文件） 
SheetImpTest.class 14KB SheetImp.class 8KB SheetReader.class 3KB SheetWriter.class 3KB Cell.class 2KB Sheet.class 2KB CSVFactory.class 2KB TestHelper.class 1KB CellValueConvert.class 1KB DataConvert.class 1KB OutRangeExcetion.class 798B Position.class 728B Letters.class 693B SheetFactory.class 579B .classpath 310B stylesheet.css 1KB test_2_insertOneColumn_3.csv 2KB test_2_insertOneRow_3.csv 2KB test_2_insertOneRow_2.csv 2KB test_2_replaceColumns.csv 2KB test_2_replaceRows.csv 2KB test_1_replaceOneRow_2.csv 2KB test_1_replaceOneColumn_2.csv 2KB test_1_replaceOneRow_3.csv 2KB test_1_replaceOneColumn_3.csv 2KB test_2_insertOneColumn_1.csv 2KB test_1_replaceAllString_2.csv 2KB test_2_insertOneRow_1.csv 2KB test_1_replaceAllCell_2.csv 2KB test_1_replaceOneRow_1.csv 1KB test_1_replaceOneColumn_1.csv 1KB copy_2.csv 1KB test_1_replaceAllString_1.csv 1KB test_1.csv 1KB test_1.csv 1KB test_1_replaceAllCell_1.csv 1KB test_2.csv 1KB test_2.csv 1KB test_1_deleteOneRow.csv 1KB test_1_deleteOneColumn.csv 1KB test_1_deleteRows_1.csv 1KB test_1_deleteColumns_1.csv 1KB test_3_insertColumns_1.csv 953B test_3_insertRows_1.csv 875B test_1_deleteRows_2.csv 781B test_1_deleteColumns_2.csv 766B test_3.csv 761B test_3.csv 761B copy_1.csv 761B test_3.csv 761B
inherit.gif 57B
Sheet.html 37KB SheetImp.html 35KB Cell.html 32KB SheetReader.html 18KB Cell.html 16KB Letters.html 16KB CSVFactory.html 15KB SheetWriter.html 15KB Sheet.html 13KB CellValueConvert.html 13KB index-16.html 12KB DataConvert.html 12KB index-7.html 12KB index-3.html 11KB SheetFactory.html 11KB OutRangeExcetion.html 11KB Position.html 11KB constant-values.html 10KB index-15.html 10KB Position.html 9KB index-4.html 9KB index-9.html 9KB help-doc.html 8KB index-6.html 8KB package-use.html 8KB index-12.html 8KB package-summary.html 7KB index-11.html 7KB index-10.html 7KB index-1.html 7KB SheetFactory.html 7KB index-13.html 7KB index-2.html 7KB index-8.html 7KB overview-tree.html 7KB index-20.html 7KB package-tree.html 7KB index-17.html 7KB index-19.html 6KB index-14.html 6KB index-5.html 6KB index-18.html 6KB package-summary.html 6KB serialized-form.html 6KB package-tree.html 6KB OutRangeExcetion.html 6KB SheetReader.html 6KB SheetWriter.html 6KB CSVFactory.html 6KB共 130 条
- 1
- 2
- 1
- 2
- 3
前往页