{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["使用公式和函数","Sheet1"],"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":"使用公式和函数","index":0,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["华北区","华南","西北","西南","合计","权重"]
[200,201,202,203,{"$f":"SUM(A2:D22)","v":8712},1.2,{"$f":"E2:E10*F2:F10","v":10454.4},"application.path",null,"C:\\Program Files\\Microsoft Office\\Office12"]
[201,202,203,204,{"$f":"SUM(A3:D32)","v":7906},1.2,9487.1999999999989,"ActiveWorkbook.Path",null,"F:\\website\\witisopc\\42vba\\实例\\公司应用"]
[202,203,204,300,{"$f":"SUM(A4:D42)","v":7096},1.2,8515.1999999999989,"Application.StartupPath",null,"C:\\Users\\wwuhnwu01\\AppData\\Roaming\\Microsoft\\Excel\\XLSTART"]
[203,204,203,204,{"$f":"SUM(A5:D52)","v":6187},1.2,7424.4,null,null,"10.198.1.3\r\n   "]
[204,300,204,300,{"$f":"SUM(A6:D62)","v":5373},1.2,6447.5999999999995]
[300,301,300,301,{"$f":"SUM(A7:D72)","v":4365},1.2,5238]
[301,203,301,203,{"$f":"SUM(A8:D82)","v":3163},1.2,3795.6]
[302,204,302,204,{"$f":"SUM(A9:D92)","v":2155},1.2,2586]
[303,300,204,300,{"$f":"SUM(A10:D102)","v":1143},1.2,1371.6]
[null,null,null,null,{"$f":"SUM(E2:E10)","v":46100},null,{"$f":"SUM(G2:G10)","v":55319.999999999993}]
[null,null,"fname = Range(\"A13\").Value"]
["VBA综合.xlsm",null,".Range(\"A13\") = ActiveWorkbook.Name",null,null,null,null,null,null,"个人宏工作簿Personal.xls(b)(系统默认是没有的，属于用户新建至此)"]
[6,null,".Range(\"A14\") = InStr(ActiveWorkbook.Name, \".\")",null,null,null,null,null,null,"C:\\Users\\wwuhnwu01\\AppData\\Roaming\\Microsoft\\Excel\\XLSTART"]
[6,null,".Range(\"A15\") = InStr([A13], \".\")",null,null,null,null,null,null,"上面文件夹中的文件随Excel文件一起打开；"]
[{"$f":"FIND(\".\",A13,1)","v":6},null,".Range(\"A16\") = \"=find(\"\".\"\",A13,1)\"",null,null,null,null,null,null,"加载项addins，.xlam"]
[6,null,".Range(\"A17\") = InStr(fname, \".\")",null,null,null,null,null,null,"C:\\Users\\wwuhnwu01\\AppData\\Roaming\\Microsoft\\AddIns(2007)"]
[6,null,".Range(\"A18\") = Application.WorksheetFunction.Find(\".\", fname, 1)"]
[6,null,".Range(\"A19\") = Application.WorksheetFunction.Find(\".\", [A13], 1)"]

{"sheet":"Sheet1","index":1,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["数据透视表"]
[]
["水平并排/垂直并排显示透视字段：选项→选项→布局；"]
["字段名称如何去除“求和项：”"]
["在“编辑栏”中删除“求和项”，再在文本的最后输入一个空格；"]
[]
["'C:\\Users\\wwuhnwu01\\AppData\\Roaming\\Microsoft\\Excel\\XLSTART"]
["'可以像普通工作簿一样显示和隐藏个人宏工作簿。如果该工作簿是隐藏的，用下面的方法取消其隐藏："]
["' Excel 2007：在功能区中选择“视图”选项卡，在“窗口”组中单击“取消隐藏”按钮，弹出“取消隐藏”对话框，选择“PERSONAL.XLSB”，单击“确定”按钮。"]
["'加载项addins，.xlam"]
["'C:\\Users\\wwuhnwu01\\AppData\\Roaming\\Microsoft\\AddIns(2007)"]
["'C:\\Program Files\\Microsoft Office\\Office12\\XLSTART"]