Read excel file into C# object.
- Unity 4/5 compatible
- Single DLL
- Support Office Open XML format (
.xlsx) - MIT License
- Table is marked with a name in brackets [Table Name].
- Read table into
List<T>
Table
Code
public class EnemyData
{
public string id;
public EnemyType type;
public StageType matchStageType;
public int hp;
public float atkSpeed;
public int gainPoint;
public float atkSpeed_Modify;
public string color;
}
public void LoadFromExcel(string filePath)
{
var excelReader = new ExcelToObject.ExcelReader(filePath);
List<EnemyData> enemy = excelReader.ReadList<EnemyData>("EnemyData");
}
- A property can be a array or
List<T> - It consists with same column name.
- Column name can be distinguished by '#' notation. (postfix after '#' is ignored)
Table
Code
public class RatioData
{
public int maxCount;
public float[] ratio;
}
List<RatioData> ratio = excelReader.ReadList<RatioData>("RatioData");
- A property can be a
Dictionary<TKey,TValue> - It consists with same column name.
- Key value is specified in '#' postfix
- Key can be any type which is convertible to.
Table
Code
public class StagePhaseData
{
public StageType type;
public float interval;
public int maxCount;
public float ratio_Npc;
public Dictionary<EnemyType, float> ratio;
}
var stagePhase = excelReader.ReadList<StagePhaseData>("StageData");
- Result can be
Dictionary<TKey, TValue> - Specify key column name for dictionary.
Table
Code
public class ModData
{
public float spawnInterval_Modify;
}
Dictionary<StageType, ModData> modData;
modData = excelReader.ReadDictionary<StageType, ModData>("StageModifyData", "type");
- By default, every sheet in excel wil be searched for a table.
- Several APIs are provided for more refined control.
MIT License
Refer to License file
EOF