public void TestGetSource_SheetNotFoundException()
{
const string fileName = "./Internal Resources/sample.xls";
var filter = new ProviderFilter();
filter.FileName = fileName;
filter.SheetName = "Sheet1";
IProvider provider = new NPOIProvider(filter);
var dataTable = provider.GetSource();
}
public void TestInstance()
{
var filter = new ProviderFilter();
filter.FileName = ExcelFileName;
IProvider viewProvider = new NPOIProvider(filter);
IProvider workProvider = new NPOIProvider(filter);
Worker worker = new Worker(viewProvider, workProvider, PythonFileName);
}
public void TestGetSource_SheetNotFoundException()
{
const string fileName = "./Internal Resources/sample.xls";
var filter = new ProviderFilter();
filter.FileName = fileName;
filter.SheetName = "Sheet1";
IProvider provider = new NPOIProvider(filter);
var dataTable = provider.GetSource();
}
public void TestDo()
{
var filter = new ProviderFilter();
filter.FileName = ExcelFileName;
filter.SetColumnType = true;
IProvider viewProvider = new NPOIProvider(filter);
IProvider workProvider = new NPOIProvider(filter);
Worker worker = new Worker(viewProvider, workProvider, PythonFileName);
worker.DataTableBefore += new SetDataTableBefore(worker_DataTableBefore);
worker.DataTableAfter += new SetDataTableAfter(worker_DataTableAfter);
worker.Do();
}
public void TestGetSource()
{
const string fileName = "./Internal Resources/sample.xls";
var filter = new ProviderFilter();
filter.FileName = fileName;
filter.SheetName = "Лист1";
IProvider provider = new NPOIProvider(filter);
var dataTable = provider.GetSource();
Assert.That(dataTable.Columns.Count, Is.EqualTo(2));
Assert.That(dataTable.Columns[0].ColumnName, Is.EqualTo("A"));
Assert.That(dataTable.Columns[1].ColumnName, Is.EqualTo("B"));
Assert.That(dataTable.Rows.Count, Is.EqualTo(6));
}
public void TestGetSource()
{
const string fileName = "./Internal Resources/sample.xls";
var filter = new ProviderFilter();
filter.FileName = fileName;
filter.SheetName = "Лист1";
IProvider provider = new NPOIProvider(filter);
var dataTable = provider.GetSource();
Assert.That(dataTable.Columns.Count, Is.EqualTo(2));
Assert.That(dataTable.Columns[0].ColumnName, Is.EqualTo("A"));
Assert.That(dataTable.Columns[1].ColumnName, Is.EqualTo("B"));
Assert.That(dataTable.Rows.Count, Is.EqualTo(6));
}
public void TestInstance()
{
var filter = new ProviderFilter();
IProvider provider = new NPOIProvider(filter);
}
public void TestInstance()
{
var filter = new ProviderFilter();
IProvider provider = new NPOIProvider(filter);
}
public JsonResult SearchUseNPOI(string searchName)
{
var data = new NPOIProvider(Server.MapPath("~/App_Data/test.xlsx")).SearchRow(searchName);
return(Json(data));
}
