# Excel4Unity

**Repository Path**: ObjOne/Excel4Unity

## Basic Information

- **Project Name**: Excel4Unity
- **Description**: Excel for Unity. Provides both read and write with .xls and .xlsx
- **Primary Language**: C#
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2019-08-30
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# Excel4Unity
Excel for Unity


## Provides

* Excel(.xls/.xlsx) Read/Write
* Format Excel sheet into custom object (Excel,ExcelTable...)
* Edit .xls/.xlsx file in Unity EditorWindow

## Todo
* .xls support in platform Windows
* xls to json convertion


## How to use
``` c#
        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);
```

## 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

### Update 2016-3-16
* add new cell type "popup"

### Update 2016-3-15
* add model "ExcelTableCell" to describe the infomation of cell
* add editor to modify excel file in Unity

### Update 2016-3-10
* move the scripts and dlls into "Editor" folder to make sure the game can be running in ".Net 2.0 Subset"
* fix the row number & column number counting bug
* add example script in MyEditor/test

![](https://github.com/joexi/Excel4Unity/blob/master/doc/001.png?raw=true)