本帖最后由 feichunhuan 于 2024-6-21 13:39 编辑
求助内容如下:
现在是将JSON格式的数据存在活字格表的字符字段中,通过对象操作命令将JSON数据做抽取、合并等操作,当JSON内容的字符数很多的时候,打开活字格表性能变得非常慢,处于几乎卡死的状态,将来数据多了,更无法想象。
看看能不能将JSON作为文件存在服务器上,然后通过活字格的什么命令对其读取并进行处理,比如下面JSON格式的数据文件有3个,fin.json,mkt.json以及pm.json ,需要拿到fin.json,mkt.json以及pm.json 3个文件中的FIN sheet,MKT sheet和PM sheet,然后合并成一个新的combined.json文件,新的combined.json
用文件处理只是一种方式,如果有更好的处理方式当然更好,还请大佬们出手相助,十分感谢!
{
"version": "16.0.6",
"sheetCount": 6,
"customList": [],
"activeSheetIndex": 2,
"sheets": {
"PM": {
"name": "PM",
"isSelected": true,
"visible": 0,
"frozenTrailingRowStickToEdge": true,
"frozenTrailingColumnStickToEdge": true,
"theme": "Office",
"data": {
"dataTable": {
"1": {
"0": {
"value": "Product"
},
"1": {
"value": "AAA",
"style": {
"hAlign": 2
}
}
},
"2": {
"0": {
"value": "Start Year"
},
"1": {
"value": 2025
}
},
"3": {
"0": {
"value": "Predict Years"
},
"1": {
"value": 10
}
}
},
"defaultDataNode": {
"style": {
"themeFont": "Body"
}
}
},
"rowHeaderData": {
"defaultDataNode": {
"style": {
"themeFont": "Body"
}
}
},
"colHeaderData": {
"defaultDataNode": {
"style": {
"themeFont": "Body"
}
}
},
"columns": [
{
"size": 80
}
],
"leftCellIndex": 0,
"topCellIndex": 0,
"selections": {
"0": {
"row": 0,
"col": 0,
"rowCount": 1,
"colCount": 1
},
"length": 1
},
"rowOutlines": {
"items": []
},
"columnOutlines": {
"items": []
},
"cellStates": {},
"states": {},
"outlineColumnOptions": {},
"autoMergeRangeInfos": [],
"shapeCollectionOption": {
"snapMode": 0
},
"printInfo": {
"paperSize": {
"width": 850,
"height": 1100,
"kind": 1
}
},
"index": 0
},
"FIN": {
"name": "FIN",
"isSelected": true,
"visible": 0,
"frozenTrailingRowStickToEdge": true,
"frozenTrailingColumnStickToEdge": true,
"theme": "Office",
"data": {
"dataTable": {
"1": {
"0": {
"value": "Base Price"
},
"1": {
"value": 1000
}
}
},
"defaultDataNode": {
"style": {
"themeFont": "Body"
}
}
},
"rowHeaderData": {
"defaultDataNode": {
"style": {
"themeFont": "Body"
}
}
},
"colHeaderData": {
"defaultDataNode": {
"style": {
"themeFont": "Body"
}
}
},
"columns": [
{
"size": 64
}
],
"leftCellIndex": 0,
"topCellIndex": 0,
"selections": {
"0": {
"row": 0,
"col": 0,
"rowCount": 1,
"colCount": 1
},
"length": 1
},
"rowOutlines": {
"items": []
},
"columnOutlines": {
"items": []
},
"cellStates": {},
"states": {},
"outlineColumnOptions": {},
"autoMergeRangeInfos": [],
"shapeCollectionOption": {
"snapMode": 0
},
"printInfo": {
"paperSize": {
"width": 850,
"height": 1100,
"kind": 1
}
},
"index": 1
},
"MKT": {
"name": "MKT",
"isSelected": true,
"visible": 1,
"frozenTrailingRowStickToEdge": true,
"frozenTrailingColumnStickToEdge": true,
"theme": "Office",
"data": {
"dataTable": {
"1": {
"0": {
"value": "Volume"
},
"1": {
"value": 500
}
}
},
"defaultDataNode": {
"style": {
"themeFont": "Body"
}
}
},
"rowHeaderData": {
"defaultDataNode": {
"style": {
"themeFont": "Body"
}
}
},
"colHeaderData": {
"defaultDataNode": {
"style": {
"themeFont": "Body"
}
}
},
"leftCellIndex": 0,
"topCellIndex": 0,
"selections": {
"0": {
"row": 0,
"col": 0,
"rowCount": 1,
"colCount": 1
},
"length": 1
},
"rowOutlines": {
"items": []
},
"columnOutlines": {
"items": []
},
"cellStates": {},
"states": {},
"outlineColumnOptions": {},
"autoMergeRangeInfos": [],
"shapeCollectionOption": {
"snapMode": 0
},
"printInfo": {
"paperSize": {
"width": 850,
"height": 1100,
"kind": 1
}
},
"index": 2
},
},
"sheetTabCount": 0,
"pivotCaches": {}
}
|