public void ExcelDataReaderGetSchemaTable_DataConversion()
{
ExcelFile setting = new ExcelFile();
setting.FileName = System.IO.Path.Combine(m_ApplicationDirectory, "BasicExcel.xls");
setting.SheetName = "Basic";
Column columnFormat = new Column()
{
Name = "IsNativeLang", DataType = DataType.Boolean
};
setting.ColumnAdd(columnFormat);
using (ExcelFileReaderInterop test = new ExcelFileReaderInterop())
{
test.Open(m_ValidSetting, CancellationToken.None, true);
var dt = test.GetSchemaTable();
foreach (System.Data.DataRow dataRow in dt.Rows)
{
if (columnFormat.Name.Equals((string)dataRow[System.Data.Common.SchemaTableColumn.ColumnName], StringComparison.OrdinalIgnoreCase))
{
Assert.ReferenceEquals(dataRow[System.Data.Common.SchemaTableColumn.DataType], columnFormat.DataType.GetNetType());
}
}
}
}
public void ExcelDataReaderGetSchemaTable_NoDataConversion()
{
ExcelFile setting = new ExcelFile();
setting.FileName = System.IO.Path.Combine(m_ApplicationDirectory, "BasicExcel.xls");
setting.SheetName = "Basic";
using (ExcelFileReaderInterop test = new ExcelFileReaderInterop())
{
test.Open(setting, CancellationToken.None, true);
var dt = test.GetSchemaTable();
foreach (System.Data.DataRow dataRow in dt.Rows)
{
if (((string)dataRow[System.Data.Common.SchemaTableColumn.ColumnName]).Equals("IsNativeLang", StringComparison.OrdinalIgnoreCase))
{
Assert.ReferenceEquals(dataRow[System.Data.Common.SchemaTableColumn.DataType], typeof(bool));
}
}
}
}
