{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Hoja1"],"not_rendered":{"charts":1,"images":1,"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":"Hoja1","index":0,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,2,11]]}
[]
[null,"Ejemplo: Se tiene una base de datos de los principales tipos de cambio Yen-dólar. Y se quiere extraer el valor del tipo de cambio libre de la simbologia inicial de la base de datos. Para esto emmplearemos una macro que nos permita extraer los números."]
[]
[]
[null,"Mes/ Año","TC Yen japonés ","TC Yen japonés "]
[null,"Feb 2008","107.1 Y/US$",{"$f":"Extraer_num(C6)","v":107.1}]
[null,"Mar 2008","100.7Y/US$",{"$f":"Extraer_num(C7)","v":100}]
[null,"Ab 2008","102.7Y/US$",102]
[null,"May 2008","104.3Y/US$",104]
[null,"Jun 2008","106.8Y/US$",106]
[null,"Jul 2008","106.88Y/US$",106.8]
[null,"Ago 2008","109.42Y/US$",109.4]
[null,"Set 2008","106.6Y/US$",106]
[null,"Oct 2008","100.2Y/US$",100]
[null,"Nov 2008","96.84Y/US$",96.8]
[null,"Dic 2008","91.3Y/US$",91]
[null,"Feb 2009","92.1Y/US$",92]
[null,"Mar 2009","92.76Y/US$",92.7]
[null,"Ab 2009","97.73Y/US$",97.7]
[null,"May 2009","98.91Y/US$",98.9]
[null,"Jun 2009","96.55Y/US$",96.5]
[null,"Jul 2009","96.6Y/US$",96]
[null,"Ago 2009","94.4Y/US$",94]
[null,"Set 2009","94.90Y/US$",94.9]
[null,"Oct 2009","91.47Y/US$",91.4]
[null,"Nov 2009","90.25Y/US$",90.2]
[null,"Dic 2009","89.13Y/US$",89.1]
[null,"Feb 2010","90.02Y/US$",90]