本文整理汇总了C#中CsvWriter.WriteRecord方法的典型用法代码示例。如果您正苦于以下问题:C# CsvWriter.WriteRecord方法的具体用法?C# CsvWriter.WriteRecord怎么用?C# CsvWriter.WriteRecord使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类CsvWriter
的用法示例。
在下文中一共展示了CsvWriter.WriteRecord方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: WriteDynamicExpandoObjectTest
public void WriteDynamicExpandoObjectTest()
{
using( var stream = new MemoryStream() )
using( var reader = new StreamReader( stream ) )
using( var writer = new StreamWriter( stream ) )
using( var csv = new CsvWriter( writer ) )
{
dynamic obj = new ExpandoObject();
obj.Id = 1;
obj.Name = "one";
csv.WriteRecord( obj );
csv.NextRecord();
obj = new ExpandoObject();
obj.Id = 2;
obj.Name = "two";
csv.WriteRecord( obj );
csv.NextRecord();
writer.Flush();
stream.Position = 0;
var expected = "Id,Name\r\n";
expected += "1,one\r\n";
expected += "2,two\r\n";
Assert.AreEqual( expected, reader.ReadToEnd() );
}
}
示例2: WriteRecordNonGenericTest
public void WriteRecordNonGenericTest()
{
using( var stream = new MemoryStream() )
using( var writer = new StreamWriter( stream ) )
using( var csv = new CsvWriter( writer ) )
{
csv.WriteRecord( typeof( Test ), new Test { Id = 1, Name = "one" } );
csv.WriteRecord( typeof( Test ), new Test { Id = 2, Name = "two" } );
}
}
示例3: ExportCategories
public void ExportCategories(string path, bool zipIt = true)
{
var fileName = "Categories_" + DateTime.Now.ToString("yyyyMMddTHHmmss");
using (var file = File.CreateText(Path.Combine(path, fileName + ".csv")))
{
var csv = new CsvWriter(file);
csv.Configuration.RegisterClassMap<CategoryCsvMap>();
csv.WriteHeader<Category>();
foreach (var category in categoryService.FindAll().OrderBy(c => c.Id).InChunksOf(100))
{
csv.WriteRecord(category);
}
}
if (zipIt)
{
using (var zip = new ZipFile(Path.Combine(path, fileName + ".zip")))
{
zip.AddFile(Path.Combine(path, fileName + ".csv"), "").FileName = "Categories.csv";
zip.Save();
}
File.Delete(Path.Combine(path, fileName + ".csv"));
}
}
示例4: CompareChangingValues
public void CompareChangingValues()
{
UserAssist assist = new UserAssist();
using(CsvWriter writer = new CsvWriter(new StreamWriter(File.Open("ChangingValues.csv", FileMode.Create))))
{
writer.WriteHeader<ValueLetter>();
var snap1Values =
assist.Snapshot("snap1.csv")
.FindProgram("cmd.exe")
.GetValue();
WaitOpenThenKill("cmd.exe");
var snap2Values = assist.Snapshot("snap2.csv")
.FindProgram("cmd.exe")
.GetValue();
for(int i = 0 ; i < snap1Values.Length ; i++)
{
writer.WriteRecord(new ValueLetter()
{
Position = i,
Value1 = snap1Values[i].ToString("X2"),
Value2 = snap2Values[i].ToString("X2"),
IsDiff = (snap1Values[i] != snap2Values[i]) ? "x" : ""
});
}
}
Process.Start("ChangingValues.csv");
}
示例5: DownloadCSVTemplate
/// <summary>
/// Downloads the CSV template for assignments.
/// </summary>
/// <author> Cristian Araya Fuentes </author>
/// <returns> Csv file </returns>
public FileResult DownloadCSVTemplate()
{
String vTemplateFileName = "plantillaAsignacion.csv";
byte[] vFileSize;
int vIDEntity = getEntityID(Request.Cookies["Entidad"].Value);
int vIDPeriod = Int32.Parse(Request.Cookies["Periodo"].Value);
IEnumerable<DataCSV> vGroups = getGroupesPeriod(vIDPeriod, vIDEntity);
using (Stream memoryStream = new MemoryStream())
{
StreamWriter streamWriter = new StreamWriter(memoryStream, Encoding.UTF8);
var vWriter = new CsvWriter(streamWriter);
vWriter.Configuration.Encoding = Encoding.UTF8;
//Write the CSV's file header
vWriter.WriteHeader(typeof(DataCSV));
//Write each group
foreach (DataCSV group in vGroups)
{
vWriter.WriteRecord(group);
}
vWriter.NextRecord();
streamWriter.Flush();
memoryStream.Flush();
memoryStream.Position = 0;
vFileSize = new byte[memoryStream.Length];
memoryStream.Read(vFileSize, 0, vFileSize.Length);
streamWriter.Close();
streamWriter.Dispose();
}
return File(vFileSize, System.Net.Mime.MediaTypeNames.Application.Octet, vTemplateFileName);
}
示例6: SaveTileMatrix
public void SaveTileMatrix(TileType[,] map, string path)
{
IList<TileRecord> records = new List<TileRecord>();
int cols = map.GetLength(0);
int rows = map.GetLength(1);
for (int x = 0; x < cols; x++)
{
for (int y = 0; y < rows; y++)
{
TileType type = map[x, y];
TileRecord record = Mapper.Map<TileType, TileRecord>(type);
record.X = x;
record.Y = y;
records.Add(record);
}
}
if (File.Exists(path))
{
File.Delete(path);
}
using (Stream stream = File.OpenWrite(path))
using (TextWriter textWriter = new StreamWriter(stream))
using (CsvWriter csvWriter = new CsvWriter(textWriter))
{
foreach (TileRecord record in records)
{
csvWriter.WriteRecord(record);
}
}
}
示例7: ExportProductsTest
public void ExportProductsTest()
{
var searchService = GetSearchService();
var categoryService = GetCategoryService();
var itemService = GetItemService();
var result = searchService.Search(new SearchCriteria { CatalogId = "Sony", CategoryId = "66b58f4c-fd62-4c17-ab3b-2fb22e82704a", Skip = 0, Take = 10, ResponseGroup = coreModel.SearchResponseGroup.WithProducts });
var importConfiguration = GetMapConfiguration();
using (var csvWriter = new CsvWriter(new StreamWriter(@"c:\Projects\VCF\vc-community\PLATFORM\Modules\Catalog\VirtoCommerce.CatalogModule.Test\products.csv")))
{
var csvProducts = new List<CsvProduct>();
foreach (var product in result.Products)
{
var fullLoadedProduct = itemService.GetById(product.Id, ItemResponseGroup.ItemLarge);
csvProducts.Add(new CsvProduct(fullLoadedProduct, null, null, null));
}
importConfiguration.PropertyCsvColumns = csvProducts.SelectMany(x => x.PropertyValues).Select(x => x.PropertyName).Distinct().ToArray();
csvWriter.Configuration.Delimiter = ";";
csvWriter.Configuration.RegisterClassMap(new CsvProductMap(importConfiguration));
csvWriter.WriteHeader<CsvProduct>();
foreach (var product in csvProducts)
{
csvWriter.WriteRecord(product);
}
}
}
示例8: ExportRecord
public void ExportRecord(Record record, TextWriter writer)
{
var csv = new CsvWriter(writer);
TopcatMapping.ApplyStandardTopcatCsvConfiguration(csv.Configuration);
csv.WriteRecord(record);
}
示例9: WriteCSPStreamEvent
public void WriteCSPStreamEvent(CSPStreamEvent cspEvent)
{
using (var sw = new StreamWriter(logFile, true))
using (var csv = new CsvWriter(sw))
{
csv.WriteRecord(cspEvent);
}
}
开发者ID:PartnerCenterSamples,项目名称:Commerce-API-SubscriptionStream-DotNet,代码行数:9,代码来源:FileSystemLocalCSPStreamManager.cs
示例10: Write
public void Write(IEnumerable<DataRecord> list)
{
using (var streamWriter = new StreamWriter(FilePath, false, Encoding.Default))
{
var csvWriter = new CsvWriter(streamWriter);
csvWriter.WriteHeader<DataRecord>();
foreach (var item in list)
{
csvWriter.WriteRecord(item);
}
}
}
示例11: WriteRecordNoHeaderTest
public void WriteRecordNoHeaderTest()
{
var stream = new MemoryStream();
var writer = new StreamWriter( stream );
var csv = new CsvWriter( writer, new CsvWriterOptions{ HasHeaderRecord = false } );
csv.WriteRecord( new TestRecord() );
stream.Position = 0;
var reader = new StreamReader( stream );
var csvFile = reader.ReadToEnd();
Assert.AreEqual( ",0,test,\r\n", csvFile );
}
示例12: WriteRecordNonGenericTest
public void WriteRecordNonGenericTest()
{
using( var stream = new MemoryStream() )
using( var writer = new StreamWriter( stream ) )
using( var reader = new StreamReader( stream ) )
using( var csv = new CsvWriter( writer ) )
{
csv.WriteRecord( typeof( Test ), new Test { Id = 1, Name = "one" } );
csv.WriteRecord( typeof( Test ), new Test { Id = 2, Name = "two" } );
writer.Flush();
stream.Position = 0;
var text = reader.ReadToEnd();
var expected = new StringBuilder();
expected.AppendLine( "1,one" );
expected.AppendLine( "2,two" );
Assert.AreEqual( expected.ToString(), text );
}
}
示例13: WriteTo
public static void WriteTo(this DiffResult result, string file)
{
using(var fs = File.Open(file, FileMode.Create))
{
var streamWriter = new StreamWriter(fs);
CsvWriter writer = new CsvWriter(streamWriter);
writer.WriteHeader(typeof(DiffBlock));
foreach(var block in result.DiffBlocks)
{
writer.WriteRecord(block);
}
streamWriter.Flush();
}
}
示例14: write_plain_csv
public void write_plain_csv(bool forceDelimit)
{
var repeatCount = 200000;
using (var csvWriter = new CsvWriter(new StringWriter()))
{
csvWriter.ForceDelimit = forceDelimit;
foreach (var record in Data.PlainDataValues.Repeat(repeatCount))
{
csvWriter.WriteRecord(record);
}
Assert.Equal(3 * repeatCount, csvWriter.RecordNumber);
}
}
示例15: write_csv_with_copious_escaped_delimiters
public void write_csv_with_copious_escaped_delimiters(bool forceDelimit)
{
var repeatCount = 1000000;
using (var csvWriter = new CsvWriter(new StringWriter()))
{
csvWriter.ForceDelimit = forceDelimit;
foreach (var record in Data.CopiousEscapedDelimitersValues.Repeat(repeatCount))
{
csvWriter.WriteRecord(record);
}
Assert.Equal(repeatCount, csvWriter.RecordNumber);
}
}