1. Excel Write
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjT4B6DFOMu4JtvdkCik2OMe0kriOEdQ5D_iW3E2lviyqbLI6vTU8V51w_8x8YOl-0AAYVTPyBikk4o9rI40xhqouE_bYRsAnECtu6OHPkRhfMX1V16pldCX1O8KXWMZ6T1ERlMK0jVUFg/s400/01.png)
2. Save another
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjmD039uZv-cnDxVnsS_8WuThYUbDQ8kJvgiX1oKMdntfHjHRHdMPWX4DdHeBpbKuHpchIZDWmGMtWfZYHtC85wwh7HabZbEoY7hFFdPFqzOzqLUX_83K3waJ0fJCSOF1v1wtNK4CtuyjQ/s400/02.png)
3. Save&Setting File form And File name
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhuGpQOhSaVeVvDxE1DjJaSwVrjAY0J1TlRbnq3CXXeP55PsEuU_q6UpQUAzVNrJSQqKpwXlB7YTvZAnISQOeF7ua45XfrF2XMlnfrT0YwycTCN43zvvzdFlg3MOqBek29405S37Dk9T8k/s640/03.png)
4. Open to txt
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpu_rhLSiq3IsvDrw69NCk5ldfnxBMNDwq_RmQhcGnrN5qjmcamOyrYtOLRLA1jMnB19LnrhHHHQSpfqBhyLkvkhqVj5YEfmT-3soiqSP-JfniDLht21VZTfUH2WxPZ6_HdG1lzTNir4w/s400/04.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXS1eBXy2QZeRpi58eKgwGhOOI06pUK-aNSFe9HCg6PSe88lWwFAl2aPWUD2RTvw5tv5DnHjt9UWPHUfbJw6uEWKOeronaTCfO4jv6yRdPA4cZMg0KTyd75KrkuZUqDGwuIOjsUiTDHVo/s400/05.png)
5. Save another
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9-K6hj3pZl5OmH6zQfiUCpJZpSfMXo-ST_UcAKAb4rjDXQe5d3F1FbpiSeeXcVJDKR1vxun4XsViIxirzjQnAXy5P1ug0Q4PDB9wTE4yKku0dYb7SBSL05e8-4WkNg0Hjj1BDE9n7PK0/s320/06.png)
6. Set Str EnCoding - UTF-8
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQ9kLY1Y675zkeXdSdiDDLz1lvWjbB1ZGS0na_Cv7-TSl4svVVLPZ06SVNKg04D1bMiqcrZdMnLIHFcaU-XGJKxy_Os0zuexGxMsxXMVcXXEHLfY9KVRXpE5vZVG07gTZoGsOPGLYtxug/s640/07.png)
7. Inport to unity
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwkiviWdvHp9HHXdycJPo5pL5tU_p21ZqUddNBg6ADj224c8-knNBHsH4YRObtr68lKTfwKuh2OoJO6wJ7h4EtiFCJ9XhGsqgLjzwpQdB98TqBuKTSr2rBy9uOg-pUje-R1NsaPSukEbk/s640/08.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOntSRkiEJ__xWGYinWyQHEtnSeJFxOfu8MlKLzqLHaxZnj-LZjjyZm5CDxXk9NfkLjZlxHkynCho7slTJ1o6JO5AXewTXXvPCSaUx3n85FSNiukdFq0G9Yc3dIzu9qzdVM3mcCFZCThM/s640/10.png)
8. Setting Unity And Show
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyPdpVWwcUeknacg3DrzpZpex2icZSf6h6CmJtzdLVZT9fQZDi8OYjhU6x7QEuE9kWHMQbW_IQM-4J-tyRdjze3Sc74wTvMdeuwKcpM-fxiP8K7nmU5ubuKwo-2cHIfjbqmgq4KabhkG0/s640/11.png)
class TestCSV
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
using System.Collections;
using System.Collections.Generic;
using UnityEngine;
public class TestCSV : MonoBehaviour
{
public string m_strCSVFileName = string.Empty;
class TempData
{
public int index;
public string testString;
public int testInt;
public float testFloat;
}
List<TempData> m_tempData = new List<TempData>();
// Start is called before the first frame update
void Start()
{
List<Dictionary<string, object>> m_dictionaryData = CSVReader.Read(m_strCSVFileName);
for (int i = 0; i < m_dictionaryData.Count; i++)
{
m_tempData.Add(new TempData());
m_tempData[i].index = int.Parse((m_dictionaryData[i]["Index"].ToString()));
m_tempData[i].testString = m_dictionaryData[i]["TestString"].ToString();
m_tempData[i].testInt = int.Parse(m_dictionaryData[i]["TestInt"].ToString());
m_tempData[i].testFloat = float.Parse(m_dictionaryData[i]["TestFloat"].ToString());
}
for(int i =0; i< m_tempData.Count; i++)
{
Debug.Log("Index : "+m_tempData[i].index + ", TestString : " + m_tempData[i].testString + ", TestInt : " + m_tempData[i].testInt + ", TestFloat : " + m_tempData[i].testFloat);
}
}
}
| cs |
class CSVReader
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
|
using UnityEngine;
using System.Collections.Generic;
using System.Text.RegularExpressions;
public class CSVReader
{
public static string SPLIT_RE = @",(?=(?:[^""]*""[^""]*"")*(?![^""]*""))";
public static string LINE_SPLIT_RE = @"\r\n|\n\r|\n|\r";
public static char[] TRIM_CHARS = { '\"' };
public static List<Dictionary<string, object>> Read(string file)
{
var list = new List<Dictionary<string, object>>();
TextAsset data = Resources.Load(file) as TextAsset;
var lines = Regex.Split(data.text, LINE_SPLIT_RE);
if (lines.Length <= 1) return list;
var header = Regex.Split(lines[0], SPLIT_RE);
for (var i = 1; i < lines.Length; i++)
{
var values = Regex.Split(lines[i], SPLIT_RE);
if (values.Length == 0 || values[0] == "") continue;
var entry = new Dictionary<string, object>();
for (var j = 0; j < header.Length && j < values.Length; j++)
{
string value = values[j];
value = value.TrimStart(TRIM_CHARS).TrimEnd(TRIM_CHARS).Replace("\\", "");
object finalvalue = value;
int n;
float f;
if (int.TryParse(value, out n))
{
finalvalue = n;
}
else if (float.TryParse(value, out f))
{
finalvalue = f;
}
entry[header[j]] = finalvalue;
}
list.Add(entry);
}
return list;
}
}
| cs |
혹시 코드가 맥 버전인가요?
답글삭제