public WriteLine ( IEnumerable |
||
values | IEnumerable |
|
Результат | bool |
public bool WriteLine(IEnumerable<string> values)
{
if ((_outputStream == null) || (!_outputStream.BaseStream.CanWrite))
return false;
_line.Length = 0;
if (values != null)
{
bool onceThru = false;
foreach (string s in values)
{
if (onceThru)
_line.Append(this._splitChars);
_line.Append(QuoteAndEscape(s));
onceThru = true;
}
}
_outputStream.WriteLine(_line.ToString());
_line.Length = 0;
return true;
}
CommaSeparatedValueWriter::WriteLine ( string line ) : bool |
public void ReadExcelFile() { FileStream input = new FileStream(InputFile, FileMode.Open, FileAccess.Read); IExcelDataReader reader = ExcelReaderFactory.CreateBinaryReader(input); IDataFileWriter writer = new CommaSeparatedValueWriter(OutputFile); reader.IsFirstRowAsColumnNames = false; DataSet result = reader.AsDataSet(); foreach (DataTable t in result.Tables) { writer.WriteLine(new string[] { t.TableName }); List<string> columns = new List<string>(); foreach (DataColumn column in t.Columns) { columns.Add(column.ColumnName); } writer.WriteLine(columns); foreach (DataRow row in t.Rows) { List<string> fields = new List<string>(); foreach (object f in row.ItemArray) { fields.Add(f.ToString()); } writer.WriteLine(fields); } writer.WriteLine(null); } writer.Close(); reader.Close(); Assert.AreEqual(File.ReadAllText(OutputFile), File.ReadAllText(CheckFile)); }