[1] Kasten,“A New Table and Approximation Formula for the Relative Optical Air Mass”,Arch.Meteorol.Geophys.Bioklimatol.Ser.B 14,206-223(1965). [2] R.A Miner,K.S.W.Chamption,and H.L.Pond,The ARDC Model Atmosphere,1959,Air Force Surveys in Geophysics 11(AFCRL,1959) [3] F.Link and L.Neuzil,Table of Light Trajectories in the Terrestrial Atmosphere(Hermann,Paris,1969) [4] D.E Snier and A. Goldman,Refractive Effects in Remote Sensing of Atmosphere with Infrared Transmission Spectroscopy,(Ballistic Research Labratories,June 1975) [5] Y. M. Treve, New Values of the Optical Air Mass and the Refraction and Comparison with Previous Tables,” in Proceed-ings, Second Tropospheric Refraction Effects Technical ReviewMeeting, Technical Documentary Rep. ESD-TDR 64-103, May1964 (National Technical Information Service Order AD-442626), pp.5-391. [6] International Organization for Standardization,Standard Atmosphere,International Standard ISO253(1972) [7] S.L.Valley,Handbook of Geophysics and Space Physics (AFCRL,1965), pp.23. [8] W.H.Jefferys,M.J.Fitzpatrick,B.E.McArthur,andJ.E. McCartney, GaussFit:A System for Least Squares and RobustEstimation (U. Texas at Austin, 1989). [9] A.T.Young,Observational Technique and Data Reduction,” inle to Methods of Experimental Physics(Vol. 12, Astrophysics; Partrmly A:Optical and Infrared),N,Carleton,Ed.(Academic, New York, 1974),p.150.
using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { csv.Configuration.PrepareHeaderForMatch = (string header,int index) => header.ToLower(); var records = csv.GetRecords<Foo>(); }
using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { csv.Configuration.HasHeadRecord = false; varrecord = csv.GetRecords<Foo>(); }
using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { csv.Configuration.RegisterClassMap<FooMap>(); var records = csv.GetRecords<Foo>(); }
using (var reader = new StremaReader("path\\to\\file.csv"),Encoding.UTF8) { } using (var writer = new StreamWriter("path\\to\\file.csv",Encoding.UTF8)) { }
using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { }
using (var writer = new StreamWriter("path\\to\\file.csv")) using (var csv = new CsvWriter(writer)) { }
读 CSV 文件
获取类记录
将 CSV 插入到对应类的对象中。
数据
1 2
Id,Name 1,one
例子
1 2 3 4 5 6 7 8 9 10 11 12 13 14
voidMain() { using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { var records = csv.GetRecords<Foo>(); } }
publicclassFoo { publicint Id { get; set; } publicstring Name { get; set; } }
voidMain() { using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { var records = csv.GetRecords<dynamic>(); } }
获取匿名类型的记录
如果你需要将 CSV 插入到匿名类型的对象中，仅仅只要提供匿名类型的定义即可。
数据
1 2
Id,Name 1,one
例子
1 2 3 4 5 6 7 8 9 10 11 12 13
voidMain() { using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { var anonymousTypeDefinition = new { Id = default(int), Name = string.Empty }; var records = csv.GetRecords(anonymousTypeDefinition); } }
voidMain() { using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { varrecord = new Foo(); var records = csv.EnumerateRecords(record); foreach (var r in records) { // r is the same instance as record. } } }
publicclassFoo { publicint Id { get; set; } publicstring Name { get; set; } }
voidMain() { using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { var records = new List<Foo>(); csv.Read(); csv.ReadHeader(); while (csv.Read()) { varrecord = new Foo { Id = csv.GetField<int>("Id"), Name = csv.GetField("Name") }; records.Add(record); } } }
publicclassFoo { publicint Id { get; set; } publicstring Name { get; set; } }
voidMain() { using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { csv.Configuration.IgnoreBlankLines = false; csv.Configuration.RegisterClassMap<FooMap>(); csv.Configuration.RegisterClassMap<BarMap>(); var fooRecords = new List<Foo>(); var barRecords = new List<Bar>(); var isHeader = true; while (csv.Read()) { if (isHeader) { csv.ReadHeader(); isHeader = false; continue; }
if (string.IsNullOrEmpty(csv.GetField(0))) { isHeader = true; continue; }
voidMain() { using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { csv.Configuration.RegisterClassMap<FooMap>(); var records = csv.GetRecords<Foo>(); } }
publicclassFoo { publicint Id { get; set; } publicstring Name { get; set; } }
voidMain() { using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { csv.Configuration.RegisterClassMap<FooMap>(); var records = csv.GetRecords<Foo>(); } }
publicclassFoo { publicint Id { get; set; } publicstring Name { getset; } }
voidMain() { using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { csv.Configuration.RegisterClassMap<FooMap>(); var records = csv.GetRecords<Foo>(); } }
publicclassFoo { publicint Id { get; set; } publicstring Name { getset; } }
voidMain() { using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { csv.Configuration.RegisterClassMap<FooMap>(); var records = csv.GetRecords<Foo>(); } }
voidMain() { using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { csv.Configuration.HasHeaderRecord = false; csv.Configuration.RegisterClassMap<FooMap>(); var records = csv.GetRecords<Foo>(); } }
publicclassFoo { publicint Id { get; set; } publicstring Name { getset; } }
voidMain() { using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { csv.Configuration.RegisterClassMap<FooMap>(); var records = csv.GetRecords<Foo>(); } }
publicclassFoo { publicint Id { get; set; } publicstring Name { get; set; } }
voidMain() { using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { csv.Configuration.RegisterClassMap<FooMap>(); var records = csv.GetRecords<Foo>(); } }
voidMain() { using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { csv.Configuration.RegisterClassMap<FooMap>(); var records = csv.GetRecords<Foo>(); } }
voidMain() { using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { csv.Configuration.RegisterClassMap<FooMap>(); csv.GetRecords<Foo>().ToList().Dump(); } }
publicclassFoo { publicint Id { get; set; } publicstring Name { get; set; } public Json Json { get; set; } }
void Main() { using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { csv.Configuration.RegisterClassMap<FooMap>(); csv.GetRecords<Foo>().ToList().Dump(); } }
public class Foo { public int Id { get; set; } public string Name { get; set; } public Json Json { get; set; } }
public class Json { public string Foo { get; set; } }
public class FooMap : ClassMap<Foo> { public FooMap() { Map(m => m.Id); Map(m => m.Name); Map(m => m.Json).ConvertUsing(row => JsonConvert.DeserializeObject<Json>(row.GetField("Json"))); } }
voidMain() { var records = new List<Foo> { new Foo { Id = 1, Name = "one" } };
using (var writer = new StreamWriter("path\\to\\file.csv")) using (var csv = new CsvWriter(writer)) { csv.Configuration.RegisterClassMap<FooMap>(); csv.WriteRecords(records);
writer.ToString().Dump(); } }
publicclassFoo { publicint Id { get; set; } publicstring Name { get; set; } public Json Json { get; set; } }
voidMain() { using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { csv.Configuration.RegisterClassMap<FooMap>(); csv.GetRecords<Foo>().ToList().Dump(); } }
publicclassFoo { publicint Id { get; set; } publicstring Name { get; set; } public DateTimeOffset? Date { get; set; } }
voidMain() { using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { csv.Configuration.RegisterClassMap<FooMap>(); csv.GetRecords<Foo>().ToList().Dump(); } }
publicclassFoo { publicint Id { get; set; } publicstring Name { get; set; } public DateTimeOffset? Date { get; set; } }
voidMain() { using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { csv.GetRecords<Foo>().ToList().Dump(); } }
publicclassFoo { [Name("Identifier")] publicint Id { get; set; }
using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { // Do any configuration to `CsvReader` before creating CsvDataReader. using (var dr = new CsvDataReader(csv)) { var dt = new DataTable(); dt.Load(dr); } }
如果你想要指定行和行的类型，数据表也可以进行自动的类型转换。
1 2 3 4 5 6 7 8 9 10 11 12 13
using (var reader = new StreamReader("path\\to\\file.csv")) using (var csv = new CsvReader(reader)) { // Do any configuration to `CsvReader` before creating CsvDataReader. using (var dr = new CsvDataReader(csv)) { var dt = new DataTable(); dt.Columns.Add("Id", typeof(int)); dt.Columns.Add("Name", typeof(string));
ω = 0.017202786day−1
.png)
.png)
.png)
答：从逻辑上来说，就绪态和运行态是类似的，唯一的不同是在于是否得到CPU资源。如果从就绪态可以转换到阻塞态，那么出现的事件也就是需要等待输入，但是，就绪态就是因为已经出现了有效的输入只不过没有得到CPU资源而产生的等待，所以不可能出现就绪态向阻塞态的转变；从阻塞态到运行态是得到了有效的输入和CPU计算资源才能完成的转化，但是得到有效的输入肯定会位于得到资源的前面，因为没有有效的输入都不能进行计算，而当出现有效输入的时候，就已经是就绪态了，即使有效输入和CPU资源获取的间隔很小，但是始终存在，所以肯定会经过就绪态。
