Map 嵌套 List
Excel map 中嵌套 list 的规范说明。
纵向 map 中的嵌套
纵向 map 中的横向 list
HelloWorld.xlsx 中的 worksheet ItemConf：
| ID | Name | Prop1ID | Prop1Value | Prop2ID | Prop2Value |
|---|---|---|---|---|---|
| map<uint32, Item> | string | [Prop]int32 | int64 | int32 | int64 |
| Item’s ID | Item’s name | Prop1’s ID | Prop1’s value | Prop2’s ID | Prop2’s value |
| 1 | Apple | 1 | 10 | 2 | 20 |
| 2 | Orange | 3 | 30 | ||
| 3 | Banana |
生成结果：
hello_world.proto
// --snip--
option (tableau.workbook) = {name:"HelloWorld.xlsx" namerow:1 typerow:2 noterow:3 datarow:4};
message ItemConf {
option (tableau.worksheet) = {name:"ItemConf"};
map<uint32, Item> item_map = 1 [(tableau.field) = {key:"ID" layout:LAYOUT_VERTICAL}];
message Item {
uint32 id = 1 [(tableau.field) = {name:"ID"}];
string name = 2 [(tableau.field) = {name:"Name"}];
repeated Prop prop_list = 3 [(tableau.field) = {name:"Prop" layout:LAYOUT_HORIZONTAL}];
message Prop {
int32 id = 1 [(tableau.field) = {name:"ID"}];
int64 value = 2 [(tableau.field) = {name:"Value"}];
}
}
}
ItemConf.json
{
"itemMap": {
"1": {"id": 1, "name": "Apple", "propList": [{"id": 1, "value": "10"}, {"id": 2, "value": "20"}]},
"2": {"id": 2, "name": "Orange", "propList": [{"id": 3, "value": "30"}]},
"3": {"id": 3, "name": "Banana", "propList": []}
}
}
纵向 map 中的纵向 list
HelloWorld.xlsx 中的 worksheet ItemConf：
| ID | Name | PropID | PropValue |
|---|---|---|---|
| map<uint32, Item> | string | [Prop]int32 | int64 |
| Item’s ID | Item’s name | Prop’s ID | Prop’s value |
| 1 | Apple | 1 | 10 |
| 2 | Orange | 1 | 20 |
| 2 | Banana | 2 | 30 |
生成结果：
hello_world.proto
// --snip--
option (tableau.workbook) = {name:"HelloWorld.xlsx" namerow:1 typerow:2 noterow:3 datarow:4};
message ItemConf {
option (tableau.worksheet) = {name:"ItemConf"};
map<uint32, Item> item_map = 1 [(tableau.field) = {key:"ID" layout:LAYOUT_VERTICAL}];
message Item {
uint32 id = 1 [(tableau.field) = {name:"ID"}];
string name = 2 [(tableau.field) = {name:"Name"}];
repeated Prop prop_list = 3 [(tableau.field) = {layout:LAYOUT_VERTICAL}];
message Prop {
int32 prop_id = 1 [(tableau.field) = {name:"PropID"}];
int64 prop_value = 2 [(tableau.field) = {name:"PropValue"}];
}
}
}
ItemConf.json
{
"itemMap": {
"1": {"id": 1, "name": "Apple", "propList": [{"propId": 1, "propValue": "10"}]},
"2": {"id": 2, "name": "Orange", "propList": [{"propId": 1, "propValue": "20"}, {"propId": 2, "propValue": "30"}]}
}
}
纵向 map 中的 incell list
HelloWorld.xlsx 中的 worksheet ItemConf：
| ID | Prop |
|---|---|
| map<uint32, Item> | []int32 |
| Item’s ID | Item’s props |
| 1 | 10,20,30 |
| 2 | 10,20 |
| 3 | 10 |
生成结果：
hello_world.proto
// --snip--
option (tableau.workbook) = {name:"HelloWorld.xlsx" namerow:1 typerow:2 noterow:3 datarow:4};
message ItemConf {
option (tableau.worksheet) = {name:"ItemConf"};
map<uint32, Item> item_map = 1 [(tableau.field) = {key:"ID" layout:LAYOUT_VERTICAL}];
message Item {
uint32 id = 1 [(tableau.field) = {name:"ID"}];
repeated int32 prop_list = 2 [(tableau.field) = {name:"Prop" layout:LAYOUT_INCELL}];
}
}
ItemConf.json
{
"itemMap": {
"1": {"id": 1, "propList": [10, 20, 30]},
"2": {"id": 2, "propList": [10, 20]},
"3": {"id": 3, "propList": [10]}
}
}
纵向 map 中的 incell struct list
HelloWorld.xlsx 中的 worksheet ItemConf：
| ID | Item |
|---|---|
| map<uint32, Reward> | []{uint32 ID,int32 Num}Item |
| Reward’s ID | Reward’s items |
| 1 | 1001:10,1002:20,1003:30 |
| 2 | 2001:10,2002:20 |
生成结果：
hello_world.proto
// --snip--
option (tableau.workbook) = {name:"HelloWorld.xlsx" namerow:1 typerow:2 noterow:3 datarow:4};
message ItemConf {
option (tableau.worksheet) = {name:"ItemConf"};
map<uint32, Reward> reward_map = 1 [(tableau.field) = {key:"ID" layout:LAYOUT_VERTICAL}];
message Reward {
uint32 id = 1 [(tableau.field) = {name:"ID"}];
repeated Item item_list = 2 [(tableau.field) = {name:"Item" layout:LAYOUT_INCELL span:SPAN_INNER_CELL}];
message Item {
uint32 id = 1 [(tableau.field) = {name:"ID"}];
int32 num = 2 [(tableau.field) = {name:"Num"}];
}
}
}
ItemConf.json
{
"rewardMap": {
"1": {"id": 1, "itemList": [{"id": 1001, "num": 10}, {"id": 1002, "num": 20}, {"id": 1003, "num": 30}]},
"2": {"id": 2, "itemList": [{"id": 2001, "num": 10}, {"id": 2002, "num": 20}]}
}
}
横向 map 中的嵌套
横向 map 中的横向 list
HelloWorld.xlsx 中的 worksheet ItemConf：
| Reward1ID | Reward1Item1ID | Reward1Item1Num | Reward1Item2ID | Reward1Item2Num | Reward2ID | Reward2Item1ID | Reward2Item1Num |
|---|---|---|---|---|---|---|---|
| map<uint32, Reward> | [Item]uint32 | int32 | uint32 | int32 | uint32 | uint32 | int32 |
| Reward1 ID | Reward1 item1 ID | Reward1 item1 num | Reward1 item2 ID | Reward1 item2 num | Reward2 ID | Reward2 item1 ID | Reward2 item1 num |
| 1 | 1 | 10 | 2 | 20 | 2 | 3 | 30 |
生成结果：
hello_world.proto
// --snip--
option (tableau.workbook) = {name:"HelloWorld.xlsx" namerow:1 typerow:2 noterow:3 datarow:4};
message ItemConf {
option (tableau.worksheet) = {name:"ItemConf"};
map<uint32, Reward> reward_map = 1 [(tableau.field) = {name:"Reward" key:"ID" layout:LAYOUT_HORIZONTAL}];
message Reward {
uint32 id = 1 [(tableau.field) = {name:"ID"}];
repeated Item item_list = 2 [(tableau.field) = {name:"Item" layout:LAYOUT_HORIZONTAL}];
message Item {
uint32 id = 1 [(tableau.field) = {name:"ID"}];
int32 num = 2 [(tableau.field) = {name:"Num"}];
}
}
}
ItemConf.json
{
"rewardMap": {
"1": {"id": 1, "itemList": [{"id": 1, "num": 10}, {"id": 2, "num": 20}]},
"2": {"id": 2, "itemList": [{"id": 3, "num": 30}]}
}
}
横向 map 中的 incell list
HelloWorld.xlsx 中的 worksheet ItemConf：
| Reward1ID | Reward1Item | Reward2ID | Reward2Item |
|---|---|---|---|
| map<uint32, Reward> | []{uint32 ID,int32 Num}Item | uint32 | []Item |
| Reward1 ID | Reward1 items | Reward2 ID | Reward2 items |
| 1 | 1:10,2:20 | 2 | 3:30 |
对于 predefined struct list，可以使用 []{.Item} 代替 []{uint32 ID,int32 Num}Item。
生成结果：
hello_world.proto
// --snip--
option (tableau.workbook) = {name:"HelloWorld.xlsx" namerow:1 typerow:2 noterow:3 datarow:4};
message ItemConf {
option (tableau.worksheet) = {name:"ItemConf"};
map<uint32, Reward> reward_map = 1 [(tableau.field) = {name:"Reward" key:"ID" layout:LAYOUT_HORIZONTAL}];
message Reward {
uint32 id = 1 [(tableau.field) = {name:"ID"}];
repeated Item item_list = 2 [(tableau.field) = {name:"Item" layout:LAYOUT_INCELL span:SPAN_INNER_CELL}];
message Item {
uint32 id = 1 [(tableau.field) = {name:"ID"}];
int32 num = 2 [(tableau.field) = {name:"Num"}];
}
}
}
ItemConf.json
{
"rewardMap": {
"1": {"id": 1, "itemList": [{"id": 1, "num": 10}, {"id": 2, "num": 20}]},
"2": {"id": 2, "itemList": [{"id": 3, "num": 30}]}
}
}