gouhuo/SFGgouhuo/Assets/Editor/AddItemToLocalLanguage.cs

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

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);


        // 打开 Excel 文件
        //FileInfo fileInfo = new FileInfo(excelPath);
        //using (ExcelPackage package = new ExcelPackage(fileInfo))
        //{
        //    // 获取工作表
        //    ExcelWorksheet worksheet = package.Workbook.Worksheets[1]; // 假设我们操作第一个工作表
        //    for (int i = 0; i < goods.Count; i++)
        //    {
        //        goods[i].assetsType = goods[i].dressType;
        //        goods[i].dressType = (goods[i].id / 10000).ToString();
        //        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();
        //}

    }
}