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)); } } } }