{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"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":"Sheet1","index":0,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,2,2,2]]}
[null,{"$f":"\"\"","v":""},"右边测试excel单元格内函数对于“空值”的处理","B1=0",{"$f":"IF(B1=0,1,0)","v":0},"B1=\"\"",{"$f":"IF(B1=\"\",1,0)","v":1},"B1*1=0",{"$f":"IF(B1*1=0,1,0)","v":{"$error":"#VALUE!"}},{"$f":"3&B1&2","v":"32"},"=3&B1&2"]
[null,"\"\"",null,"B2=0",{"$f":"IF(B2=0,1,0)","v":0},"B2=\"\"",{"$f":"IF(B2=\"\",1,0)","v":0},"B2*1=0",{"$f":"IF(B2*1=0,1,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(J1=32,\"可以为真\")","v":false},"=IF(I1=32)"]
[null,null,null,"B3=0",{"$f":"IF(B3=0,1,0)","v":1},"B3=\"\"",{"$f":"IF(B3=\"\",1,0)","v":1},"B3*1=0",{"$f":"IF(B3*1=0,1,0)","v":1}]
[null,null,null,null,null,"B2=\"\"\"\"\"\"",{"$f":"IF(B2=\"\"\"\"\"\",1,0)","v":1}]
[null,null,null,"是否等于0",null,"是否等于空字符",null,"是否可以数学运算"]
[null,null,"结论：","这边的测试结果和vba代码中的测试结果是一致的。"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}