public CsvTable LoadCSV(string csv_path) { CsvTable csvTable = new CsvTable(); TextAsset csvTextAsset = Resources.Load(csv_path) as TextAsset; //string t1 = Application.dataPath; //string t2 = Application.temporaryCachePath; //string t3 = Application.persistentDataPath; //StreamReader sr; //sr = File.OpenText(Application.dataPath + t_csv_path); // Replace CR (= carriage return) for each OS environment. string csvText = csvTextAsset.text.Replace(Environment.NewLine, "\r"); // Object removes all leading blank and trailing blank characters csvText = csvText.Trim('\r'); string[] csv = csvText.Split('\r'); List <string> rows = new List <string>(csv); string[] headers = rows[0].Split(','); foreach (string header in headers) { csvTable.AddHeaders(header); } rows.RemoveAt(0); foreach (string row in rows) { string[] fields = row.Split(','); csvTable.AddRecord(CreateRecord(headers, fields)); } return(csvTable); }
public CsvTable LoadCSV(TextAsset csvTextAsset) { CsvTable csvTable = new CsvTable(); string csvText = csvTextAsset.text.Replace(Environment.NewLine, "\r"); // Object removes all leading blank and trailing blank characters csvText = csvText.Trim('\r'); string[] csv = csvText.Split('\r'); List <string> rows = new List <string>(csv); string[] headers = rows[0].Split(','); foreach (string header in headers) { csvTable.AddHeaders(header); } rows.RemoveAt(0); foreach (string row in rows) { string[] fields = row.Split(','); csvTable.AddRecord(CreateRecord(headers, fields)); } return(csvTable); }