{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sheet4 (2)","Sheet1","Sheet2","Sheet3","Sheet4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet4 (2)","index":0,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["文本","提取数字","提取英文","提取中文","其它字符",null,"提取数字","提取中文","提取英文","其它字符"]
["1红-red331.144色",{"$f":"sep($A2,0)","v":"1331.144"},{"$f":"sep($A2,1)","v":"红色"},{"$f":"sep($A2,2)","v":"red"},{"$f":"sep($A2,3)","v":"-."},null,11.1,"红色","red","-."]
["2橙-orange-12色",{"$f":"sep($A3,0)","v":"2-12"},{"$f":"sep($A3,1)","v":"橙色"},{"$f":"sep($A3,2)","v":"orange"},{"$f":"sep($A3,3)","v":"--"},null,"2-12","橙色","orange","--"]
["3黄-yellow3色","33","黄色","yellow","-","→","33","黄色","yellow","-"]
["4绿-green4色","44","绿色","green","-",null,"44","绿色","green","-"]
["5青-cyan5色","55","青色","cyan","-",null,"55","青色","cyan","-"]
["6蓝-blue6色","66","蓝色","blue","-",null,"66","蓝色","blue","-"]
["7紫-purple61.7222色",{"$f":"sep($A8,0)","v":"761.7222"},"紫色","purple","-.",null,"71.7","紫色","purple","-."]

{"sheet":"Sheet1","index":1,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["11dd"]
["$BB$6"]
["BB$6"]
["$BB$6"]

{"sheet":"Sheet2","index":2,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["红","red",null,"红-red","red",null,null,"红","red"]
["橙","orange",null,"橙-orange","orange",null,null,"橙","orange"]
["黄","yellow",null,"黄-yellow","yellow",null,null,"黄","yellow"]
["绿","green",null,"绿-green","green",null,null,"绿","green"]
["青","cyan",null,"青-cyan","cyan",null,null,"青","cyan"]
["蓝","blue",null,"蓝-blue","blue",null,null,"蓝","blue"]
["紫","purple",null,"紫-purple","purple",null,null,"紫","purple"]
[]
[]
[]
["红,red,橙12,orange,黄14,yellow,绿,green,青,cyan,蓝,blue,紫,purple,",{"$f":"myget2(A11,1,4)","v":{"$error":"#NAME?"}},null,null,null,null,null,null,{"$f":"myget2(A11,2)","v":{"$error":"#NAME?"}}]
[]
[]
[]
["￥",null,null,null,{"$f":"ASC(A15)","v":"￥"}]
[1,null,null,null,{"$f":"ASC(A16)","v":"1"}]
[2,null,null,null,"2"]
["q",null,null,null,"q"]
["v",null,null,null,"v"]
["蓝",null,null,null,"蓝"]
["紫",null,null,null,"紫"]

{"sheet":"Sheet3","index":3,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["字符","vba.asc",null,null,null,null,"vba.hex"]
["ab",97,null,null,null,null,61,54,{"$f":"ASC(B2)","v":"97"},{"$f":"_xludf.dbcs(A2)","v":{"$error":"#NAME?"}}]
["z",122,null,null,null,null,"7A",55,{"$f":"ASC(B3)","v":"122"},{"$f":"_xludf.dbcs(A3)","v":{"$error":"#NAME?"}}]
["A",65,null,null,null,null,41,52,"65",{"$error":"#NAME?"}]
["Z",90,null,null,null,null,"5A",53,"90",{"$error":"#NAME?"}]
["F",70,null,null,null,null,46,52,"70",{"$error":"#NAME?"}]
[0,48,null,null,null,null,30,51,"48",{"$error":"#NAME?"}]
[1,49,null,null,null,null,31,51,"49",{"$error":"#NAME?"}]
[9,57,null,null,null,null,39,51,"57",{"$error":"#NAME?"}]
[",",44,null,null,null,null,"2C",50,"44",{"$error":"#NAME?"}]
[".",46,null,null,null,null,"2E",50,"46",{"$error":"#NAME?"}]
["%",37,null,null,null,null,25,50,"37",{"$error":"#NAME?"}]
["，",-23636,null,null,null,null,"FFFFA3AC",70,"-23636",{"$error":"#NAME?"}]
["。",-24157,null,null,null,null,"FFFFA1A3",70,{"$f":"ASC(B14)","v":"-24157"},{"$error":"#NAME?"}]
["《",-24138,null,null,null,null,"FFFFA1B6",70,"-24138",{"$error":"#NAME?"}]
["！",-23647,null,null,null,null,"FFFFA3A1",70,"-23647",{"$error":"#NAME?"}]
["—",-24150,null,null,null,null,"FFFFA1AA",70,"-24150",{"$error":"#NAME?"}]
["……",-24147,null,null,null,null,"FFFFA1AD",70,"-24147",{"$error":"#NAME?"}]
["）",-23639,null,null,null,null,"FFFFA3A9",70,{"$f":"ASC(B19)","v":"-23639"},{"$error":"#NAME?"}]
["一",-11589,null,null,null,null,"FFFFD2BB",70,"-11589",{"$error":"#NAME?"}]
["龥",-613,null,null,null,null,"FFFFFD9B",70,"-613",{"$error":"#NAME?"}]

{"sheet":"Sheet4","index":4,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["文本","提取数字","提取英文","提取中文",null,"文本","提取数字","提取英文","提取中文"]
["1红-red1.1色。",{"$f":"septxt(A2,0)","v":111},{"$f":"septxt(A2,1)","v":"红色。"},{"$f":"septxt(A2,2)","v":"red"},null,"1红-red1色",11,"红色","red",{"$f":"sep($A2,0)","v":"11.1"},{"$f":"sep($A2,1)","v":"红色"},{"$f":"sep($A2,2)","v":"red"},{"$f":"sep($A2,3)","v":"-.。"}]
["2橙-orange-12色",{"$f":"septxt(A3,0)","v":212},{"$f":"septxt(A3,1)","v":"橙色"},{"$f":"septxt(A3,2)","v":"orange"},null,"2橙-orange2色",22,"橙色","orange",{"$f":"sep($A3,0)","v":"2-12"},{"$f":"sep($A3,1)","v":"橙色"},{"$f":"sep($A3,2)","v":"orange"},{"$f":"sep($A3,3)","v":"--"}]
["3黄-yellow3色",33,"黄色","yellow","→","3黄-yellow3色",33,"黄色","yellow","33","黄色","yellow","-"]
["4绿-green4色",44,"绿色","green",null,"4绿-green4色",44,"绿色","green","44","绿色","green","-"]
["5青-cyan5色",55,"青色","cyan",null,"5青-cyan5色",55,"青色","cyan","55","青色","cyan","-"]
["6蓝-blue6色",66,"蓝色","blue",null,"6蓝-blue6色",66,"蓝色","blue","66","蓝色","blue","-"]
["7紫-purple1.7色",717,"紫色","purple",null,"7紫-purple7色",77,"紫色","purple","71.7","紫色","purple","-."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"StringType"]
[]
[null,null,null,null,null,"提取文字，B1输入公式=sep(\"[一-龥]\",$A2)"]
[null,null,null,null,null,"提取字母，C1输入公式=sep(\"[a-zA-Z]\",$A2)"]
[null,null,null,null,null,"提取数字，D1输入公式=sep(\"\\d\",$A2)"]
[null,null,null,null,null,"提取符号，E1输入公式=sep(\"[^a-zA-Z0-9\\u4e00-\\u9fff\\+]\",$A2)"]