当前位置: 首页>>代码示例>>C#>>正文


C# CsvWriter.WriteRecord方法代码示例

本文整理汇总了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() );
            }
        }
开发者ID:ravensorb,项目名称:CsvHelper,代码行数:31,代码来源:DynamicTests.cs

示例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" } );
     }
 }
开发者ID:heyyan,项目名称:CsvHelper,代码行数:10,代码来源:CsvWriterTests.cs

示例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"));
            }
        }
开发者ID:alin-rautoiu,项目名称:Cart42,代码行数:26,代码来源:DataExportService.cs

示例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");
        }
开发者ID:NicolasDorier,项目名称:userassist,代码行数:29,代码来源:UnitTest1.cs

示例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);
        }
开发者ID:saca-ae,项目名称:SACA-AE_Web-App_v2,代码行数:40,代码来源:CSVController.cs

示例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);
                }
            }
        }
开发者ID:bevacqua,项目名称:MarianX,代码行数:35,代码来源:Persistance.cs

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

            }
        }
开发者ID:adwardliu,项目名称:vc-community,代码行数:29,代码来源:ImportExportTest.cs

示例8: ExportRecord

        public void ExportRecord(Record record, TextWriter writer)
        {
            var csv = new CsvWriter(writer);

            TopcatMapping.ApplyStandardTopcatCsvConfiguration(csv.Configuration);

            csv.WriteRecord(record);
        }
开发者ID:jncc,项目名称:topcat,代码行数:8,代码来源:Exporter.cs

示例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);
         }
     }
 }
开发者ID:andrewtovkach,项目名称:EpamTraining,代码行数:12,代码来源:ReadWriter.cs

示例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 );
        }
开发者ID:heinrichbreedt,项目名称:CsvHelper,代码行数:13,代码来源:CsvWriterTests.cs

示例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 );
            }
        }
开发者ID:BeHype,项目名称:CsvHelper,代码行数:22,代码来源:CsvWriterTests.cs

示例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();
     }
 }
开发者ID:NicolasDorier,项目名称:userassist,代码行数:14,代码来源:Extensions.cs

示例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);
            }
        }
开发者ID:mujiansu,项目名称:KBCsv,代码行数:16,代码来源:WritePerformanceFixture.cs

示例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);
            }
        }
开发者ID:mujiansu,项目名称:KBCsv,代码行数:16,代码来源:WritePerformanceFixture.cs


注:本文中的CsvWriter.WriteRecord方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。