Support CSV

[shps951023]

Why ExcelDataReader read csv need another method

[shps951023]

ExcelDataReader read csv all string type defualt

[shps951023]

Creating and Editing Services Available for Users in Bulk

[shps951023]

CsvHelper

void Main()
{
	var records = new List<Foo>
	{
		new Foo { Id = 1, Name = "one" },
		new Foo { Id = 2, Name = "two" },
	};
	var path =  Path.Combine(Path.GetTempPath(),$"{Guid.NewGuid().ToString()}.csv");
	using (var writer = new StreamWriter(path))
	using (var csv = new CsvWriter(writer, CultureInfo.InvariantCulture))
	{
		csv.WriteRecords(records);
	}
	Console.WriteLine(path);
}

// You can define other methods, fields, classes and namespaces here
public class Foo
{
	public int Id { get; set; }
	public string Name { get; set; }
}

Id,Name
1,one
2,two

[shps951023]

LibreOffice Calc

[shps951023]

input : 0 & "\"; ,"
ouput : 0,"""; ,"

[shps951023]

csvhelper " convert to """"

[shps951023]

System.IO.IOException : The process cannot access the file 'C:\Users\Wei\AppData\Local\Temp\c080ec8e-c38e-4971-be50-8663f312dbf6.csv' because it is being used by another process.

[shps951023]

[shps951023]

Lazy loading will meet if using stream it'll dipose before lazy loading, so system will show

System.ArgumentException
  HResult=0x80070057
  Message=Stream was not readable.
  Source=System.Private.CoreLib
  StackTrace:
   at System.IO.StreamReader..ctor(Stream stream, Encoding encoding, Boolean detectEncodingFromByteOrderMarks, Int32 bufferSize, Boolean leaveOpen)
   at System.IO.StreamReader..ctor(Stream stream)
   at MiniExcelLibs.Csv.CsvConfiguration.<>c.<.cctor>b__11_0(Stream stream) in D:\git\MiniExcel\src\MiniExcel\Csv\CsvConfiguration.cs:line 13
   at MiniExcelLibs.Csv.CsvReader.<Query>d__0.MoveNext() in D:\git\MiniExcel\src\MiniExcel\Csv\CsvReader.cs:line 17
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at MiniExcelLibs.Tests.MiniExcelCsvTests.Create2x2_Test() in D:\git\MiniExcel\tests\MiniExcelTests\MiniExcelCsvTests.cs:line 30