CsvUtility 1.2.9

There is a newer version of this package available.
See the version list below for details.

dotnet add package CsvUtility --version 1.2.9

NuGet\Install-Package CsvUtility -Version 1.2.9

This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.

<PackageReference Include="CsvUtility" Version="1.2.9" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

paket add CsvUtility --version 1.2.9

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: CsvUtility, 1.2.9"

#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.

// Install CsvUtility as a Cake Addin
#addin nuget:?package=CsvUtility&version=1.2.9

// Install CsvUtility as a Cake Tool
#tool nuget:?package=CsvUtility&version=1.2.9

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

using CommonUtil2;
using System.IO.MemoryMappedFiles;

using CsvUtility;

namespace CsvUtilityTest
{
	/**
	Paste below and save as .csv
	
	seq,id,name,gender,birthday,remark
	0,10001,Foo,male,1970/10/1,
	1,10002,Bar,male,1980/2/1,test
	2,10003,John,male,1990/3/15,
	3,10004,Sophia,female,2000/12/5,

	Or,
	"seq","id","name","gender","birthday","remark"
	"0","10001","Foo","male","1970/10/1",""
	"1","10002","Bar","male","1980/2/1","test"
	"2","10003","John","male","1990/3/15",""
	"3","10004","Sophia","female","2000/12/5",
	
	Also can use \t insted of comma
	*/

	public partial class CsvUtilityTest : Form
	{
		public CsvUtilityTest()
		{
			Button button = new Button() { Parent = this, Dock = DockStyle.Top, Text = "OpenAndCreate", };
			button.Click += (sender, e) =>
			{
				OpenFileDialog ofd = new OpenFileDialog() { InitialDirectory = Application.StartupPath, };

				//select book1.csv or book1dq.csv
				if (ofd.ShowDialog() == DialogResult.OK)
				{
					var csv2 = CsvFileV2.Open(ofd.FileName);
					var debuginfo = new List<string>();
					debuginfo.Add(string.Format("File name: {0}", csv2.FileName));
					debuginfo.Add(string.Format("Delimiter: {0}", csv2.Delimiter));
					debuginfo.Add(string.Format("Line count: {0}", csv2.LineCount));
					debuginfo.Add(string.Format("Encoding: {0}", csv2.Encoding));
					debuginfo.Add(string.Empty);

					debuginfo.Add("-- Header list --");
					debuginfo.AddRange(csv2.UniqueHeader);

					MessageBox.Show(string.Join(Environment.NewLine, debuginfo));

					//if column number is not sure, find it by using part of column name
					//add using CsvUtility
					var nameColumnIdx = csv2.FindFirstUniqueHeaderColumnIndex("name");
					var nameColumnName = csv2.FindFirstUniqueHeaderColumnName("name");
					var bdColumnIdx = csv2.FindFirstUniqueHeaderColumnIndex("birthday");
					var bdColumnName = csv2.FindFirstUniqueHeaderColumnName("birthday");
					var remarkColumnIdx = csv2.FindFirstUniqueHeaderColumnIndex("remark");
					var remarkColumnName = csv2.FindFirstUniqueHeaderColumnName("remark");

					foreach (var l in csv2.AllLines)
					{
						List<string> text = new List<string>();
						text.Add(string.Format("{0}={1}", nameColumnIdx, l.GetValue(nameColumnIdx)));
						text.Add(string.Format("{0}={1}", nameColumnName, l.GetValue(nameColumnName)));
						text.Add(string.Format("{0}={1}", bdColumnIdx, l.GetValueAsDate(bdColumnIdx)));
						text.Add(string.Format("{0}={1}", bdColumnName, l.GetValueAsDate(bdColumnName)));
						text.Add(string.Format("{0}={1}", remarkColumnIdx, l.GetValue(remarkColumnIdx)));
						text.Add(string.Format("{0}={1}", remarkColumnName, l.GetValue(remarkColumnName)));

						/** if you are sure a correct name, can get a value using the key directly. */
						if (l.ContainsKey("2: name"))
						{
							Console.WriteLine(l["2: name"]);
						}

						var ret = MessageBox.Show(string.Join(Environment.NewLine, text), "line", MessageBoxButtons.OKCancel);
						if (ret == DialogResult.Cancel) break;
					}

					foreach (var l in csv2.AllLinesWithLineNumber)
					{
						List<string> text = new List<string>();
						text.Add(string.Format("{0}={1}", nameColumnIdx, l.Value.GetValue(nameColumnIdx)));
						text.Add(string.Format("{0}={1}", nameColumnName, l.Value.GetValue(nameColumnName)));
						text.Add(string.Format("{0}={1}", bdColumnIdx, l.Value.GetValueAsDate(bdColumnIdx)));
						text.Add(string.Format("{0}={1}", bdColumnName, l.Value.GetValueAsDate(bdColumnName)));
						text.Add(string.Format("{0}={1}", remarkColumnIdx, l.Value.GetValue(remarkColumnIdx)));
						text.Add(string.Format("{0}={1}", remarkColumnName, l.Value.GetValue(remarkColumnName)));


						var ret = MessageBox.Show(string.Join(Environment.NewLine, text), string.Format("Current line number: {0}", l.Key), MessageBoxButtons.OKCancel);
						if (ret == DialogResult.Cancel) break;
					}

					foreach (var l in csv2.AllLinesAsArray)
					{
						List<string> text = new List<string>();
						/** Need to confirm array size */
						try
						{
							text.Add(string.Format("{0}={1}", nameColumnIdx, l[nameColumnIdx]));
							text.Add(string.Format("{0}={1}", bdColumnIdx, l[bdColumnIdx]));
							text.Add(string.Format("{0}={1}", remarkColumnIdx, l[remarkColumnIdx]));
						}
						catch (Exception exception)
						{
							text.Add(string.Format("Column not found: {0}", exception.Message));
						}
						var ret = MessageBox.Show(string.Join(Environment.NewLine, text), "line", MessageBoxButtons.OKCancel);
						if (ret == DialogResult.Cancel) break;

					}



					if (MessageBox.Show("Write data to file?", "Message", MessageBoxButtons.YesNo) == DialogResult.Yes)
					{
						//create a csv file
						var csvCreatefilename = string.Format(".\\{0:yyyyMMdd_HHmmss}.csv", DateTime.Now);
						var csvCreate = CsvFileV2.Create(csvCreatefilename, new[] { "name", "modify date" });

						/** Require unique column name */
						var csvCreateNameColumnName = csvCreate.FindFirstUniqueHeaderColumnName("name");
						var csvCreateModifyDateColumnName = csvCreate.FindFirstUniqueHeaderColumnName("modify date");

						var ln = 0;
						foreach (var l in csv2.AllLines)
						{
							/** There are two ways for adding line. */
							if (++ln % 2 == 1)
							{
								/** Get a line template of the csv file. */
								var tempdic = csvCreate.CreateLineTemplate();

								/** Insert value to a column which update required. */
								tempdic[csvCreateNameColumnName] = l.GetValue(nameColumnIdx);
								tempdic[csvCreateModifyDateColumnName] = DateTime.Now;

								/** Add line. */
								csvCreate.AddLine(tempdic);
							}
							else
							{
								/** Add line by specifying all values. */
								csvCreate.AddLine(l.GetValue(nameColumnIdx), DateTime.Now);
							}
							l["name"] = "AA";
						}

						csvCreate.Save();
						MessageBox.Show(string.Format("wrote to {0}.", csvCreatefilename));

						/** Change delimiter. Also can specify when create. */
						csvCreate.Delimiter = eDelimiter.Tab;
						csvCreatefilename = string.Format(".\\{0:yyyyMMdd_HHmmss}.csv", DateTime.Now);
						/** Change file name.*/
						csvCreate.Save(csvCreatefilename);
						MessageBox.Show(string.Format("wrote to {0} as tab split file.", csvCreatefilename));
					}

				}

			};

			Button buttonParse = new Button() { Parent = this, Dock = DockStyle.Top, Text = "Parse", };
			buttonParse.Click += (sender, e) =>
			{
				OpenFileDialog ofd = new OpenFileDialog() { InitialDirectory = Application.StartupPath, };

				//select book1.csv or book1dq.csv
				if (ofd.ShowDialog() == DialogResult.OK)
				{
					//thought as utf8
					using (System.IO.StreamReader sr = new System.IO.StreamReader(ofd.FileName))
					{
						var csv2 = CsvFileV2.Parse(sr.ReadToEnd());
						var debuginfo = new List<string>();
						debuginfo.Add(string.Format("File name: {0}", csv2.FileName));
						debuginfo.Add(string.Format("Delimiter: {0}", csv2.Delimiter));
						debuginfo.Add(string.Format("Line count: {0}", csv2.LineCount));
						debuginfo.Add(string.Format("Encoding: {0}", csv2.Encoding));
						debuginfo.Add(string.Empty);

						debuginfo.Add("-- Header list --");
						debuginfo.AddRange(csv2.UniqueHeader);

						MessageBox.Show(string.Join(Environment.NewLine, debuginfo));

						//if column number is not sure, find it by using part of column name
						//add using CsvUtility
						var nameColumnIdx = csv2.FindFirstUniqueHeaderColumnIndex("name");
						var nameColumnName = csv2.FindFirstUniqueHeaderColumnName("name");
						var bdColumnIdx = csv2.FindFirstUniqueHeaderColumnIndex("birthday");
						var bdColumnName = csv2.FindFirstUniqueHeaderColumnName("birthday");
						var remarkColumnIdx = csv2.FindFirstUniqueHeaderColumnIndex("remark");
						var remarkColumnName = csv2.FindFirstUniqueHeaderColumnName("remark");

						foreach (var l in csv2.AllLines)
						{
							List<string> text = new List<string>();
							text.Add(string.Format("{0}={1}", nameColumnIdx, l.GetValue(nameColumnIdx)));
							text.Add(string.Format("{0}={1}", nameColumnName, l.GetValue(nameColumnName)));
							text.Add(string.Format("{0}={1}", bdColumnIdx, l.GetValueAsDate(bdColumnIdx)));
							text.Add(string.Format("{0}={1}", bdColumnName, l.GetValueAsDate(bdColumnName)));
							text.Add(string.Format("{0}={1}", remarkColumnIdx, l.GetValue(remarkColumnIdx)));
							text.Add(string.Format("{0}={1}", remarkColumnName, l.GetValue(remarkColumnName)));

							/** if you are sure a correct name, can get a value using the key directly. */
							if (l.ContainsKey("2: name"))
							{
								Console.WriteLine(l["2: name"]);
							}

							var ret = MessageBox.Show(string.Join(Environment.NewLine, text), "line", MessageBoxButtons.OKCancel);
							if (ret == DialogResult.Cancel) break;
						}

						foreach (var l in csv2.AllLinesWithLineNumber)
						{
							List<string> text = new List<string>();
							text.Add(string.Format("{0}={1}", nameColumnIdx, l.Value.GetValue(nameColumnIdx)));
							text.Add(string.Format("{0}={1}", nameColumnName, l.Value.GetValue(nameColumnName)));
							text.Add(string.Format("{0}={1}", bdColumnIdx, l.Value.GetValueAsDate(bdColumnIdx)));
							text.Add(string.Format("{0}={1}", bdColumnName, l.Value.GetValueAsDate(bdColumnName)));
							text.Add(string.Format("{0}={1}", remarkColumnIdx, l.Value.GetValue(remarkColumnIdx)));
							text.Add(string.Format("{0}={1}", remarkColumnName, l.Value.GetValue(remarkColumnName)));

							var ret = MessageBox.Show(string.Join(Environment.NewLine, text), string.Format("Current line number: {0}", l.Key), MessageBoxButtons.OKCancel);
							if (ret == DialogResult.Cancel) break;
						}

						foreach (var l in csv2.AllLinesAsArray)
						{
							List<string> text = new List<string>();
							/** Need to confirm array size */
							try
							{
								text.Add(string.Format("{0}={1}", nameColumnIdx, l[nameColumnIdx]));
								text.Add(string.Format("{0}={1}", bdColumnIdx, l[bdColumnIdx]));
								text.Add(string.Format("{0}={1}", remarkColumnIdx, l[remarkColumnIdx]));
							}
							catch (Exception exception)
							{
								text.Add(string.Format("Column not found: {0}", exception.Message));
							}
							var ret = MessageBox.Show(string.Join(Environment.NewLine, text), "line", MessageBoxButtons.OKCancel);
							if (ret == DialogResult.Cancel) break;

						}
					}
				}
			};

			StartPosition = FormStartPosition.CenterScreen;
		}
	}
}

Product	Compatible and additional computed target framework versions.
.NET Framework	net461 is compatible. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed.

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

.NETFramework 4.6.1
- No dependencies.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version	Downloads	Last updated
1.4.4	40	4/27/2024
1.4.3	117	1/23/2024
1.4.2	185	11/27/2023
1.4.1	109	11/26/2023
1.4.0	104	11/25/2023
1.3.0	149	7/16/2023
1.2.9	129	6/30/2023
1.2.8.1	310	11/15/2022
1.2.8	296	11/14/2022
1.2.7	346	10/8/2022
1.2.5	400	7/16/2022
1.2.4	413	7/10/2022
1.2.2	401	6/30/2022
1.2.1	393	6/18/2022
1.2.0	404	5/9/2022
1.1.8	403	4/16/2022
1.1.7	409	3/17/2022
1.1.6	415	2/16/2022
1.1.5	399	2/6/2022
1.1.4	399	1/21/2022
1.1.3	411	1/19/2022
1.1.2	406	1/18/2022
1.1.1	243	12/29/2021
1.1.0	272	11/23/2021
1.0.9	314	10/27/2021
1.0.8	292	10/18/2021
1.0.7	293	10/13/2021

Total 8.8K

Current version 129

Per day average 9

Csv

CsvUtility 1.2.9

.NETFramework 4.6.1

NuGet packages

GitHub repositories