Excel for Unity
- 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
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);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]);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();- EEPlus
- .Net 2.0 instead of .Net 2.0 Subset if you want to do excel job runtime
Unity 4.x or higher