Unlock 30% off on Manual Testing Annual Plans this Holiday Season.

Copied to Clipboard!

How to use CsvWriter class of NBi.Core.FlatFile package

Best NBi code snippet using NBi.Core.FlatFile.CsvWriter

CsvWriterTest.cs

Source:CsvWriterTest.cs

...9using System.Text;10using System.Threading.Tasks;11namespace NBi.Testing.Core.FlatFile12{13    class CsvWriterTest14    {15        private void Load(DataTable table, string[] rows, string columnNames)16        {17            var columns = columnNames.Split(',');18            for (int i = 0; i < columns.Length; i++)19                table.Columns.Add(new DataColumn(columns[i]));20            foreach (var row in rows)21            {22                var newRow = table.NewRow();23                newRow.ItemArray = row.Split(',');24                table.Rows.Add(newRow);25            }26            table.AcceptChanges();27        }28        private CsvProfile Csv = CsvProfile.SemiColumnDoubleQuote;29        [Test]30        public void Write_TwoRowsWithHeader_ThreeLines()31        {32            var table = new DataTable();33            Load(table, new string[] { "a11,a12", "a21,a22" }, "alpha1,alpha2");34            var csvWriter = new CsvWriter(true);35            using (MemoryStream stream = new MemoryStream())36            {37                StreamWriter streamWriter = new StreamWriter(stream);38                csvWriter.Write(table, streamWriter);39                stream.Position = 0;40                using (StreamReader streamReader = new StreamReader(stream))41                {42                    var text = streamReader.ReadToEnd();43                    text.Remove(text.Length - 2); //Avoid miscount if last line as a record separator or not44                    var countLine = text.Count(c => c == Csv.RecordSeparator[0]);45                    Assert.That(countLine, Is.EqualTo(3));46                }47            }48        }49        [Test]50        public void Write_TwoRowsWithoutHeader_TwoLines()51        {52            var table = new DataTable();53            Load(table, new string[] { "a11,a12", "a21,a22" }, "alpha1,alpha2");54            var csvWriter = new CsvWriter(false);55            using (MemoryStream stream = new MemoryStream())56            {57                StreamWriter streamWriter = new StreamWriter(stream);58                csvWriter.Write(table, streamWriter);59                60                stream.Position = 0;61                using (StreamReader streamReader = new StreamReader(stream))62                {63                    var text = streamReader.ReadToEnd();64                    text.Remove(text.Length - 2); //Avoid miscount if last line as a record separator or not65                    var countLine = text.Count(c => c == Csv.RecordSeparator[0]);66                    Assert.That(countLine, Is.EqualTo(2));67                }68            }69        }70        [Test]71        public void Write_TwoRowsWithoutHeader_AllLinesHaveTwoFieldSeparator()72        {73            var table = new DataTable();74            Load(table, new string[] { "a11,a12,a13", "a21,a22,a23" }, "alpha1,alpha2,alpha3");75            var csvWriter = new CsvWriter(false);76            using (MemoryStream stream = new MemoryStream())77            {78                StreamWriter streamWriter = new StreamWriter(stream);79                csvWriter.Write(table, streamWriter);80                stream.Position = 0;81                using (StreamReader streamReader = new StreamReader(stream))82                {83                    var text = streamReader.ReadToEnd();84                    var lines = text.Split(new string[] {Csv.RecordSeparator}, StringSplitOptions.RemoveEmptyEntries);85                    foreach (var line in lines)86                    {87                        var countLine = line.Count(c => c == Csv.FieldSeparator);88                        Assert.That(countLine, Is.EqualTo(2));89                    }90                }91            }92        }93        [Test]94        public void Write_TwoRowsWithHeader_HeaderIsCorrect()95        {96            var table = new DataTable();97            var columnNames = "alpha1,alpha2,alpha3";98            Load(table, new string[] { "a11,a12,a13", "a21,a22,a23" }, columnNames);99            var csvWriter = new CsvWriter(true);100            using (MemoryStream stream = new MemoryStream())101            {102                StreamWriter streamWriter = new StreamWriter(stream);103                csvWriter.Write(table, streamWriter);104                stream.Position = 0;105                using (StreamReader streamReader = new StreamReader(stream))106                {107                    var text = streamReader.ReadToEnd();108                    var lines = text.Split(new string[] { Csv.RecordSeparator }, StringSplitOptions.RemoveEmptyEntries);109                    var lineHeader = lines[0];110                    var fields = lineHeader.Split(Csv.FieldSeparator);111                    Assert.That(fields, Is.EqualTo(columnNames.Split(','))); 112                }113            }114        }115        [Test]116        public void Write_OneRowNeedQuoting_CorrectlyQuoted()117        {118            var table = new DataTable();119            Load(table, new string[] { "a;11" }, "alpha1");120            var csvWriter = new CsvWriter(false);121            using (MemoryStream stream = new MemoryStream())122            {123                StreamWriter streamWriter = new StreamWriter(stream);124                csvWriter.Write(table, streamWriter);125                stream.Position = 0;126                using (StreamReader streamReader = new StreamReader(stream))127                {128                    var text = streamReader.ReadToEnd();129                    var firstCell= text.Split(new string[] { Csv.RecordSeparator }, StringSplitOptions.RemoveEmptyEntries)[0];130                    Assert.That(firstCell, Does.StartWith(Csv.TextQualifier.ToString()));131                    Assert.That(firstCell, Does.EndWith(Csv.TextQualifier.ToString()));132                    Assert.That(firstCell, Does.Contain(Csv.FieldSeparator.ToString()));133                }134            }135        }136        [Test]137        public void Write_OneRowDontNeedQuoting_CorrectlyNotQuoted()138        {139            var table = new DataTable();140            Load(table, new string[] { "a11" }, "alpha1");141            var csvWriter = new CsvWriter(false);142            using (MemoryStream stream = new MemoryStream())143            {144                StreamWriter streamWriter = new StreamWriter(stream);145                csvWriter.Write(table, streamWriter);146                stream.Position = 0;147                using (StreamReader streamReader = new StreamReader(stream))148                {149                    var text = streamReader.ReadToEnd();150                    var firstCell = text.Split(new string[] { Csv.RecordSeparator }, StringSplitOptions.RemoveEmptyEntries)[0];151                    Assert.That(firstCell, Does.Not.StartsWith(Csv.TextQualifier.ToString()));152                    Assert.That(firstCell, Does.Not.EndsWith(Csv.TextQualifier.ToString()));153                    Assert.That(firstCell, Does.Not.Contain(Csv.FieldSeparator.ToString()));154                }155            }...

SaveCaseAction.cs

Source:SaveCaseAction.cs

...16        public void Execute(GenerationState state) => Execute(state.CaseCollection.CurrentScope);1718        public void Execute(CaseSet testCases)19        {20            var csvWriter = new CsvWriter(true);21            csvWriter.Write(testCases.Content, Filename);22        }2324        public virtual string Display25        {26            get27            {28                return string.Format("Saving the test cases into '{0}'", Filename);29            }30        }31    }32}
...

CsvWriter

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core.FlatFile;7using System.IO;8{9    {10        static void Main(string[] args)11        {12            CsvWriter writer = new CsvWriter();13            writer.Separator = ',';14            writer.Encoding = Encoding.UTF8;15";16            writer.Quote = '"';17            writer.QuoteMode = QuoteMode.Always;18            writer.Path = @"C:\Users\Public\Documents\test.csv";19            writer.Write(new[] { "1", "2", "3" });20            writer.Write(new[] { "4", "5", "6" });21            writer.Write(new[] { "7", "8", "9" });22        }23    }24}25public void CsvWriterTest()26{27    var writer = new CsvWriter();28    writer.Separator = ',';29    writer.Encoding = Encoding.UTF8;30";31    writer.Quote = '"';32    writer.QuoteMode = QuoteMode.Always;33    writer.Path = @"C:\Users\Public\Documents\test.csv";34    writer.Write(new[] { "1", "2", "3" });35    writer.Write(new[] { "4", "5", "6" });36    writer.Write(new[] { "7", "8", "9" });37}

CsvWriter

Using AI Code Generation

1using NBi.Core.FlatFile;2using System;3using System.Collections.Generic;4using System.Linq;5using System.Text;6using System.Threading.Tasks;7{8    {9        static void Main(string[] args)10        {11            CsvWriter writer = new CsvWriter(@"C:\temp\test.csv", true, Encoding.UTF8);12            writer.WriteRow(new string[] { "Col1", "Col2" });13            writer.WriteRow(new string[] { "a", "b" });14            writer.WriteRow(new string[] { "c", "d" });15            writer.Close();16        }17    }18}19public CsvWriter(string path, bool withHeader, Encoding encoding)20public void WriteRow(string[] values)21public void Close()22using NBi.Core.FlatFile;23using System;24using System.Collections.Generic;25using System.IO;26using System.Linq;27using System.Text;28using System.Threading.Tasks;29{30    {31        static void Main(string[] args)32        {33            CsvWriter writer = new CsvWriter(true, Encoding.UTF8);34            writer.WriteRow(new string[] { "Col1", "Col2" });35            writer.WriteRow(new string[] { "a", "b" });36            writer.WriteRow(new string[] { "c", "d" });

CsvWriter

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core.FlatFile;7using NBi.Core.Scalar.Resolver;8using NBi.Core.ResultSet;9using NBi.Core.ResultSet.Resolver;10{11    {12        static void Main(string[] args)13        {14            var csvWriter = new CsvWriter(new FilePathResolver("C:\\Users\\user\\Desktop\\test.csv"));15            var resultSet = new ResultSet();16            resultSet.Columns.Add(new Column("col1"));17            resultSet.Columns.Add(new Column("col2"));18            resultSet.Columns.Add(new Column("col3"));19            resultSet.Rows.Add(new Row(new List<object> { 1, "A", 10.0 }));20            resultSet.Rows.Add(new Row(new List<object> { 2, "B", 20.0 }));21            resultSet.Rows.Add(new Row(new List<object> { 3, "C", 30.0 }));22            resultSet.Rows.Add(new Row(new List<object> { 4, "D", 40.0 }));23            resultSet.Rows.Add(new Row(new List<object> { 5, "E", 50.0 }));24            csvWriter.Write(resultSet);25        }26    }27}

CsvWriter

Using AI Code Generation

1using NBi.Core.FlatFile;2using System.IO;3using System.Text;4{5    {6        static void Main(string[] args)7        {8            var writer = new CsvWriter(new StreamWriter(@"C:\temp\test.csv", false, Encoding.UTF8), true);9            writer.Write("test");10            writer.Write("test2");11            writer.WriteLine();12            writer.Write("test3");13            writer.Write("test4");14            writer.WriteLine();15            writer.Flush();16        }17    }18}

CsvWriter

Using AI Code Generation

1var reader = new CsvReader(@"C:\temp\1.csv");2var writer = new CsvWriter(@"C:\temp\2.csv");3var columns = new List<string>();4columns.Add("col1");5columns.Add("col2");6columns.Add("col3");7columns.Add("col4");8columns.Add("col5");9columns.Add("col6");10columns.Add("col7");11columns.Add("col8");12columns.Add("col9");13columns.Add("col10");14columns.Add("col11");15columns.Add("col12");16columns.Add("col13");17columns.Add("col14");18columns.Add("col15");19columns.Add("col16");20columns.Add("col17");21columns.Add("col18");22columns.Add("col19");23columns.Add("col20");24columns.Add("col21");25columns.Add("col22");26columns.Add("col23");27columns.Add("col24");28columns.Add("col25");29columns.Add("col26");30columns.Add("col27");31columns.Add("col28");32columns.Add("col29");33columns.Add("col30");34columns.Add("col31");35columns.Add("col32");36columns.Add("col33");37columns.Add("col34");38columns.Add("col35");39columns.Add("col36");40columns.Add("col37");41columns.Add("col38");42columns.Add("col39");43columns.Add("col40");44columns.Add("col41");45columns.Add("col42");46columns.Add("col43");47columns.Add("col44");48columns.Add("col45");49columns.Add("col46");50columns.Add("col47");51columns.Add("col48");52columns.Add("col49");53columns.Add("col50");54columns.Add("col51");55columns.Add("col52");56columns.Add("col53");57columns.Add("col54");58columns.Add("col55");59columns.Add("col56");60columns.Add("col57");61columns.Add("col58");62columns.Add("col59");63columns.Add("col60");64columns.Add("col61");65columns.Add("col62");66columns.Add("col63");67columns.Add("col64");68columns.Add("col65");69columns.Add("col66");70columns.Add("col67");71columns.Add("col68");72columns.Add("col69");73columns.Add("col70");74columns.Add("col71");75columns.Add("col72");76columns.Add("col73");77columns.Add("col74");78columns.Add("col75");79columns.Add("col76");80columns.Add("col77");

CsvWriter

Using AI Code Generation

1import { NgModule } from '@angular/core';2import { CommonModule } from '@angular/common';3import { FilterComponent } from './filter.component';4import { FormsModule } from '@angular/forms';5import { FilterPipe } from './filter.pipe';6@NgModule({7  imports: [8})9export class FilterModule { }10import { Component, OnInit, Input } from '@angular/core';11@Component({12})13export class FilterComponent implements OnInit {14  @Input() items: any[];15  @Input() filterBy: string;16  @Input() filterOn: string;17  filteredItems: any[];18  constructor() { }

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.