Buscar este blog

14 de abril de 2019

Incrustar tabla html de una hoja de cálculo de google

*La desventaja es que solamente se puede publicar en gris y en formato de columna. 
La ventaja es que se actualiza si se hacen cambios. 
Se puede dar click derecho para ver el código de la página e incrustar el html en Google sites.
Gracias a: Ya no recuerdo el enlace, pero la info original no es mía. 

To do this, generally, you will need four things:


Set the permissions on the Google Sheet to “Anyone with the link can view”. You can double-check that you’ve done it properly by trying the link in an Incognito/Private Browsing window in your browser. If the permissions are set correctly, you’ll be able to view the spreadsheet without having to sign in.

The URL of your Google Sheet.
The ✨magic string✨* — /gviz/tq?tqx=out:html&tq&
The Sheet ID (i.e. gid) in the URL. You may have several different sheets in the “workbook”, and each has a different Sheet ID, so be sure that you’re looking at the correct sheet for your purposes.
Finding the Sheet ID

To walk through a specific example, here (again) is our sample Sheet with some data.
    Double check the permissions on the file. In this case, the file is a publicly-viewable example spreadsheet, so we’re good to go.
    Take the URL of the Google Sheet:https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit#gid=0
    Notice that the Sheet ID in this case is zero:
    gid=0

  1. Remove the trailing edit#gid=… from the URL:
    https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/
    Append the ✨magic string✨ (gviz/tq?tqx=out:html&tq&) to the URL:
    https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/gviz/tq?tqx=out:html&tq&
    Append the Sheet ID (gid=0) to the URL:
    https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/gviz/tq?tqx=out:html&tq&gid=0
    Done!

Qualcomm Atheros AR9287 en Ubuntu 20.04.2

Tenía el problema de desconexión constante usando esta tarjeta wifi en ubuntu 20.04.2  Ejecutando lspci -v arroja esta información:  Network...