{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Штрих-коды","QR-коды","Логотипы","Вып.список","Скриншоты сайтов","Диаграммы","Карта","Макрос"],"not_rendered":{"charts":0,"images":24,"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":"Штрих-коды","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Артикул","Наименование","Штрих-код"]
["86753R61","Дубленка на рыбьем меху",{"$f":"_xlfn.IMAGE(\"https://barcode.tec-it.com/barcode.ashx?data=\"&A2&\"&code=Code128\")","v":{"$error":"#VALUE!"}}]
["S947A699","Жилетка без рукавов",{"$f":"_xlfn.IMAGE(\"https://barcode.tec-it.com/barcode.ashx?data=\"&A3&\"&code=Code128\")","v":{"$error":"#VALUE!"}}]
["F43KG8UH","Кардиган",{"$error":"#VALUE!"}]
["20343IFD","Кордеган",{"$error":"#VALUE!"}]
["5HK3D061","Куртка лётная MAYDAY",{"$error":"#VALUE!"}]
["9IKI21KV","Брюки-шорты",{"$error":"#VALUE!"}]
["KCDJDRBM","Шуба из броненосца",{"$error":"#VALUE!"}]
["076W5R34","Лосины леопардовые XXXL",{"$error":"#VALUE!"}]

{"sheet":"QR-коды","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["https://planetaexcel.ru",{"$f":"_xlfn.IMAGE(\"https://api.qrserver.com/v1/create-qr-code/?data=\"&A2&\"&size=100x100\")","v":{"$error":"#VALUE!"}}]

{"sheet":"Логотипы","index":2,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Компания","Логотип"]
["Microsoft",{"$f":"_xlfn.IMAGE(\"https://logo.clearbit.com/\"&A2&\".com\")","v":{"$error":"#VALUE!"}}]
["Apple",{"$f":"_xlfn.IMAGE(\"https://logo.clearbit.com/\"&A3&\".com\")","v":{"$error":"#VALUE!"}}]
["Tesla",{"$error":"#VALUE!"}]
["Nestle",{"$error":"#VALUE!"}]
["Walmart",{"$error":"#VALUE!"}]
["Samsung",{"$error":"#VALUE!"}]
["Mastercard",{"$error":"#VALUE!"}]

{"sheet":"Вып.список","index":3,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Имя","Должность","Пол","Дата рождения","Ссылка на фото"]
["Елена Маркова","Торговый представитель","Ж","1987-02-22","https://www.planetaexcel.ru/upload/medialibrary/d49/jn5erucdlz0h6avkcmi3ueftri9s2re2/elena.png"]
["Ренат Абаев","Стажер","М","1970-05-05","https://www.planetaexcel.ru/upload/medialibrary/162/7q7dool09i8q9oqr0azqhd4ey3od1tfv/renat.png"]
["Юлия Коробец","Менеджер","Ж","1981-11-13","https://www.planetaexcel.ru/upload/medialibrary/dfb/p1zhdn5ex1qf97bn0khhg6qzjqi5vk42/julia.png"]
["Ольга Травкина","Менеджер","Ж","1976-12-03","https://www.planetaexcel.ru/upload/medialibrary/72a/6hlrp7imix2czr3hp05ptcbjaea2g5er/olga.png"]
["Андрей Барков","Генеральный директор","М","1973-05-18","https://www.planetaexcel.ru/upload/medialibrary/174/tkhelgoeojnp1lo469va5ydnzzmxqvy5/andrey.png"]
["Степан Огурцов","Торговый представитель","М","1981-09-15","https://www.planetaexcel.ru/upload/medialibrary/1c9/sjhys5qw66ik7c3ppiuxcsqbrohkja8o/stepan.png"]
["Максим Иванов","Торговый представитель","М","1978-08-13","https://www.planetaexcel.ru/upload/medialibrary/363/dagemzmd6940iafhdb69v36kplyn3jur/maxim.png"]
["Маргарита Пушкина","Координатор продаж","Ж","1976-03-25","https://www.planetaexcel.ru/upload/medialibrary/e9e/zsqe7yw8ykk7s3v4qshbpy4qyfopej6c/rita.png"]
["Анна Долина","Торговый представитель","Ж","1987-09-16","https://www.planetaexcel.ru/upload/medialibrary/d48/ukukecbuiif9bs8h5s96i1utor6l4vvu/anna.png"]
[]
[]
[]
[]
["Маргарита Пушкина"]
[null,{"$f":"_xlfn.IMAGE(_xlfn.XLOOKUP(A15,Таблица2[Имя],Таблица2[Ссылка на фото]))","v":{"$error":"#VALUE!"}}]

{"sheet":"Скриншоты сайтов","index":4,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["planetaexcel.ru",{"$f":"_xlfn.IMAGE(\"https://mini.s-shot.ru/?\"&A1)","v":{"$error":"#VALUE!"}}]
["microsoft.com",{"$f":"_xlfn.IMAGE(\"https://mini.s-shot.ru/?\"&A2)","v":{"$error":"#VALUE!"}}]
["apple.com",{"$error":"#VALUE!"}]

{"sheet":"Диаграммы","index":5,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,10],[8,1,8,8]]}
["Значение",30]
[]
["Ссылка",{"$f":"\"https://quickchart.io/chart?c={type:'radialGauge',data:{datasets:[{data:[\"&B1&\"],backgroundColor:'green'}]}}\"","v":"https://quickchart.io/chart?c={type:'radialGauge',data:{datasets:[{data:[30],backgroundColor:'green'}]}}"}]
[]
[null,null,{"$f":"_xlfn.IMAGE(B3)","v":{"$error":"#VALUE!"}}]
[]
["Значение",45]
[]
[null,{"$f":"\"https://quickchart.io/chart?c={ type: 'gauge', data: { datasets: [ { data: [10, 40, 60], value: \" &B7& \", backgroundColor: ['green', 'gold', 'lightcoral']}]}}\"","v":"https://quickchart.io/chart?c={ type: 'gauge', data: { datasets: [ { data: [10, 40, 60], value: 45, backgroundColor: ['green', 'gold', 'lightcoral']}]}}"}]
[]
[null,null,{"$f":"_xlfn.IMAGE(B9)","v":{"$error":"#VALUE!"}}]

{"sheet":"Карта","index":6,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[7,1,7,4]]}
[]
["Долгота",37.36,null,{"$f":"SUBSTITUTE(B2,\",\",\".\")","v":"37.36"}]
[]
["Широта",55.45,null,{"$f":"SUBSTITUTE(B4,\",\",\".\")","v":"55.45"}]
[]
["Масштаб",7,null,{"$f":"SUBSTITUTE(B6,\",\",\".\")","v":"7"}]
[]
[null,{"$f":"\"https://maps.geoapify.com/v1/staticmap?style=osm-bright-smooth&width=800&height=600&center=lonlat:\"&D2&\",\"&D4&\"&zoom=\"&D6&\"&apiKey=d548c5ed24604be6a9dd0d989631f783\"","v":"https://maps.geoapify.com/v1/staticmap?style=osm-bright-smooth&width=800&height=600&center=lonlat:37.36,55.45&zoom=7&apiKey=d548c5ed24604be6a9dd0d989631f783"}]
[]
[null,null,null,null,{"$f":"_xlfn.IMAGE(B8)","v":{"$error":"#VALUE!"}}]

{"sheet":"Макрос","index":7,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["D:\\Photo\\Books\\Готовые Решения.png"]
["D:\\Photo\\Books\\Мастер Формул.png"]
["D:\\Photo\\Books\\Скульптор Данных.png"]