{"id":5031,"date":"2018-03-11T15:53:21","date_gmt":"2018-03-11T15:53:21","guid":{"rendered":"http:\/\/www.ticeman.fr\/lecoutelas\/?p=5031"},"modified":"2018-07-20T09:27:37","modified_gmt":"2018-07-20T09:27:37","slug":"sheetsu-utilisez-vos-feuilles-de-calcul-google-comme-base-de-donnees","status":"publish","type":"post","link":"https:\/\/www.ticeman.fr\/lecoutelas\/?p=5031","title":{"rendered":"Sheetsu: utilisez vos feuilles de calcul Google comme base de donn\u00e9es"},"content":{"rendered":"<p>Une solution qui int\u00e9ressera surtout les bidouilleurs mais qui peut rendre service. Le principe est simple. Vos feuilles de calcul contenant des donn\u00e9es peuvent \u00eatre utilis\u00e9es comme ressources pour vos productions web. A l&#8217;accueil vous retrouvez les bases de donn\u00e9es d\u00e9j\u00e0 li\u00e9es au service et il est possible d&#8217;en associer d&#8217;autres. Les feuilles de calcul peuvent \u00eatre utilis\u00e9es pour des productions tr\u00e8s simples mais aussi des productions plus complexes. le service offre de nombreux exemples de ce qu&#8217;il est possible de faire.<\/p>\n<p><a  href=\"http:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-vos-tables.png\" data-rel=\"lightbox-gallery-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-5032\" src=\"http:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-vos-tables-300x152.png\" alt=\"\" width=\"300\" height=\"152\" srcset=\"https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-vos-tables-300x152.png 300w, https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-vos-tables-768x389.png 768w, https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-vos-tables-1024x519.png 1024w, https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-vos-tables.png 1365w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><!--more--><\/p>\n<p>Il suffit de choisir ce que l&#8217;on veut cr\u00e9er et Sheetsu le produit ou vous donne les instructions n\u00e9cessaires pour le faire. l&#8217;exemple le plus simple est le tableau. Vous souhaitez afficher en ligne des r\u00e9sultats qui se mettront \u00e0 jour automatiquement au fur et \u00e0 mesure que des utilisateurs rempliront un formulaire par exemple. Il suffit de lier votre feuille au service qui vous affiche les donn\u00e9es imm\u00e9diatement.<\/p>\n<p><a  href=\"http:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-tableau.png\" data-rel=\"lightbox-gallery-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-5033\" src=\"http:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-tableau-300x152.png\" alt=\"\" width=\"300\" height=\"152\" srcset=\"https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-tableau-300x152.png 300w, https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-tableau-768x389.png 768w, https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-tableau-1024x519.png 1024w, https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-tableau.png 1365w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Si le r\u00e9sultat vous semble correct il suffit de demander la page qui correspond et vous disposez d&#8217;une page affichant votre tableau de donn\u00e9es qui se mettra \u00e0 jour automatiquement sur votre feuille de calcul change.<\/p>\n<p><a  href=\"http:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-resultat-tableau.png\" data-rel=\"lightbox-gallery-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-5034\" src=\"http:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-resultat-tableau-300x153.png\" alt=\"\" width=\"300\" height=\"153\" srcset=\"https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-resultat-tableau-300x153.png 300w, https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-resultat-tableau-768x391.png 768w, https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-resultat-tableau-1024x521.png 1024w, https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-resultat-tableau.png 1365w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Il est possible avec un peu de ma\u00eetrise d&#8217;aller beaucoup plus loin et par exemple d&#8217;afficher des images mais dans ce cas, ce sera \u00e0 vous de construire votre page avec les indications fournies par le service. Pour chaque \u00e9l\u00e9ment des exemples de code sont donn\u00e9es et expliqu\u00e9s.<\/p>\n<p><a  href=\"http:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-base-image.png\" data-rel=\"lightbox-gallery-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-5035\" src=\"http:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-base-image-300x152.png\" alt=\"\" width=\"300\" height=\"152\" srcset=\"https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-base-image-300x152.png 300w, https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-base-image-768x389.png 768w, https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-base-image-1024x519.png 1024w, https:\/\/www.ticeman.fr\/lecoutelas\/wp-content\/uploads\/2018\/03\/sheetsu-base-image.png 1365w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Le service est gratuit et sans publicit\u00e9 et demande tout autant une certaine ma\u00eetrise de construction web qu&#8217;une bonne ma\u00eetrise de vos feuilles de calcul. De plus la version gratuite est limit\u00e9 en nombre de requ\u00eates vers vos feuilles et servira uniquement pour une utilisation ponctuelle.<\/p>\n<p>Lien: <a href=\"https:\/\/sheetsu.com\/\" target=\"_blank\" rel=\"noopener\">Sheetsu<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Une solution qui int\u00e9ressera surtout les bidouilleurs mais qui peut rendre service. Le principe est simple. Vos feuilles de calcul contenant des donn\u00e9es&hellip;<a href=\"https:\/\/www.ticeman.fr\/lecoutelas\/?p=5031\" class=\"more-link\"><span class=\"more-button\">Continuez la lecture<span class=\"screen-reader-text\">Sheetsu: utilisez vos feuilles de calcul Google comme base de donn\u00e9es<\/span><\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":5032,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,87],"tags":[],"class_list":["post-5031","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bases-de-donnees","category-creer-des-sites-web-et-presentations-interactives"],"_links":{"self":[{"href":"https:\/\/www.ticeman.fr\/lecoutelas\/index.php?rest_route=\/wp\/v2\/posts\/5031"}],"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=5031"}],"version-history":[{"count":2,"href":"https:\/\/www.ticeman.fr\/lecoutelas\/index.php?rest_route=\/wp\/v2\/posts\/5031\/revisions"}],"predecessor-version":[{"id":5037,"href":"https:\/\/www.ticeman.fr\/lecoutelas\/index.php?rest_route=\/wp\/v2\/posts\/5031\/revisions\/5037"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ticeman.fr\/lecoutelas\/index.php?rest_route=\/wp\/v2\/media\/5032"}],"wp:attachment":[{"href":"https:\/\/www.ticeman.fr\/lecoutelas\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5031"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ticeman.fr\/lecoutelas\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5031"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ticeman.fr\/lecoutelas\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5031"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}