Infinite nesting
Excel infinite nesting features of composite types.
Overview
Now, the horizontal/vertical list element’s first field can be any type, even as struct, list, and map.
- List element’s first field is struct:
[Reward]{Icon}int32 - List element’s first field is predefined struct:
[Cost]{.Item}uint32 - List element’s first field is in-cell struct:
[Magic]{int32 Id, int32 Num}Ability - List element’s first field is list:
[Reward][Item]uint32 - List element’s first field is list with element as predefined struct:
[Power][.Item]uint32 - List element’s first field is map:
[Superpower]map<uint32, Ability>
TODO: some clear examples.
Nested naming
Predefined types in “common.proto”:
// --snip--
enum ConfType {
CONF_TYPE_UNKNOWN = 0 [(tableau.evalue).name = "Unknown"];
CONF_TYPE_CLOUD = 1 [(tableau.evalue).name = "Cloud"];
CONF_TYPE_LOCAL = 2 [(tableau.evalue).name = "Local"];
CONF_TYPE_REMOTE = 3 [(tableau.evalue).name = "Remote"];
}
enum ServerType {
SERVER_TYPE_UNKNOWN = 0 [(tableau.evalue).name = "Unknown"];
SERVER_TYPE_GAME = 1 [(tableau.evalue).name = "GameServer"];
SERVER_TYPE_ACTIVITY = 2 [(tableau.evalue).name = "ActivityServer"];
SERVER_TYPE_MATCH = 3 [(tableau.evalue).name = "MatchServer"];
}
| ServerType | ServerConfType | ServerConfConditionType | ServerConfConditionValue |
|---|---|---|---|
| map<enum<.ServerType>, Server> | [Conf]<enum<.ConfType» | [Condition] | int32 |
| Server name | Sheet name | Condition type | Condition value |
| SERVER_TYPE_GAME | CONF_TYPE_CLOUD | 0 | 113 |
| 0 | 134 | ||
| SERVER_TYPE_ACTIVITY | CONF_TYPE_CLOUD | ||
| 1 | |||
| CONF_TYPE_LOCAL | 9 | 34 | |
| CONF_TYPE_LOCAL | 9 | 12 | |
| CONF_TYPE_LOCAL | |||
| Remote | |||
| MatchServer | CONF_TYPE_UNKNOWN |
| Sheet | Nested |
|---|---|
| LoaderConf | true |
Generated:
hello_world.proto
// --snip--
import "common.proto";
option (tableau.workbook) = {name:"HelloWorld.xlsx"};
message LoaderConf {
option (tableau.worksheet) = {name:"LoaderConf" namerow:1 typerow:2 noterow:3 datarow:4 nested:true};
map<int32, Server> server_map = 1 [(tableau.field) = {name:"Server" key:"Type" layout:LAYOUT_VERTICAL}];
message Server {
ServerType type = 1 [(tableau.field) = {name:"Type"}];
repeated Conf conf_list = 2 [(tableau.field) = {name:"Conf" key:"Type" layout:LAYOUT_VERTICAL}];
message Conf {
ConfType type = 1 [(tableau.field) = {name:"Type"}];
repeated Condition condition_list = 2 [(tableau.field) = {name:"Condition" key:"Type" layout:LAYOUT_VERTICAL}];
message Condition {
int32 type = 1 [(tableau.field) = {name:"Type"}];
int32 value = 2 [(tableau.field) = {name:"Value"}];
}
}
}
}
loader_conf.json
{
"serverMap": {
"1": {
"type": "SERVER_TYPE_GAME",
"confList": [
{
"type": "CONF_TYPE_CLOUD",
"conditionList": [
{
"type": 0,
"value": 113
}
]
}
]
},
"2": {
"type": "SERVER_TYPE_ACTIVITY",
"confList": [
{
"type": "CONF_TYPE_CLOUD",
"conditionList": []
},
{
"type": "CONF_TYPE_LOCAL",
"conditionList": [
{
"type": 9,
"value": 34
}
]
},
{
"type": "CONF_TYPE_REMOTE",
"conditionList": []
}
]
},
"3": {
"type": "SERVER_TYPE_MATCH",
"confList": []
}
}
}