Skip to content

Excel for Unity. Provides both read and write with .xls and .xlsx

Notifications You must be signed in to change notification settings

kenshin11/Excel4Unity

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

42 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

About

Excel for Unity. Provides both read and write with .xls and .xlsx

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • C# 100.0%