{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["威凤"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["仓库耗材代码（WMS）","品名","规格","个","卷","板","订单内耗"]
[1,"1#化妆盒","16*10.8*9.6",2,0,0,0,"mrc000000000000000486",{"$f":"CONCATENATE(\"insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)\")","v":"insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)"},{"$f":"CONCATENATE(\"values('\",H2,\"','mhbs615586058663510016','00','00','\",B2,\"','\",C2,\"','\",A2,\"',\",D2,\",\",E2,\",\",F2,\",0,0);\")","v":"values('mrc000000000000000486','mhbs615586058663510016','00','00','1#化妆盒','16*10.8*9.6','1',2,0,0,0,0);"}]
[2,"2#化妆盒","22*15*10",2.8,0,0,0,"mrc000000000000000487",{"$f":"CONCATENATE(\"insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)\")","v":"insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)"},{"$f":"CONCATENATE(\"values('\",H3,\"','mhbs615586058663510016','00','00','\",B3,\"','\",C3,\"','\",A3,\"',\",D3,\",\",E3,\",\",F3,\",0,0);\")","v":"values('mrc000000000000000487','mhbs615586058663510016','00','00','2#化妆盒','22*15*10','2',2.8,0,0,0,0);"}]
[3,"3#化妆盒","26*15*18",3.7,0,0,0,"mrc000000000000000488","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)","values('mrc000000000000000488','mhbs615586058663510016','00','00','3#化妆盒','26*15*18','3',3.7,0,0,0,0);"]
[4,"N1","32*20*27",6,0,0,0,"mrc000000000000000489","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)","values('mrc000000000000000489','mhbs615586058663510016','00','00','N1','32*20*27','4',6,0,0,0,0);"]
[5,"N2","40*32*27",10.1,0,0,0,"mrc000000000000000490","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)","values('mrc000000000000000490','mhbs615586058663510016','00','00','N2','40*32*27','5',10.1,0,0,0,0);"]
[6,"N3","48*40*27",12.5,0,0,0,"mrc000000000000000491","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)","values('mrc000000000000000491','mhbs615586058663510016','00','00','N3','48*40*27','6',12.5,0,0,0,0);"]
[7,"N4","40*32*54",13,0,0,0,"mrc000000000000000492","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)","values('mrc000000000000000492','mhbs615586058663510016','00','00','N4','40*32*54','7',13,0,0,0,0);"]
["5#","5#纸箱","35*25*19",6,0,0,0,"mrc000000000000000493","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)","values('mrc000000000000000493','mhbs615586058663510016','00','00','5#纸箱','35*25*19','5#',6,0,0,0,0);"]
["6#","6#纸箱","43*21*27",10.1,0,0,0,"mrc000000000000000494","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)","values('mrc000000000000000494','mhbs615586058663510016','00','00','6#纸箱','43*21*27','6#',10.1,0,0,0,0);"]
["7#","7#纸箱","50*35*19",12.5,0,0,0,"mrc000000000000000495","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)","values('mrc000000000000000495','mhbs615586058663510016','00','00','7#纸箱','50*35*19','7#',12.5,0,0,0,0);"]
["A","客户纸箱","多尺寸",0,0,0,0,"mrc000000000000000496","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)",{"$f":"CONCATENATE(\"values('\",H12,\"','mhbs615586058663510016','10','00','\",B12,\"','\",C12,\"','\",A12,\"',\",D12,\",\",E12,\",\",F12,\",0,0);\")","v":"values('mrc000000000000000496','mhbs615586058663510016','10','00','客户纸箱','多尺寸','A',0,0,0,0,0);"}]
["QPM","气泡膜","30cm*60m",0,44.2,0,0,"mrc000000000000000497",{"$f":"CONCATENATE(\"insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)\")","v":"insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)"},{"$f":"CONCATENATE(\"values('\",H13,\"','mhbs615586058663510016','10','00','\",B13,\"','\",C13,\"','\",A13,\"',\",D13,\",\",E13,\",\",F13,\",0,0);\")","v":"values('mrc000000000000000497','mhbs615586058663510016','10','00','气泡膜','30cm*60m','QPM',0,44.2,0,0,0);"}]
["JD","胶纸","5cm",0,9.7,0,0,"mrc000000000000000498","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)","values('mrc000000000000000498','mhbs615586058663510016','10','00','胶纸','5cm','JD',0,9.7,0,0,0);"]
["QZD11","气柱袋","11柱",0,1.1,0,0,"mrc000000000000000499","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)","values('mrc000000000000000499','mhbs615586058663510016','10','00','气柱袋','11柱','QZD11',0,1.1,0,0,0);"]
["QPD1","气泡袋","20*30",0,0.4,0,0,"mrc000000000000000500","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)","values('mrc000000000000000500','mhbs615586058663510016','10','00','气泡袋','20*30','QPD1',0,0.4,0,0,0);"]
["QPD2","气泡袋","20*40",0,0.5,0,0,"mrc000000000000000501","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)","values('mrc000000000000000501','mhbs615586058663510016','10','00','气泡袋','20*40','QPD2',0,0.5,0,0,0);"]
["QPD3","气泡袋","25*40",0,0.7,0,0,"mrc000000000000000502","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)","values('mrc000000000000000502','mhbs615586058663510016','10','00','气泡袋','25*40','QPD3',0,0.7,0,0,0);"]
["TCQP","填充气泡","10*20",0,374,0,0,"mrc000000000000000503","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)","values('mrc000000000000000503','mhbs615586058663510016','10','00','填充气泡','10*20','TCQP',0,374,0,0,0);"]
["QGZ","气管柱",0,0,374,0,0,"mrc000000000000000504","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)","values('mrc000000000000000504','mhbs615586058663510016','10','00','气管柱','0','QGZ',0,374,0,0,0);"]
["CRM","缠绕膜",0,0,59.5,0,0,"mrc000000000000000505","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)","values('mrc000000000000000505','mhbs615586058663510016','10','00','缠绕膜','0','CRM',0,59.5,0,0,0);"]
["MB","木卡板",0,0,0,150,0,"mrc000000000000000506","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)","values('mrc000000000000000506','mhbs615586058663510016','10','00','木卡板','0','MB',0,0,150,0,0);"]
["JB","胶卡板",0,0,0,200,0,"mrc000000000000000507","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)","values('mrc000000000000000507','mhbs615586058663510016','10','00','胶卡板','0','JB',0,0,200,0,0);"]
["生成sql时注意第1,2,3个字段"]