Awesome
Excel4Unity
Excel for Unity
Provides
- Excel(.xlsx) Read/Write
- Format Excel sheet into custom object (Excel,ExcelTable...)
- Edit .xlsx file in Unity EditorWindow
- Generate .cs model according to .xls
- Conver .xlsx file to JSON format
How to use
read & write
string excelPath = Application.dataPath + "/Test/Test.xlsx";
string outputPath = Application.dataPath + "/Test/Test2.xlsx";
Excel xls = ExcelHelper.LoadExcel(excelPath);
xls.ShowLog();
xls.Tables[0].SetValue(1, 1, "???");
ExcelHelper.SaveExcel(xls, outputPath);
generate .cs file
string path = Application.dataPath + "/Test/Test4.xlsx";
Excel xls = ExcelHelper.LoadExcel(path);
ExcelDeserializer ed = new ExcelDeserializer();
ed.FieldNameLine = 1;
ed.FieldTypeLine = 2;
ed.FieldValueLine = 3;
ed.IgnoreSymbol = "#";
ed.ModelPath = Application.dataPath + "/Editor/Excel4Unity/DataItem.txt";
ed.GenerateCS(xls.Tables[0]);
convert to json
Object[] objs = Selection.objects;
for (int i = 0; i < objs.Length; i++)
{
string path = AssetDatabase.GetAssetPath(objs[i]);
if (path.EndsWith(".xlsx"))
{
Excel4Unity.ParseFile(path);
}
else
{
EditorUtility.DisplayDialog("提示", "暂不支持的文件格式" + path, "ok");
return;
}
}
AssetDatabase.Refresh();
Dependency
- EEPlus
- .Net 2.0 instead of .Net 2.0 Subset if you want to do excel job runtime
Version
Unity 4.x or higher