/**
*
*/
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
共130个文件
html:62个
csv:34个
class:14个
5星 · 超过95%的资源 需积分: 10 148 下载量 119 浏览量
2010-04-17
21:45:23
上传
评论 2
收藏 180KB RAR 举报
温馨提示
本接口 可以 处理 csv文件 能实现csv文件的读和写,另外还提供相应的数据转化。可以实现对csv文件的修改,具有插入,删除,替换等操作接口。
资源推荐
资源详情
资源评论
收起资源包目录
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
test_1_replaceAllString_1.csv 1KB
copy_2.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
liuqingh0
- 粉丝: 0
- 资源: 3
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
- 3
前往页