How to convert txt format to json format

How to convert txt to json format: first open the corresponding code script file; then read the TXT file and convert it to Json through the [ReadTextToJson();] method.

#JSON is a lightweight data exchange format. It is based on a subset of ECMAScript and uses a text format that is completely independent of programming languages ​​to store and represent data. Simplicity and clear hierarchical structure make JSON an ideal data exchange language. It is easy for people to read and write, and it is also easy for machines to parse and generate, and effectively improves network transmission efficiency.

The following is the converted program code:

using System.Collections;
using System.Collections.Generic;
using System.IO;
using System.Text;
using LitJson;
using UnityEngine;
using Excel;
using Excel.Core;
using OfficeOpenXml.Style;
using OfficeOpenXml;


/// <summary>
/// 该class用于json的时候不能有构造函数
/// </summary>
public class DataNode//自定义类来承接一会读出来的数据分类
{
    public string CopyName;
    public string CopyPosition;
    public string CopyRotation;
}

public class DataCenter//自定义类包含List列表来添加一会读取出来的的数据信息
{
    public List<DataNode> List;

   public DataCenter()
    {
        List =new List<DataNode>();
    }
}

public class JsonConvert : MonoBehaviour {

	// Use this for initialization
    private string _txtPath;//TXT文件路径
    private string _jsonPath;//转换后写入的json路径
    private string _excelPath;
    
	void Start ()
	{
        _jsonPath = Application.streamingAssetsPath + "/CopyInfo.json";//定义路径
	    _txtPath = Application.streamingAssetsPath + "/CopyInfo.txt";
        _excelPath = Application.streamingAssetsPath + "/CopyInfo.json";
	   // Json的解析是很快的 网络
        ReadTextToJson();//读取TXT文件并转化为Json
	    ReadJsonFromJsonPath();//读取Json文件
        WriteExcel(_excelPath);

    }

	// Update is called once per frame
	void Update () {
		
	}

    void ReadJsonFromJsonPath()
    {
        //               读取全部(文件路径)
      string jsondata =  File.ReadAllText(_jsonPath);
        List<DataNode> node = JsonMapper.ToObject<List<DataNode>>(jsondata);//固定格式
        Debug.LogError(node.Count);
    }
    void ReadTextToJson()
    {
        DataCenter dc = new DataCenter();//实例化dc,待会用其List
        //读文件固定格式
        using (StreamReader reader = new StreamReader(_txtPath,Encoding.UTF8))
        {
            string tmpStr = string.Empty;
            while ( !string.IsNullOrEmpty(tmpStr = reader.ReadLine()))
            {
                string[] infos = tmpStr.Split(&#39;_&#39;);
                DataNode _node = new DataNode();//实例化调用其属性
                _node.CopyName = infos[0];//把读取的内容赋值
                _node.CopyPosition = infos[1];
                _node.CopyRotation = infos[2];
                dc.List.Add(_node);//把内容添加进列表
            }
        }
        //数据读取完毕 开始写入json 传递的List<>
        string jsonData = JsonMapper.ToJson(dc.List);
        File.WriteAllText(_jsonPath,jsonData);

    }
    private void WriteExcel(string path)
    {
        DataCenter dc = new DataCenter();//实例化dc,待会用其List
        //读文件固定格式
        using (StreamReader reader = new StreamReader(_txtPath, Encoding.UTF8))
        {
            string tmpStr = string.Empty;
            while (!string.IsNullOrEmpty(tmpStr = reader.ReadLine()))
            {
                string[] infos = tmpStr.Split(&#39;_&#39;);
                DataNode _node = new DataNode();//实例化调用其属性
                _node.CopyName = infos[0];//把读取的内容赋值
                _node.CopyPosition = infos[1];
                _node.CopyRotation = infos[2];
                dc.List.Add(_node);//把内容添加进列表
            }
        }
        Debug.LogError(dc.List.Count);
        FileInfo excelInfo = new FileInfo(path);
        if (excelInfo.Exists)
        {
            excelInfo.Delete();
            excelInfo = new FileInfo(path);

        }

        //开始使用 Excel 
        using (ExcelPackage package = new ExcelPackage(excelInfo))
        {
            ExcelWorksheet sheet = package.Workbook.Worksheets.Add("TestInfo"); // 添加了一个工作表
            sheet.Cells[1, 1].Value = "CopyName";
            sheet.Cells[1, 2].Value = "CopyPosition";
            sheet.Cells[1, 3].Value = "CopyRotation";

            for (int i = 0; i < dc.List.Count; i++)
            {
                sheet.Cells[2 + i, 1].Value = dc.List[i].CopyName;
                sheet.Cells[2 + i, 2].Value = dc.List[i].CopyPosition;
                sheet.Cells[2 + i, 3].Value = dc.List[i].CopyRotation;
            }
            sheet.Cells.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
            sheet.Cells.Style.VerticalAlignment = ExcelVerticalAlignment.Center;
            sheet.Cells.Style.Font.Bold = true;
            sheet.Cells.Style.Font.Name = "宋体";
            sheet.Cells.Style.Font.Size = 28;
            sheet.Cells.AutoFitColumns(50, 150);

            package.Save();
        }
        
    }
}

The above is the detailed content of How to convert txt format to json format. For more information, please follow other related articles on the PHP Chinese website!