{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Noticiero Contable","Consulta","Masivo"],"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":"Noticiero Contable","index":0,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Producto:","Consulta Comprobante de Pago"]
[null,"Versión:","1.0"]
[null,"Descripción:","Macros para realizar consulta de comprobante de pago en una hoja de excel."]
[null,"Autores:","Daniel & Miguel"]
[]
[null,"Empresa:","Noticiero Contable"]
[null,"Web:","noticierocontable.com"]
[null,"Facebook:","Facebook.com/NoticieroContable"]
[null,"Grupo:","groups/noticierocontable"]
[]
[]
[null,"Espero que te sirva mucho esta herramienta  :)"]
[]
[null,"Saludos,"]
[]
[null,"Miguel Torres"]

{"sheet":"Consulta","index":1,"n_rows":41,"n_cols":31,"rows_kept":41,"cut":false,"hidden":false,"merged":[[8,6,8,8],[12,6,12,8],[14,6,14,8],[16,6,16,8],[18,6,18,8],[10,6,10,13]]}
[]
[]
[null,null,"CONSULTA  DE  COMPROBANTES  DE  PAGO"]
[]
[]
[]
[null,null,"INGRESE  DATOS  DEL  COMPROBANTE  DE  PAGO",null,null,null,null,null,null,null,null,null,null,null,null,null,"INFORMACION  DEL  DOCUMENTO",null,null,null,null,null,null,null,null,null,null,null,null,null,"-- Seleccione --"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CIAN Y MAGENTA SOCIEDAD ANONIMA CERRADA ",null,null,null,null,null,null,null,null,null,null,null,null,null,"00 - OTROS"]
[null,null,"N° RUC",null,null,null,20451835999,null,null,null,null,null,null,null,null,null,"R.U.C.   20451835999 ",null,null,null,null,null,null,null,null,null,null,null,null,null,"01 - FACTURA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FACTURA ",null,null,null,null,null,null,null,null,null,null,null,null,null,"02 - RECIBO POR HONORARIOS"]
[null,null,"TIPO COMPROBANTE",null,null,null,"01 - FACTURA",null,null,null,null,null,null,null,null,null,"0001 - 3633",null,null,null,null,null,null,null,null,null,null,null,null,null,"03 - BOLETA DE VENTA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Está Autorizado",null,null,null,null,null,null,null,null,null,null,null,null,null,"04 - LIQUIDACION DE COMPRA"]
[null,null,"N° DE SERIE",null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"06 - CARTA DE PORTE AEREO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INFORMACION  DE  LA  IMPRENTA",null,null,null,null,null,null,null,null,null,null,null,null,null,"07 - NOTA DE CREDITO"]
[null,null,"N° DEL COMPROBANTE",null,null,null,3633,null,null,null,null,null,null,null,null,null,"20451835999 - CIAN Y MAGENTA SOCIEDAD ANONIMA CERRADA ",null,null,null,null,null,null,null,null,null,null,null,null,null,"08 - NOTA DE DEBITO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aut. SUNAT - 11890203023",null,null,null,null,null,null,null,null,null,null,null,null,null,"09 - GUIA DE REMISION - REMITENTE"]
[null,null,"FECHA DE EMISION",null,null,null,"2016-04-18",null,null,null,null,null,null,null,null,null,"Es valida",null,null,null,null,null,null,null,null,null,null,null,null,null,"16 - BOLETO DE VIAJE-TRANSPORTE INTERPROVINCIA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20 - COMPROBANTE DE RETENCION"]
[null,null,"N° AUTORIZACION",null,null,null,11890203023,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"23 - POLIZA DE ADJUDICACION POR REMATE DE BIEN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25 - DOCUMENTO DE ATRIBUCION"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"33 - MANIFIESTO DE PASAJEROS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"37 - DOC. EMIT. CONCE. SERV. REV. TEC. VEHICUL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40 - COMPROBANTE DE PERCEPCION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"41 - COMPROBANTE DE PERCEPCION VENTA INTERNA"]
[null,null,null,null,null,null,null,null,null,null,null,"http://www.noticierocontable.com/",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"44 - BILLETES DE LOTERÍA, RIFAS Y APUESTAS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"45 - DOCS. CENT. EDUCAT. CULTUR. ACT. NO GRAVA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"46 - FORMULARIO DECLARACIÓN - PAGO TRIB. INTER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"48 - COMPROBANTE DE OPERACIONES - LEY N° 29972"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"49 - CONSTANCIA DE IVAP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"55 - BVME PARA TRANSPORTE FERROVIARIO DE PASAJEROS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"56 - SEAE COMPROBANTES DE PAGO PARA SERV.AEROP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60 - GRE REMITENTE - BIENES FISCALIZABLES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"61 - GRE REMITENTE COMPLEMENTARIA - BIENES FISCALI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"62 - GRE TRANSPORTISTA - BIENES FISCALIZABLES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"63 - GRE TRANSPORTISTA COMPLEMENTARIA - BIEN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"87 - NOTA DE CREDITO ESPECIAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"88 - NOTA DE DEBITO ESPECIAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"89 - NOTA DE AJUSTE DE OPERACIONES - LEY N° 29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"96 - EXCESO DE CREDITO FISCAL POR RETIRO DE BIEN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"99 - OTROS-CONSOLIDADO DE BOLETAS DE VENTA"]

{"sheet":"Masivo","index":2,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"CONSULTA  MASIVA  DE  COMPROBANTES  DE  PAGO"]
[]
[]
[]
[null,null,"N° RUC","TIPO COMPROBANTE","N° SERIE","N° DE COMPROBANTE","FECHA DE EMISION","N° DE AUTORIZACION","AUTORIZADO","VALIDO",null,null,"-- Seleccione --"]
[null,null,null,null,null,null,null,null,null,null,null,null,"00 - OTROS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"01 - FACTURA"]
[null,null,20537033305,"01 - FACTURA",1,4862,"2016-04-19",11781282023,"Está Autorizado","Es valida",null,null,"02 - RECIBO POR HONORARIOS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"03 - BOLETA DE VENTA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"04 - LIQUIDACION DE COMPRA"]