Coder Social home page Coder Social logo

zhangqi-ulua / xlsxtolua Goto Github PK

View Code? Open in Web Editor NEW
668.0 668.0 245.0 43.24 MB

Excel表格数据导出为Lua table、csv、json形式的工具,兼带数据检查功能以及导出、导入MySQL数据库功能

License: GNU General Public License v2.0

C# 93.50% Lua 4.36% Batchfile 0.03% Java 2.11%

xlsxtolua's People

Contributors

newcoder7777 avatar zhangqi-ulua 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  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

xlsxtolua's Issues

屏蔽lua table格式数据的导出

工具既然可以支持多种格式的数据导出,以及格式可选;为什么不能屏蔽lua table的导出,目前好像是必须导出lua格式的数据

一个小的关于dictionary的想法

齐王殿下,见信好
目前的Excel-Lua的解析工具,在配置技能时,不得不使用param1, param2此类的名称,添加注释如"攻击范围",再在脚本中自行根据需求使用。看起来是一个很不优雅的过程需要两边对照使用非常麻烦,而且一旦注释没有及时更新很容易出错。
鉴于lua table的灵活的能力,想必是可以实现真正的dictionary的,即

  • dictionary首列填写名称dict1,类型(dictionary),对应的每行填写key-value pair的数量N,或将N标记在类型的后面
  • 后续的N*2列中,两列为一组,第一列填写string类型的值作为key,第二列填写value,通常float可以满足需求。
  • 再后续的列正常填写即可

假设下表为LogicDataSkill的一部分

技能id 技能参数 耗蓝
id skillParams cost
int dictionary:[2] string float string float int
101 range 5.2 damage 170 150
102 speed 0.8 distance 350 220
103 cooldown 15 enemyNum 4 1130

在lua中使用时,即可直接调用

local skillId = 101
local skillData = logicDataSkill[skillId]
local demage = skillData.skillParams.damage

这样就不依赖param1,param2的顺序和注释,可任意调整次序,调整参数数量,策划填写和程序使用都会非常方便。

不知以上方案是否可行,还请齐王殿下不吝赐教

已添加-exportKeepDirectoryStructure 能否忽略原表格重名呢

添加-exportKeepDirectoryStructure参数本意便是为了方便进行表格分类,已经能够避免了重名

我理解只添加-exportIncludeSubfolder的情况会出现重名冲突

-exportIncludeSubfolder 和 -exportKeepDirectoryStructure 一起出现的情况是否可以忽略重复呢

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.