public void CustomersWrite()
{
ExcelStorage provider = new ExcelStorage(typeof(CustomersVerticalBar));
provider.StartRow = 3;
provider.StartColumn = 2;
provider.FileName = @"..\data\Excel\Customers.xls";
object[] res = provider.ExtractRecords();
long start = DateTime.Now.Ticks;
provider.FileName = @"salida.xls";
provider.StartRow = 10;
provider.StartColumn = 5;
provider.InsertRecords(res);
TimeSpan ts = new TimeSpan(DateTime.Now.Ticks - start);
Console.WriteLine(ts.TotalSeconds);
if (File.Exists(@"salida.xls"))
{
File.Delete(@"salida.xls");
}
}
public void OrdersWrite()
{
FileHelperEngine engine = new FileHelperEngine(typeof(OrdersExcelType));
OrdersExcelType[] resFile = (OrdersExcelType[])Common.ReadTest(engine, @"Good\OrdersWithOutDates.txt");
ExcelStorage provider = new ExcelStorage(typeof(OrdersExcelType));
provider.StartRow = 1;
provider.StartColumn = 1;
provider.FileName = @"c:\tempex.xls";
provider.OverrideFile = true;
provider.InsertRecords(resFile);
OrdersExcelType[] res = (OrdersExcelType[])provider.ExtractRecords();
if (File.Exists(@"c:\tempex.xls"))
{
File.Delete(@"c:\tempex.xls");
}
Assert.AreEqual(resFile.Length, res.Length);
for (int i = 0; i < res.Length; i++)
{
Assert.AreEqual(resFile[i].CustomerID, res[i].CustomerID);
Assert.AreEqual(resFile[i].EmployeeID, res[i].EmployeeID);
Assert.AreEqual(resFile[i].Freight, res[i].Freight);
Assert.AreEqual(resFile[i].OrderID, res[i].OrderID);
Assert.AreEqual(resFile[i].ShipVia, res[i].ShipVia);
}
}
static void Main(string[] args)
{
// create some data to export
MyClass[] rows = new MyClass[2] {
new MyClass()
{
Field1 = "Apples", Field2 = 23, Field3 = "Yes"
},
new MyClass()
{
Field1 = "Oranges", Field2 = 17, Field3 = "No"
}
};
ExcelStorage provider = new ExcelStorage(typeof(MyClass));
// Set the destination Excel spreadsheet
provider.FileName = @"MyClass.xlsx";
// Template.xlsx contains just the column headers on row 1
provider.TemplateFile = @"Template.xlsx";
// StartRow is after the header row
provider.StartRow = 2;
provider.OverrideFile = true;
provider.InsertRecords(rows);
}
public void NoTemplate()
{
ExcelStorage provider = new ExcelStorage(typeof(CustomersVerticalBar), 1, 1);
provider.TemplateFile = @"..\the template is not there.xls";
provider.FileName = @"output.xls";
provider.InsertRecords(new object[] { new CustomersVerticalBar() });
}