Excel数据转换为JSON格式数据
Excel数据
user.xlsx[MainSheet]
id name gender
1 jack male
user.xlsx[AddressSheet]
id name city details
1 home hefei xxxxx
1 office nanjing yyyyy
user.xlsx[ExtraSheet]
id intro description
1 jack-intro jack-description
ToJsonMetadata = { selfName:users, fileName:user.xlsx, sheetName:MainSheet, idColun:1, headerRows:1 }
MergeToJson, 一对多合并, 将子数据以selfWith指定列的字段内容作为字段名合并至主数据,
如下示例的主数据多了home/office两个字段
MergeToJson = { selfWith:2, sheetName:AddressSheet, idField:1, headerRows:1 }
users:[ { id:1, name:jack, home:{ city:hefei, details:xxxxx }, office:{ city:nanjing, details:yyyyy } } ]
MergeToJson, 一对一合并, 未指定selfWith而是指定了selfName, 则将子数据列表以selfName指定的字段名合并至主数据,
如果子数据有多条后出现的会覆盖前面的, 如下示例的主数据多了address字段, home数据被office覆盖了
MergeToJson = { selfName:address, sheetName:AddressSheet, idField:1, headerRows:1 }
users:[ { id:1, name:jack, address:{ name:office, city:nanjing, details:yyyyy } } ]
MergeToList, 一对多合并, 将子数据列表以selfName指定的字段名合并至主数据,
如下示例的主数据多了address字段, 内容为子数据列表
MergeToJson = { selfName:address, sheetName:AddressSheet, idField:1, headerRows:1 }
users:[ { id:1, name:jack, address:[{ name:home, city:hefei, details:xxxxx }, { name:office, city:nanjing, details:yyyyy }] } ]
MergeToField, 一对一合并, 将子数据所有字段合并至主数据, 如下示例的主数据会具有子数据的所有字段
MergeToField = { sheetName:ExtraShee, idField:1, headerRows:1 }
users:[ { id:1, name:jack, intro:jack-intro, description:jack-description } ]