CsvUtility 1.4.6

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 CsvUtility;

namespace CsvUtilityTest
{
	/**
	Paste below and save as .csv or prepare some appropriate csv files
	
	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()
		{
			string lastdir = Application.StartupPath;
			TabControl tabControl = new TabControl() { Parent = this, Dock = DockStyle.Top, };
			tabControl.ContextMenuStrip = new ContextMenuStrip();
			ToolStripMenuItem toolStripMenuItemCloseTab = new ToolStripMenuItem() { Text="Close tab",};
			toolStripMenuItemCloseTab.Click += (sender, e) => 
			{
				var st = tabControl.SelectedTab;
				if(st !=default(TabPage))
				{
					tabControl.TabPages.Remove(st);
				}
			};
			tabControl.ContextMenuStrip.Items.Add(toolStripMenuItemCloseTab);

			MenuStrip menuStrip = new MenuStrip() { Parent = this, };
			ToolStripMenuItem toolStripMenuItemFile = new ToolStripMenuItem() { Text = "File", };

			Action<string, bool> Open = (filename, forcecsv) =>
			 {
				 lastdir = System.IO.Path.GetDirectoryName(filename);

				 TabPage page = new TabPage() { Text = System.IO.Path.GetFileName(filename), };

				 CsvFileV2 csv = forcecsv ? CsvFileV2.OpenAsCsv(filename) : CsvFileV2.Open(filename);
				 ToolStripMenuItem toolStripMenuItemSaveAs = new ToolStripMenuItem()
				 {
					 Text = "Save as csv",
					 BackColor = Color.LightYellow,
					 Alignment = ToolStripItemAlignment.Right,
				 };

				 toolStripMenuItemSaveAs.Click += (sender2, e2) =>
				 {
					 SaveFileDialog sfd = new SaveFileDialog()
					 {
						 InitialDirectory = Application.StartupPath,
						 FileName = string.Format("{0:yyyyMMdd_HHmmss}", DateTime.Now),
						 DefaultExt = ".csv",
					 };

					 if (sfd.ShowDialog() == DialogResult.OK)
					 {
						 using (System.IO.StreamWriter sw = new System.IO.StreamWriter(sfd.FileName))
						 {
							 foreach (var l in csv.AllLinesAsArray)
							 {
								 sw.WriteLine(CsvHelper.ToCsvFormat(l));
							 }
							 sw.Close();
						 }
					 }
				 };
				 csv.ToolStrip.Items.Add(toolStripMenuItemSaveAs);

				 ToolStripMenuItem toolStripMenuItemShowInfo = new ToolStripMenuItem()
				 {
					 Text = "Info",
					 BackColor = Color.LightYellow,
					 Alignment = ToolStripItemAlignment.Right,
				 };
				 toolStripMenuItemShowInfo.Click += (sender, e) =>
				 {
					 Form f = new Form() { Text = "Info", StartPosition = FormStartPosition.CenterScreen, };
					 ListBox listBox = new ListBox() { Parent = f, Dock = DockStyle.Fill, };
					 listBox.Items.Clear();
					 listBox.Items.Add(string.Format("Delimiter={0}", csv.Delimiter));
					 listBox.Items.Add(string.Format("Encoding={0}", csv.Encoding));
					 listBox.Items.Add(string.Format("Line count={0}", csv.LineCount));
					 listBox.Items.Add("[header]");

					 for (int i = 0; i < csv.OriginalHeader.Length; i++)
					 {
						 listBox.Items.Add(string.Format(" originall={0}, unique={1}", csv.OriginalHeader[i], csv.UniqueHeader[i]));
					 }
					 f.ShowDialog();

				 };
				 csv.ToolStrip.Items.Add(toolStripMenuItemShowInfo);


				 ToolStripMenuItem toolStripMenuItemGlimpse = new ToolStripMenuItem()
				 {
					 Text = "Glimpse",
					 BackColor = Color.LightYellow,
					 Alignment = ToolStripItemAlignment.Right,
				 };

				 toolStripMenuItemGlimpse.Click += (sender, e) => 
				 {
					 foreach (var l in csv.AllLinesAsArray)
					 {
						 List<string> list = new List<string>() { "Show next line?" };
						 for (int i = 0; i < l.Length; i++)
						 {
							 list.Add(string.Format("{0}={1}", csv.OriginalHeader[i], l[i]));
						 }
						 var ret = MessageBox.Show(string.Join(Environment.NewLine, list), "Line", MessageBoxButtons.YesNo);
						 if (ret == DialogResult.No) break;
					 }
				 };

				 csv.ToolStrip.Items.Add(toolStripMenuItemGlimpse);

				 page.Controls.Add(csv.Panel);

#if true
				 csv.Panel.Dock = DockStyle.Fill;
#else
					page.SizeChanged += (snder2, e2) => 
					{
						csv.Panel.Height = page.ClientSize.Height;
					};
#endif
				 tabControl.TabPages.Add(page);
				 tabControl.SelectTab(page);
			 };

			ToolStripMenuItem toolStripMenuItemOpen = new ToolStripMenuItem() { Text = "Open(Auto)", };
			toolStripMenuItemOpen.Click += (sender, e) =>
			{
				OpenFileDialog ofd = new OpenFileDialog() { InitialDirectory = lastdir, };
				if (ofd.ShowDialog() == DialogResult.OK) { Open(ofd.FileName, false); }
			};
			toolStripMenuItemFile.DropDownItems.Add(toolStripMenuItemOpen);
			ToolStripMenuItem toolStripMenuItemOpenAsCsv = new ToolStripMenuItem() { Text = "Open(Force as csv)", };
			toolStripMenuItemOpenAsCsv.Click += (sender, e) =>
			{
				OpenFileDialog ofd = new OpenFileDialog() { InitialDirectory = lastdir, };
				if (ofd.ShowDialog() == DialogResult.OK) { Open(ofd.FileName, true); }
			};
			toolStripMenuItemFile.DropDownItems.Add(toolStripMenuItemOpenAsCsv);
			toolStripMenuItemFile.DropDownItems.Add(new ToolStripSeparator());


			ToolStripMenuItem toolStripMenuItemParse = new ToolStripMenuItem() { Text = "Parse from clipboard", };
			toolStripMenuItemParse.Click += (sender, e) =>
			{
				var text = Clipboard.GetText();

				if (!string.IsNullOrEmpty(text))
				{
					try
					{
						var csv = CsvFileV2.Parse(text);
						TabPage page = new TabPage() { Text = string.Format("{0:yyyyMMdd_HHmmss}", DateTime.Now), };
						page.Controls.Add(csv.Panel);
						csv.Panel.Dock = DockStyle.Fill;

						tabControl.TabPages.Add(page);
						tabControl.SelectTab(page);
					}
					catch(Exception exception)
					{
						MessageBox.Show(exception.Message);
					}
				}

			};
			toolStripMenuItemFile.DropDownItems.Add(toolStripMenuItemParse);


			ToolStripMenuItem toolStripMenuItemParseFromFile = new ToolStripMenuItem() { Text = "Parse from a file", };
			toolStripMenuItemParseFromFile.Click += (sender, e) =>
			{
				OpenFileDialog ofd = new OpenFileDialog();
				if (ofd.ShowDialog() == DialogResult.OK)
				{
					using (System.IO.FileStream fs = new System.IO.FileStream(ofd.FileName, System.IO.FileMode.Open, System.IO.FileAccess.Read))
					{
						try
						{
							var bytedata = new byte[fs.Length];
							fs.Read(bytedata, 0, (int)fs.Length);
							var text = Encoding.UTF8.GetString(bytedata);
							var csv = CsvFileV2.Parse(text);
							TabPage page = new TabPage() { Text = string.Format("{0:yyyyMMdd_HHmmss}", DateTime.Now), };
							page.Controls.Add(csv.Panel);
							csv.Panel.Dock = DockStyle.Fill;

							tabControl.TabPages.Add(page);
							tabControl.SelectTab(page);
						}
						catch (Exception exception)
						{
							MessageBox.Show(exception.Message);
						}

					}
				}
			};
			toolStripMenuItemFile.DropDownItems.Add(toolStripMenuItemParseFromFile);

			ToolStripMenuItem toolStripMenuItemParseBinary = new ToolStripMenuItem() { Text = "Parse from binary", };
			toolStripMenuItemParseBinary.Click += (sender, e) =>
			{
				OpenFileDialog ofd = new OpenFileDialog();
				if (ofd.ShowDialog() == DialogResult.OK)
				{
					using (System.IO.FileStream fs = new System.IO.FileStream(ofd.FileName, System.IO.FileMode.Open, System.IO.FileAccess.Read))
					{
						try
						{
							var bytedata = new byte[fs.Length];
							fs.Read(bytedata, 0, (int)fs.Length);

							var csv = CsvFileV2.Open(bytedata,ofd.FileName);
							TabPage page = new TabPage() { Text = string.Format("{0:yyyyMMdd_HHmmss}", DateTime.Now), };
							page.Controls.Add(csv.Panel);
							csv.Panel.Dock = DockStyle.Fill;

							tabControl.TabPages.Add(page);
							tabControl.SelectTab(page);
						}
						catch (Exception exception)
						{
							MessageBox.Show(exception.Message);
						}

					}
				}
			};
			toolStripMenuItemFile.DropDownItems.Add(toolStripMenuItemParseBinary);

			menuStrip.Items.Add(toolStripMenuItemFile);


			SizeChanged += (sender, e) =>
			{
				tabControl.Height = ClientSize.Height - menuStrip.Height;
			};

			StartPosition = FormStartPosition.CenterScreen;
			ClientSize = new Size(800, 600);

			Text = "CsvUtilityTester";
		}
	}
}