public void OrdersRead1()
{
ExcelStorageOleDb provider = new ExcelStorageOleDb(typeof(OrdersExcelType), 1, 1);
provider.FileName = @"..\data\Excel\Orders.xls";
object[] res = provider.ExtractRecords();
Assert.AreEqual(830, res.Length);
}
public void OneColumn()
{
ExcelStorageOleDb provider = new ExcelStorageOleDb(typeof(OneColumnType), 1, 1);
provider.FileName = @"..\data\Excel\OneColumn.xls";
object[] res = provider.ExtractRecords();
Assert.AreEqual(50, res.Length);
}
/// <summary>Create a new instance of the class.</summary>
/// <param name="provider">
/// The <see cref="FileHelpers.Storage.DataStorageperforms the transformation.
/// </param>
public ExcelDataLinkOleDb(DataStorage provider)
{
mProvider = provider;
if (mProvider != null)
{
mExcelStorage = new ExcelStorageOleDb(provider.RecordType);
}
else
{
throw new ArgumentException("provider can´t be null", "provider");
}
}
public void OrdersRead2()
{
DataTable dt = ExcelStorageOleDb.ExtractDataTable(@"..\data\Excel\Orders.xls", 1, 1, false);
Assert.AreEqual(830, dt.Rows.Count);
}
