public void TestReadRowWithUseCellType()
{
var dataTable = new DataTable();
dataTable.Columns.Add("列1");
dataTable.Columns.Add("列2");
dataTable.Columns.Add("列3");
dataTable.Columns.Add("列4");
dataTable.Columns.Add("列5");
string dataFilePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "file", "forread.xlsx");
NPOIOperator oper = new NPOIOperator(dataFilePath, true);
var sheet = oper.GetSheet(0);
var row = sheet.GetRow(2);
var rowData = oper.ReadRow(row, dataTable.Columns, true);
Assert.AreEqual(5, rowData.Length);
Assert.AreEqual("李四", rowData[1]);
Assert.AreEqual(new DateTime(1984, 5, 26), rowData[4]);
}
public void TestReadRow()
{
var dt = GetTestData();
string dataFilePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "file", "forread.xlsx");
NPOIOperator oper = new NPOIOperator(dataFilePath, true);
var sheet = oper.GetSheet(0);
var row = sheet.GetRow(2);
var rowData = oper.ReadRow(row, dt.Columns);
Assert.AreEqual(5, rowData.Length);
Assert.AreEqual("李四", rowData[1]);
Assert.AreEqual(new DateTime(1984, 5, 26), rowData[4]);
}