{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet7 (2)","Sheet7"],"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":"Sheet7 (2)","index":0,"n_rows":63,"n_cols":15,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,8,0,14]]}
["Raw Data"]
["DATE","DOC.#","FULL DOC. NO.","DOC.QTY","RATE","AMOUNT",null,"Customer","Product","DATE","DOC.#","FULL DOC. NO.","DOC.QTY","RATE","AMOUNT"]
[]
["* INJECT FOLINE 9830 *"]
["* INKBANK. *"]
["2015-12-04",5192,"PCF/15-16/05192",6,110,660]
["Product Total :",null,null,6,null,660]
[]
["Party Total :",null,null,6,null,660]
[]
["* PROJ .LTD-98317518 9331222 *"]
["* Spare *"]
["2015-12-17",5486,"PCF/15-16/05486",4,8500,34000]
["2015-12-14",5388,"PCF/15-16/05388",3,105,5250]
["Product Total :",null,null,7,null,34000]
[]
["* QSERIES/345 23 *"]
["2015-12-11",5344,"PCF/15-16/05344",1,4200,4200]
["Product Total :",null,null,1,null,4200]
[]
["Party Total :",null,null,8,null,38200]
[]
["* BAL Sundar *"]
["* CART 80  *"]
["2015-12-03",5151,"PCF/15-16/05151",50,105,5250]
["Product Total :",null,null,50,null,5250]
[]
["Party Total :",null,null,50,null,5250]
[]
["* CALTRO INDIA 004195 *"]
["* Wifi Spares. *"]
["2015-12-03",5165,"PCF/15-16/05165",1,110,110]
["Product Total :",null,null,1,null,110]
[]
["* CAR INJECTION. *"]
["2015-12-17",5464,"PCF/15-16/05464",2,122,244]
["Product Total :",null,null,2,null,244]
[]
["Party Total :",null,null,3,null,354]
[]
["* COMP. SOR *"]
["* ELIET. *"]
["2015-12-07",5243,"PCF/15-16/05243",4,110,440]
["Product Total :",null,null,4,null,440]
[]
["* Mother Board. *"]
["2015-12-07",5243,"PCF/15-16/05243",4,120,480]
["Product Total :",null,null,4,null,480]
[]
["* Head *"]
["2015-12-10",5324,"PCF/15-16/05324",1,1750,1750]
["Product Total :",null,null,1,null,1750]
[]
["* RIBBON PLATINA *"]
["2015-12-03",5157,"PCF/15-16/05157",1,850,850]
["Product Total :",null,null,1,null,850]
[]
["Party Total :",null,null,10,null,3520]
[]
[]
["Grand Total :",null,null,77,null,47984]
[]
["END OF REPORT"]

{"sheet":"Sheet7","index":1,"n_rows":62,"n_cols":15,"rows_kept":62,"cut":false,"hidden":false,"merged":[[0,7,0,14],[0,0,0,5]]}
["Raw Data",null,null,null,null,null,null,"Can we transform the data as below format from raw Data"]
["DATE","DOC.#","FULL DOC. NO.","DOC.QTY","RATE","AMOUNT",null,"Customer","Product","DATE","DOC.#","FULL DOC. NO.","DOC.QTY","RATE","AMOUNT"]
[null,null,null,null,null,null,null,"* INJECT FOLINE 9830 *","* INKBANK. *","2015-12-04",5192,"PCF/15-16/05192",6,110,660]
["* INJECT FOLINE 9830 *",null,null,null,null,null,null,"* PROJ .LTD-98317518 9331222 *","* Spare *","2015-12-17",5486,"PCF/15-16/05486",4,8500,34000]
["* INKBANK. *",null,null,null,null,null,null,"* PROJ .LTD-98317518 9331222 *","* QSERIES/345 23 *","2015-12-11",5344,"PCF/15-16/05344",1,4200,4200]
["2015-12-04",5192,"PCF/15-16/05192",6,110,660,null,"* BAL Sundar *","* CART 80  *","2015-12-03",5151,"PCF/15-16/05151",50,105,5250]
["Product Total :",null,null,6,null,660,null,"."]
[null,null,null,null,null,null,null,"."]
["Party Total :",null,null,6,null,660,null,"."]
[null,null,null,null,null,null,null,"."]
["* PROJ .LTD-98317518 9331222 *",null,null,null,null,null,null,"."]
["* Spare *",null,null,null,null,null,null,"."]
["2015-12-17",5486,"PCF/15-16/05486",4,8500,34000,null,"."]
["Product Total :",null,null,4,null,34000,null,"etc."]
[]
["* QSERIES/345 23 *"]
["2015-12-11",5344,"PCF/15-16/05344",1,4200,4200]
["Product Total :",null,null,1,null,4200]
[]
["Party Total :",null,null,5,null,38200]
[]
["* BAL Sundar *"]
["* CART 80  *"]
["2015-12-03",5151,"PCF/15-16/05151",50,105,5250]
["Product Total :",null,null,50,null,5250]
[]
["Party Total :",null,null,50,null,5250]
[]
["* CALTRO INDIA 004195 *"]
["* Wifi Spares. *"]
["2015-12-03",5165,"PCF/15-16/05165",1,110,110]
["Product Total :",null,null,1,null,110]
[]
["* CAR INJECTION. *"]
["2015-12-17",5464,"PCF/15-16/05464",2,122,244]
["Product Total :",null,null,2,null,244]
[]
["Party Total :",null,null,3,null,354]
[]
["* COMP. SOR *"]
["* ELIET. *"]
["2015-12-07",5243,"PCF/15-16/05243",4,110,440]
["Product Total :",null,null,4,null,440]
[]
["* Mother Board. *"]
["2015-12-07",5243,"PCF/15-16/05243",4,120,480]
["Product Total :",null,null,4,null,480]
[]
["* Head *"]
["2015-12-10",5324,"PCF/15-16/05324",1,1750,1750]
["Product Total :",null,null,1,null,1750]
[]
["* RIBBON PLATINA *"]
["2015-12-03",5157,"PCF/15-16/05157",1,850,850]
["Product Total :",null,null,1,null,850]
[]
["Party Total :",null,null,10,null,3520]
[]
[]
["Grand Total :",null,null,74,null,47984]
[]
["END OF REPORT"]