{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Mail","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":"Mail","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Party Name",{"$f":"A9","v":"abc ltd"}]
["Total Payment",{"$f":"GETPIVOTDATA(\"Payment Amt\",$A$7,\"Party's Name\",B1)","v":1579327}]
["Payment Date","2015-03-13"]
["Email ID To:",{"$f":"VLOOKUP(B1,Table2[[Party''s Name]:[Email ID]],6,FALSE)","v":"abc@gmail.com"}]
["Additional Message:"]
[]
[null,null,null,"Values"]
["Party's Name","Remarks/Bill No.","Bill Date","Bill Amt","Payment Amt"]
["abc ltd","659","2014-12-28",23724,23724]
[null,"662","2014-12-30",483219,483219]
[null,"673","2015-01-02",1072384,1072384]
["abc ltd Total",null,null,1579327,1579327]
["Grand Total",null,null,1579327,1579327]

{"sheet":"Data","index":1,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Voucher No.","Party's Name","Bill No.","Bill Date","Bill Amt.","Payment","Email ID"]
["G1/1415/PRV006686","abc ltd","662","2014-12-30",483219,483219,"abc@gmail.com"]
["G1/1415/PRV006703","abc ltd","673","2015-01-02",1072384,1072384,"abc@gmail.com"]
["G1/1415/PRV006737","abc ltd","659","2014-12-28",23724,23724,"abc@gmail.com"]
["G1/1415/PRV006705","xyz pvt ltd","428","2014-12-30",22463,22463,"xyz@gmail.com"]
["G1/1415/PRV007136","xyz pvt ltd","491","2015-01-23",28079,28079,"xyz@gmail.com"]
["G1/1415/PRV006704","xyz pvt ltd","1814","2015-01-01",112572,112572,"xyz@gmail.com"]
["G1/1415/PRV006739","xyz pvt ltd","1145","2014-12-31",8101,8101,"xyz@gmail.com"]
["G1/1415/PRV006740","pqr enterprise","1146","2014-12-31",67841,67841,"pqr@gmail.com"]
["G1/1415/PRV007137","pqr enterprise","1185","2015-01-13",104980,104980,"pqr@gmail.com"]
["G1/1415/GRV001647","pqr enterprise","5199","2014-12-25",59567,59567,"pqr@gmail.com"]
["G1/1415/GRV001648","pqr enterprise","5200","2014-12-25",59567,59567,"pqr@gmail.com"]
["G1/1415/GRV001623","pqr enterprise","5116","2014-12-21",59567,59567,"pqr@gmail.com"]
["G1/1415/GRV001624","htp corporation","5117","2014-12-21",36101,36101,"htp@gmail.com"]
["G1/1415/GRV001625","htp corporation","5118","2014-12-21",36101,36101,"htp@gmail.com"]
["G1/1415/GRV001650","htp corporation","5215","2014-12-26",59567,59567,"htp@gmail.com"]