Картинку в ГУГЛ Таблицы

serg1208

Client
Регистрация
17.04.2018
Сообщения
331
Благодарностей
15
Баллы
18
Подскажите плиз, как без API можно вставить картинку в Гугл Таблицу.

Ранее делал это, вставляю ссылку на картинку, но сейчас гугл все мелкие картинки отдает в base64.

Спасибо
 

djaga

Administrator
Команда форума
Регистрация
26.04.2020
Сообщения
545
Благодарностей
1 124
Баллы
93
Подскажите плиз, как без API можно вставить картинку в Гугл Таблицу.

Ранее делал это, вставляю ссылку на картинку, но сейчас гугл все мелкие картинки отдает в base64.

Спасибо
Вот ту пример от мистера @doc
Ссылка на сообщение

Продублирую сюда:
Декодирование из base64 в картинку:
string base64str = "/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAkGBxMTEhUTEhIVFRUVFxUXFxUXFxUVFxUXFxUXFxcXFxcYHSggGBolHRcVITEhJSkrLi4uFx8zODMtNygtLisBCgoKDg0OGhAQGi0dHR0tLS0tLS0tLS0tLS0tLS0tLS0tLS4tLS0tLS0tLS0tLS0tLS4tLS0tLS0tLS0tLS0tLf/AABEIAOEA4QMBIgACEQEDEQH/xAAcAAACAgMBAQAAAAAAAAAAAAAEBQMGAAECBwj/xABIEAABAwIDBAYFBwoEBwEAAAABAAIDBBEFITESQVFxBhNhgaHBIjKRsdEHM1JicpLwFBUjQ4KissLh8UJEU9IkNEVUc6PDFv/EABkBAAMBAQEAAAAAAAAAAAAAAAECAwAEBf/EACoRAQEAAgIBAwQBAwUAAAAAAAABAhEDITEEEkETIlFhMnGRsUKBkqHw/9oADAMBAAIRAxEAPwBGxM6PDJXgOazLibC/tXeBYbt2e4A3Oy1p0Nhdzj2Ae0q5QQODQA8ZcGgNA4KFXyy0qLsLlbqw91iodkjUW5q6vgfxB7iEDUwg5Pb+Oe5BpkrjXLtr0wkwwHNpt2HMIKaie3dccRmlsPLE1JNsvaeBCu9G64XnYerp0aqNuK/A2KlnPlbjp21D4jUljCRrnb2Xuty1AbYu0JslOK1gdYg+j6uhvcnPuyGaXjw3f0Gd668imVjeraXOAJFsyMyMj4pdU4jEDbauewF3uSmumaQWt9LTUXOW5t8wFFQRAuu+4Fzk3IAjfyyKe8U7qk90Max7bapUJGk6hMKqgiOd9q2md7JPLShpu0kc8x7FOTE8tP6NgtmQAoK6sa0ZZnQbgT9o5KLBKFzgbvyPZnbPIcOalraWKIW2dp3bmeZKMmO/yW5WfoikxL0rFuefqkEJZWyGQA7Njzv3O4KfE5bk2YBYHS2felzCWjPXs+K6MJJ3C/y/oI6+4IdlbefigzKDe242UcxF9dcvBAPk2DlftT+yBLfAmYo7o9Fm93JvmfJLC66f4QAIm23k353t8EL1AyGFCSytbJG55s0Pu42JtZrradtkUSoZW31CWXVSs27qcXonm79lxGVzE8m3e1dM6QUrQA11gNAI3gDkNlBmnbwC5NOOAVfrVP6MFnHaTj/63/7VC3F6JpJAAJ1Iidn+6ofyccFrqBwRnKP0oK/P1J+InfBYhepbwW1vqfpvpxd+jEIsz6sTcu2QlxN/2R7VY3O4WCTdH2WDstNhv3WD4pq5ylUcvLmQX1KgMYUpK5CU0CvpAezlkoJKdw0IPPLxCYuKhkIQ2aE1TC0+uy3b/UJv0chDGOAN7uv4AeSicp8Ms1xAFrpc+4tx3trFagk7ANgNeaAlbtDZ7DfPj/ZFUbOslII1dr2ZlOG4VGBpfTsvbflxR98wml77bVVp8OcTshl9CSNE2jwbIFxPIfFOurAyAstSDJQy5rTXvpW6rDGDOxvzKTVsVirLXOVcr5c0stvlTHHXg5wBl26qepoIxf0QTxddx8Vx0a9RG1hyQ3dls7VTFIRmLCyROphnb2f3VkxPeq7I6xVsMro2gLqE67IHM/DRL8SpdkXH4FlYi64SyrGoO9Wxzu08seiOI5clZMG+ZHN3vVfMVhberNSQhjGt4AX570+dRqYlcErblwVMrklcrZK5JWZtaWErSLNrFxcLSO2ehYS70Obnn94jyRpKEwsWjaDra/K+fmiytXIie5R9cTopTFfVY+VrQgfTkE2zUL5Qh6iqLtMgobdqVSQT1q7pZfTCCc5d07jtt5j3rXwM8rLR0dpC/KxHsP8AZHOC4pzku3OXLbt0Sa8ONlQ1DhZblmsl9TOto8A129VnENU/qnpBW3J0T4xWU+6NvtGpqyZDYO4Bi7qs0nyxTWuukFYFZJ4Eoq6UquIUsZKh6l113OwtOiGkerSFriji25mN4uHx8lanUrBq8k8APLNVXDfn4+fkVaZXHc63YBZNXNn5CzbGgbLf7Jt7kMHX0Us0juJSeqqC1wJOW1nysjMdlNTA/wCiVwYnfRKyOvc4ANtpe5udb7hyWjUv0Jae4jzKGmcHtWbJ4H2KZtS76LfafgtmrIIuLd4K2m2g2TwPisRn5QOI9q2iG11hlyXZmSOGuyGaLjqFrEdDXyod+a0HrHOSU8jWysLVw56ifMsZK4gLlkmYAzNxprqpMMoHzmzcmjVx0HLiexWuiw2OIWY253uOp+CTLLRpGQusMwoZ5yiZGFDviUF4CklKGejJGIV6xoEljQj6ZMHOXCJpQkQsse9FCNbMCzbLnPUbmgpm6mCHkpgjttlNRSNOqQ1+DOzMZv2HyKtUsKDlYqY5BVOw5jm1DAQQQTryKfzzHiu5o+IzHggp7q29o5T5RTVRHrC6Q4u87JNiMxrzTdz0txb1DzG/tCpj5TprhMl2XyzA9391PHHvKDwqPZaBusPj5o0uS3yLq4WpQuSbLTHXQBvr+xYudhaWbTMPxO7QCRfhv7uxN6WuHG48Uubg4aLNFvPmUBUYZK3NryE9kpV2p5791kQ5ypmE4u5jwyYWvltDTv4K3NfdTymmbcjcKwwzOto0eseHZzQDCXODRbPecgBqSTuAFyeSjxTHmdW1nXup6Q+q6MXq646Ewt1jiO55zdusM0NW+GWTFOldHRkQAmWUZCngb1sl+0DIHmbpa/GsYqP+XoYqZm51S8ueRx2G+qewgpVhhrWx2w+ggw+A/rqlwEjh9J1878weaX11Kx5P5b0h2jvZC6w5WaSD91Gccn/t/wCB2b1eE4sc5sVhh7GRtAHedkpZJhFUP+vMvzaP/olP5s6Pt9eqnkPHZkz+7GFr8m6PHSWccxP/ALU+r+/+MHZn+bcUGcWKRTdh2T5OUM2I4xD85BFM0almv7pH8KXydG8Gk+brtk7g5zP52hLcUw38kF4cT5Ma59yOTHEe0LTGXr/MHejkfKC0HZnp5IncNe+zg0+Cb0HS6kfn1zW23Puw/varzabpLUPaWSubKPrsY4jvsPFL6SmMhs2wPDemvp8Nd9NOXLxHrVR05oo/1hefqNcfE2CWSfKZGfRgpZJHbgXAeDA4qj/myaFvWFjC3i7Z88/YU4o+nTomWjpYmv8Ap3Nvu6+KX6GP+mb/ANxud+eljGN4vP8ANUccQO997+Lh/CtPwnFnC8lZFEPqtGXfsj3oOnkxisAc2RsMbvolrMjvGzd3iph8m7n+lVVj3n22/aeSl+3H8T+k23dA1NA9vzuMtB4BwH86DdAwaYuSftXHvTKfAcJhyknDncOtLj91iBmmwcZBjnfsS+apO/G/7Rv7IWmYfN4jE/sfsjzuunV9Qz52EPb9OI3/AHTqhZ5sMOkUg5Bw/mQZjowbwzzRHk63fl5o+3fmf9Nv9mzKpkg2o3AgajeOY3ILEHE7LbW2nNHbmQgZmyX22vZK4frIyBJ+0z/EOxSQV3XFlxZ4cLjlvHsR9ui2rPE30R+O1butxOyXMrrblJnL810w2UJesaVmEbSxcbS2sy1uYEPLGFLNIg5JEmwkL8Qow4HJS4DWmxicc26X3t/otzPSuVjusYWNLn7QDWjVxJtsjndNO+h0LxzEDtGEOa1tgZnvzbsnMR7Izfe1yzeBY+iXJpgWF10pMlHD1Jf61dVWdUSD6lwRG3g1jbaekrV0R6BxxHr6oCWocdqxzZGewaOcMszpbLibstlyzGaxI85Z8l4kO3W1k9Q7XWw7i8uI7rJjB8nGHM/UF32pJD52VyeVBI5Qy5c78nxitO6E4f8A9pF3gn3lA1PQigP+WYOW0PcVa5CgahyX35flfHGKDiXyeUZvsB8Z7Hl3g66oPSDotJTHaH6SIbxu7HAac17PUvSetAIIKphz543vtsuKVSsAr6SSIx9Wxjrek0gWPaDvCquNRQxyfoH335f4T9VyYdK8HbEesjFmk5t3A9nYq04rt4sZ/KXyhyW/xplSB9VM1j5M3Gwc43t2AaBX3EOgtMylcS/Yc0bXWuO/geIPD2LzRp38O7fu7VZ8P/K8SfHBt7QYBfcxg3vf9J34Fs1uXG7ll1IGFmta3UHR7HKyIdRTEuLvVaGbbm8S2+QHMWVgj6FYjVelVTFoO6R5ee6Np2W9y9E6NdF4KNloxd59aR3rOPkOwJnKuTP1Pf2RbHi67eeU3ya07PnJJH9gsweGfiij0Po26Qg/aLne8q11DkumKT6ud81SccV2Xo9Sj/Lx/dCAqOj1N/otHLL3KwTlL5inmV/JvZFYq+i8J9Uuaew396S1WFzQvEgPWBu8etbeCD2K6TOQcpVceTL5Sy4o4gnD2h7TcOC6cULSs2HnZ9V+ZG4O4jhca9o7UU5vBapWaROCxpXXNZsrA6y4rFwsW0Kz1DkvlkU88iXzPSaGMfIrl8nmEAk1Txe12xX3HRz+f+EftKjNBcQ0ZkkAcybBez4VSiKJkY0Y0DnxPeblLndQbDNrlhKhDlvaUdk9rb3KKRy6c5QvKU+MQylAVKOkKBqSstiVVJSSuem1Y5Ia1yMVIMcj22ObxHjuXnMgt3L0etcqFjEWzI7tz9q7vT34c3qMflFFmvYvknw/q6Z0xGcziR9lvojxBPevG6cEkAakgDmcgvoTAYBFDHGNGMa32CyHrMtY6/JeDHd2dl6HlK2XoeaRedHVYGnS+ZyMlcl07lSG0Dncl05RszkvmcqwAkxQcpRExQcjlSEqNzkUDcXQEjlNRv1HBOjnE5b2rV10exRuJWTdbSxQ7RWIgczPQj3LuRyHc5IpDjohBt1cd9G3ef2Rl47K9YjcvNfk9b+mkdwZb7zh8F6E16hyXswzbWttD7a621Nvalc5ROeuXSKF8ixpHUrkvqXqeWVLauRE+MLq2RJKt6PrpUjqpE8isgCscqh0iZ6TTzH48VaKlyruPC7b8CF08PWSXNN40P0Wg26qEHQO2j+yNryXulE/ILxjoI3/AIm/Bp8SP6r1+ifkpesv3F9PPtNnPQ0jlvaQ8j1yyLo5iltQ5FTyJdM9UgB5npfM5EzPQEzlSFoeZyCmKIlcgpXKsJUbyuqJ9ni+huFC4rmN1nDmFTSeR0W8CiKTD5JPVGX0jp/VACGV3zcbjy09uisOD1MjWNY6MteMrZEc7jILY4ubPLXhH+YPr/u/1Wk661/Ae1Yn9sS92SqSFQOKleULM9Qdi5fJ6cpj2sHvPmroJFRPk+l9Cb7TfcrgyRQznamI8SLoSoLrFnWpB0JklQ8kyhkmQskyOjSJZZ0BVSrUkqAqJkdHkC1j0nqXI6pkSuZ6eQ4OcpFjB9Ap1O5V/F3+iVfj8pct+2iOg77THkPevV6F+QXj3RN9pgvWqCTJT9VPuD0/8DYOyUEz1pz0PJIuaRZFO5ATPU80nal88ipICGZyBlKlleg5XqkhKimcg5CppnIV5VYSo3FajPpDmPetOK3Ti72j6zfeniWXh6eypZfZ0PAhSPaPaq5VYjFF6UZe57vpbbtnu0S2XHJtRtuPcB7E23J7NrllwHgsVJ//AEtT/peI+Cxb3B7K6kKW1kqKqZbBKwC91hopYx02rh8nchHWg79g+8fBXZkip3RODYce1tvEFWbrFHk7q2HgcJFoyoPrVwZlPSieWVDSSKKSVDTTI6NI6llQc0q1LKg5pE2hR1D0unep5npfUyJ8Y1oSplSHFH5JnUyJJiD8wF0cc7c/Ll0nwB9pQvTsMqcgvJqSTZeHL0PCKu4GaT1GPyPpsutLWJlBJKg2VC4kmXJI6m55UBNItyyoSR6pIS1zK5CyvXcj0NI9UkJUcj0O5y6keoHFUkTrHOROFNvKzsN/YCUESmGCfOX4A+KN8J5VY3C64dGF20rEiSPYCxd2WLArFTKXO2W6lPcFwvTJQ4FhJOZGZ1PkrrQ0YaFsr8Q22qKm2c+Clkcj2RpVM6xI4EqNW4ax0iidMo5HIWRyGlxD5kNJMhpJUNJUJtDsVJMhJZUNJUoOar7U0xDaeeZLaidRT1SCleSqTElyEUUPXTMivbbda/DIk+AKa4t0CftXgkBB1EhsQewtFiO5I8IquqqIpD/heL8j6LvAlesuKNyuN6c2d2oGGdA37YNQ9mwNWsLiXdm1YWCDiqmslcIgeqvZoJJNhle5zN9e9XXpJV9XTyOBzI2Rzdl7iT3Kh0UNyt7rlN0eOd9LFBXXGqmNQhYaYEaLJKVw0zHio9Ov3VLJKhnyKFzzvyUTpE0gWupHod71p71C5yeQlrTnKNxW3FRpiVtHUDtkg7ibd6BCdspf0Qbv179QtU8jKnfcfj2qe6VUU9+ehHbvCZNcksTdLFq62gyzUFEGgZJrHGpY4VKGJKS5Iw1JcUZZ57c0/sleOxeiHcDY8ihpThy1kSuKGlUrioZCs7gUwQEzSmUoQsrUZQKZYid6FfS9qbyBDvCfYWFpgshpWplKEvnTylsLpgvW6aXaYx30mtPtaCvJ5QvUsPP6KL/xs/hC2fhz59EXTeX0I2cXF33Rb+ZKcPiR3TB15IuT/e1R0TcglvWKvFDGFqmIXEYXZKjXRoNOwICWAI+ZyDlKaFoCSKyGkajJShJFSEqBy4K7cuFROiKCDbeB3nkFYXX/ALfBAYBBkXnfkPPyTRwSZVLKlVS3YdtjR2R57imNLLdRzxAgg6FBUEha4sdqNDx4Hy70fMKcrFF1w4H2LEumem7QXYcEFtFb2jZHTnGXCHrIw9jm7yDbnu8VHtLm5Q9o43SsOCheEbisey88HZjz/HagS5Tsenhl7psPIhpEU9QSIHCPQ70VIULIUwUHUJdMjqgoCVUxLkEm3r06H0WNbwaB7AF5zSRbcrG8XNvyvn4XV8fUBHJzchH0ndeWP7J/iUlIMkL0gkvKz7J96Lo9Aky8LcXgcwrTnLFE8qel0cpQsrlPIULKnhaGlKGep3od6eJ1E5aawkgDU5LHFMMFp7u2zo3Tn+PenTyp1TxBrQ0bh/cqQrkLoJEXDmpViUdrPGrde0b03sopo796MYs/OB+msWvzQzh4rSPQPS2zyDR4PNo8rLv8ql37B7nDzQoetulR0iKbXP3sHc74tXX5wO+J3tafggjMuXS80NC7xSYSMtsuDhmPRHeMikBKebaUVjLPPA5hJli6eDL4CvKicVM5QPU9OtBIhJSipCg5imYDUFAylFTuQMjlSROpcL+eZzP8JVke7tVZwqS0oda9r5Xtutqnbq8b43e1pTVDLyExN13t+z5lMqI5JNVTB0lwDawGeqbUJySZr8ZkCo3roLh6lpUPIhZUTIhJSmhagkQz3KZ7kPIVSRO9OGsJIA1KslNEGNDRu8TvSrDI7env3eaaxvWqGVThSBRNKlCxdtrlwXS1tiy2i7RbCxSrFh2sTFytrE6THLTVixaC6KX4nqOXmtrEuXhXh/kCKgcsWKNd0DSIGdYsTQKWToKRYsVInUuF/OdxTOZYsTVG+QI9dO6NYsU818PA4aLl6xYpKhpNEHItLE8JQ7kJItrFSEyNKP1W8kwjWLFnPRIXYWLECtrorSxEEaxYsRZ//9k=";

File.WriteAllBytes(@"E:\img.jpeg", Convert.FromBase64String(base64str));
Кодировать в base64:
string file = project.Variables["pathToPicture"].Value;
return Convert.ToBase64String(System.IO.File.ReadAllBytes(file));
 
  • Спасибо
Реакции: serg1208

serg1208

Client
Регистрация
17.04.2018
Сообщения
331
Благодарностей
15
Баллы
18
Благодарю!)
 
Последнее редактирование:

Кто просматривает тему: (Всего: 1, Пользователи: 0, Гости: 1)