Code Monkey home page Code Monkey logo

excel2unity's Introduction

Excel2Unity

一个为Unity3D编写的插件,可以快速地将Excel文件转换为JSON、CSV和XML,方便在游戏过程中处理各种Excel文件。本项目参考了excel2json,在此表示感谢。

如何使用Excel2Unity

将本项目中的Source文件夹直接复制到Unity3D项目中即可,Unity3D的菜单栏将会增加一个Plugins的菜单项,通过此菜单项的ExcelTools打开插件窗口。在项目资源中选中Excel文件后,点击插件窗口上的"转换"按钮即可!

使用Excel2Unity的默认约束条件

  • Excel数据表默认以第一行作为字段
  • Excel工作表默认以第一个工作表为主
  • 目前支持utf-8和gb2312两种字符编码类型

怎么解决Excel2Unity中的Bug?

  • 提交issues,然后由我来修改
  • 因为编辑器插件的代码已经给出,所以如果你在使过程中遇到任何不爽的地方,可以直接修改源代码。

Excel文件转换示例

假设Excel文件定义如下: Excel 则经过转换后的JSON、CSV和Xml文件分别如下:

[
  {
    "姓名": "李逍遥",
    "等级": 12.0,
    "描述": "《仙剑奇侠传1》男主角",
    "技能": "万剑诀",
    "登场时间": "仙剑1、仙剑2、仙剑5、仙剑5前传"
  },
  {
    "姓名": "慕容紫英",
    "等级": 20.0,
    "描述": "《仙剑奇侠传4》男主角",
    "技能": "千方残光剑",
    "登场时间": "仙剑4"
  },
  {
    "姓名": "夏侯瑾轩",
    "等级": 18.0,
    "描述": "《仙剑奇侠传5前传》男主角",
    "技能": "文星耀太虚",
    "登场时间": "仙剑5前传"
  },
  {
    "姓名": "皇甫卓",
    "等级": 24.0,
    "描述": "《仙剑奇侠传5前传》配角",
    "技能": "天中剑",
    "登场时间": "仙剑5前传"
  }
]
姓名,等级,描述,技能,登场时间,
李逍遥,12,《仙剑奇侠传1》男主角,万剑诀,仙剑1、仙剑2、仙剑5、仙剑5前传,
慕容紫英,20,《仙剑奇侠传4》男主角,千方残光剑,仙剑4,
夏侯瑾轩,18,《仙剑奇侠传5前传》男主角,文星耀太虚,仙剑5前传,
皇甫卓,24,《仙剑奇侠传5前传》配角,天中剑,仙剑5前传,

<?xml version="1.0" encoding="utf-8"?>
<Table>
  <Row>
   <姓名>李逍遥</姓名>
   <等级>12</等级>
   <描述>《仙剑奇侠传1》男主角</描述>
   <技能>万剑诀</技能>
   <登场时间>仙剑1、仙剑2、仙剑5、仙剑5前传</登场时间>
  </Row>
  <Row>
   <姓名>慕容紫英</姓名>
   <等级>20</等级>
   <描述>《仙剑奇侠传4》男主角</描述>
   <技能>千方残光剑</技能>
   <登场时间>仙剑4</登场时间>
  </Row>
  <Row>
   <姓名>夏侯瑾轩</姓名>
   <等级>18</等级>
   <描述>《仙剑奇侠传5前传》男主角</描述>
   <技能>文星耀太虚</技能>
   <登场时间>仙剑5前传</登场时间>
  </Row>
  <Row>
   <姓名>皇甫卓</姓名>
   <等级>24</等级>
   <描述>《仙剑奇侠传5前传》配角</描述>
   <技能>天中剑</技能>
   <登场时间>仙剑5前传</登场时间>
  </Row>
</Table>

excel2unity's People

Contributors

lingjijian avatar qinyuanpei avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

excel2unity's Issues

转lua错误

生成的lua table里面的key加上了“” 报错
local datas = {
"Data" = {
{
"id" = 1,
"name" = "2",
"area" = "2",
"content" = "222",
},
{
"id" = 2,
"name" = 2,
"area" = 222,
"content" = 2,
},
}
}
return datas

把 Data id name 上面的“”去掉就好了

double \\

Hi,my excel content has some words like "Hello,\n Continue".After shifting, it comes "Hello,\n Continue" in JSON files. However ,I need it has only one "",what should I do ?

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.