gouhuo/SFGgouhuo/Assets/Editor/AddItemToLocalLanguage.cs

using LitJson;
using System.Collections.Generic;
using System.IO;
using UnityEditor;
using UnityEngine;
using Excel;
using System.Data;

public class AddItemToLocalLanguage
{
    static string excelPath =Application.dataPath+ @"/Config/Lan/localLanguage.xlsx";

    [MenuItem("Tools/添加物品多语言表")]
    static void AddItemDesToLocalLanguage()
    {
        List<Good> goods = JsonMapper.ToObject<List<Good>>(Resources.Load<TextAsset>("goodsData").text);
        for (int i = 0; i < goods.Count; i++)
        {
            goods[i].assetsType = goods[i].dressType;
            goods[i].dressType = (goods[i].id / 10000).ToString();
        }

        // 打开 Excel 文件
        FileInfo fileInfo = new FileInfo(excelPath);
        //using (ExcelPackage package = new ExcelPackage(fileInfo))
        //{
        //    // 获取工作表
        //    ExcelWorksheet worksheet = package.Workbook.Worksheets[0]; // 假设我们操作第一个工作表
        //    Debug.Log(worksheet.Cells.Columns);
        //    // 添加新行
        //    //worksheet.Cells[worksheet.Dimension.Rows + 1, 1].Value = goods[0].name;
        //    // 保存修改
        //    //package.Save();
        //}
        using (FileStream stream = File.Open(excelPath, FileMode.Open, FileAccess.ReadWrite, FileShare.ReadWrite))
        {
            IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
            var result = excelReader.AsDataSet();
            
            DataRow dataRow = result.Tables[0].NewRow();
            dataRow[0] = goods[0].name;
            result.Tables[0].Rows.Add(dataRow);
            
            result.AcceptChanges();
            
            AssetDatabase.SaveAssets();
            AssetDatabase.Refresh();
        }

    }
}