{"id":5073,"date":"2018-03-16T15:43:10","date_gmt":"2018-03-16T15:43:10","guid":{"rendered":"http:\/\/www.ticeman.fr\/lecoutelas\/?p=5073"},"modified":"2018-07-20T09:22:43","modified_gmt":"2018-07-20T09:22:43","slug":"sheetgo-lier-les-donnees-de-toutes-vos-feuilles-de-calcul","status":"publish","type":"post","link":"https:\/\/www.ticeman.fr\/lecoutelas\/?p=5073","title":{"rendered":"Sheetgo: lier les donn\u00e9es de toutes vos feuilles de calcul"},"content":{"rendered":"<p>Un service qui int\u00e9ressera particuli\u00e8rement ceux qui manipulent de grandes quantit\u00e9s de donn\u00e9es dans des feuilles de calcul Google ou office365. Il permet simplement de lier en permanence les donn\u00e9es de plusieurs feuilles de calcul pour construire une nouvelle.<\/p>\n<p>Il suffit de s\u00e9lectionner les feuilles sources et la feuille de destination.<\/p>\n<p><a  href=\"http:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetgo-source-destination.png\" data-rel=\"lightbox-gallery-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-5074\" src=\"http:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetgo-source-destination-300x146.png\" alt=\"\" width=\"300\" height=\"146\" srcset=\"https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetgo-source-destination-300x146.png 300w, https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetgo-source-destination-768x374.png 768w, https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetgo-source-destination-1024x498.png 1024w, https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetgo-source-destination.png 1365w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><!--more--><\/p>\n<p>Vos feuilles sources restent intactes et toute manipulation nouvelle sur chacune d&#8217;entre-elle se retrouvera sur la feuille de destination. il est possible de param\u00e9trer le temps de synchronisation des donn\u00e9es et leur heure.<\/p>\n<p>Pour les plus aventureux, il est aussi possible de param\u00e9trer les donn\u00e9es elle-m\u00eames et ne s\u00e9lectionner que celles qui conviendront \u00e0 vos crit\u00e8res de fa\u00e7on \u00e0 construire instantan\u00e9ment de nouvelles donn\u00e9es.<\/p>\n<p><a  href=\"http:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetgo-parametres.png\" data-rel=\"lightbox-gallery-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-5075\" src=\"http:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetgo-parametres-300x147.png\" alt=\"\" width=\"300\" height=\"147\" srcset=\"https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetgo-parametres-300x147.png 300w, https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetgo-parametres-768x376.png 768w, https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetgo-parametres-1024x501.png 1024w, https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetgo-parametres.png 1365w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Le service est gratuit et sans publicit\u00e9. il existe aussi en extension pour googledrive. Il faut bien entendu autoriser l&#8217;acc\u00e8s du service \u00e0 vos feuilles de calcul.<\/p>\n<p>Lien: <a href=\"https:\/\/www.sheetgo.com\/\" target=\"_blank\" rel=\"noopener\">Sheetgo<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Un service qui int\u00e9ressera particuli\u00e8rement ceux qui manipulent de grandes quantit\u00e9s de donn\u00e9es dans des feuilles de calcul Google ou office365. Il permet&hellip;<a href=\"https:\/\/www.ticeman.fr\/lecoutelas\/?p=5073\" class=\"more-link\"><span class=\"more-button\">Continuez la lecture<span class=\"screen-reader-text\">Sheetgo: lier les donn\u00e9es de toutes vos feuilles de calcul<\/span><\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":5074,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28,112],"tags":[],"class_list":["post-5073","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bureautique","category-utiliser-un-tableur"],"_links":{"self":[{"href":"https:\/\/www.ticeman.fr\/lecoutelas\/index.php?rest_route=\/wp\/v2\/posts\/5073"}],"collection":[{"href":"https:\/\/www.ticeman.fr\/lecoutelas\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ticeman.fr\/lecoutelas\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ticeman.fr\/lecoutelas\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ticeman.fr\/lecoutelas\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5073"}],"version-history":[{"count":1,"href":"https:\/\/www.ticeman.fr\/lecoutelas\/index.php?rest_route=\/wp\/v2\/posts\/5073\/revisions"}],"predecessor-version":[{"id":5076,"href":"https:\/\/www.ticeman.fr\/lecoutelas\/index.php?rest_route=\/wp\/v2\/posts\/5073\/revisions\/5076"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ticeman.fr\/lecoutelas\/index.php?rest_route=\/wp\/v2\/media\/5074"}],"wp:attachment":[{"href":"https:\/\/www.ticeman.fr\/lecoutelas\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5073"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ticeman.fr\/lecoutelas\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5073"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ticeman.fr\/lecoutelas\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5073"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}