写回Excel高级参数应用

11

		{"id": 2,"table": 0,"column": 0,"row": 0,"sheet": "MAIN","method": 9,"range": "B7",
		"expand": {
			"formater": [
				{"column": 0,"fontname": "黑体","fontsize": 20,"fontcolor": 13551615},
				{"column": 1,"fontsize": 15,"fontcolor": -16383844}
			],
			"subtotal": {
				"totalcol": [
					{"column": 1,"fontname": "黑体","fontsize": 16}
				],
				"calculate": [
					{"column": 3,"method": "MIN","fontname": "黑体","fontsize": 16,"fontcolor": -16383844},
					{"column": 4,"method": "SUM","fontname": "黑体","fontsize": 16,"fontcolor": -16383844}
				]
			},
			"merge": [0,1]
			}
		},

11

	{"id": 5,"table": 0,"column": 0,"row": 0,"sheet": "NEW","method": 101,"range": "A0:E1[LAST]",
		"expand": {
			"sheet": "TPL",
			"range": "A1:F2"
		}
	},

11

	{"id": 6,"table": 0,"column": 0,"row": 0,"sheet": "NEW","method": 9,"range": "A0[LAST]",
		"expand": {
			"merge": [0, 1],
			"copyformat" :{"sheet":"TPL", "range":"A4:F4"},
			
			
		}
	},

11

	{"id": 7,"table": 0,"column": 0,"row": 0,"sheet": "NEW","method": 101,"range": "A2:E3[LAST]",
		"expand": {
			"sheet": "TPL",
			"range": "A1:F2"
		}
	},

11

	{"id": 8,"table": 0,"column": 0,"row": 0,"sheet": "NEW","method": 9,"range": "A0[LAST]",
		"expand": {
			"merge": [0, 1],
			
		}
	}