excel数据有效性中突破序列源数据的限制的方法

[[{"txt": "\u6570\u636e\u6709\u6548\u6027\u8bbe\u7f6e\u65f6\u8981\u6c42\uff0c\u5e8f\u5217\u6e90\u6570\u636e\u533a\u5fc5\u987b\u662f\u5355\u884c\u6216\u5355\u5217\u7684\u3002\u90a3\u4e48\u5982\u4f55\u5c06\u591a\u5217\u6570\u636e\u51fa\u73b0\u5728\u5e8f\u5217\u5217\u8868\u4e2d\u5462\uff1f"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "\u5e8f\u5217\u6e90\u6570\u636e\u533a\u5fc5\u987b\u662f\u5355\u884c\u6216\u5355\u5217\u7684\u3002\u5982\u56fe\uff0c\u5982\u679c\u9009\u62e9\u591a\u5217\u533a\u57df\u7684\u8bdd\u4f1a\u5f39\u51fa\u8b66\u544a\u7a97\u53e3\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/e0c73a2fa872941fe648e2697b5e4a237871e603.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u9996\u5148\u5c06\u5355\u884c\u6216\u5355\u5217\u533a\u57df\u8bbe\u7f6e\u4e00\u4e2a\u540d\u79f0\uff0c\u9009\u62e9\u5355\u884c\u6216\u5355\u5217\u533a\u57df\u540e\uff0c\u76f4\u63a5\u5728\u540d\u79f0\u6846\u8f93\u5165\u540d\u79f0\u540e\u56de\u8f66\u5c31\u53ef\u4ee5\u4e86\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/f11f54237971fe1dc874ceaaea20a7cd0d6ee003.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u8bbe\u7f6e\u6570\u636e\u6709\u6548\u6027\uff0c\u6765\u6e90\u533a\u57df\u8bbe\u7f6e\u4e3a\u8be5\u540d\u79f0\u3002\u672c\u4eba\u7528\u7684\u662fExcel 2013 \u5176\u5b9e\u6570\u636e\u6709\u6548\u6027\u5c31\u662f\u6570\u636e\u9a8c\u8bc1\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/a68c126efbf202b3107b4fc830f4da5873dadb03.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5728\u201c\u516c\u5f0f\u201d\u9009\u9879\u5361\uff0c\u9009\u62e9\u201c\u540d\u79f0\u7ba1\u7406\u5668\u201d\u4e5f\u53ef\u4ee5\u76f4\u63a5\u7528ctrl+F3\u76f4\u63a5\u6253\u5f00\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/db196cdade49610fe7fa7bb7a56817e950e1d203.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5728\u201c\u540d\u79f0\u7ba1\u7406\u5668\u201d\u4e2d\uff0c\u91cd\u65b0\u7f16\u8f91\u201c\u540d\u79f0\u201d\u7684\u6570\u636e\u533a\uff0c\u4f7f\u4e4b\u5305\u62ec\u591a\u884c\u6216\u591a\u5217"}, {"img": ["https://exp-picture.cdn.bcebos.com/5917cb3da824d8e9ba7e6dd5da598540112ac803.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u73b0\u5728\u4f60\u4f1a\u53d1\u73b0\u73b0\u5728\u6570\u636e\u6709\u6548\u6027\u4e0b\u62c9\u5217\u8868\u5df2\u7ecf\u5305\u542b\u591a\u4e2a\u6570\u636e\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/05a320a23a42a07adfbc6a80673834bb18efc103.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}]]