Google Sheets – Export Part of Spreadsheet to HTML

google sheets

Google spreadsheet allows you to save the table as HTML:

save google spreadsheet as HTML

The problem is that what the HTML you get is not publishable in website or coherent HTML document:

exported google spreadsheet

I'd just like a part of the table as HTML. What can I do?

Best Answer

I suppose your documents holds data that you do not want to share.

So I would :

add a sheet "public" in which I would copy/paste the data
use the built-in "publish for the web" functionality
in the "publish" dialog, limit the publication to the "public" worksheet

Note that, instead of copy/paste (annoying if the data changes frequently) you can use the IMPORTRANGE function.

Related Solutions

Google-sheets – How to Send Html Emails in Google Spreadsheet

Check the documentation for MailApp.sendEmail(). Assuming you have HTML code in the spreadsheet that you are loading into the message variable, you can specify an HTML body like so:

MailApp.sendEmail(emailAddress, subject, "", {htmlBody: message});

Google Sheets – Insert Bookmark

There is no real way if linking to a cell in Google Spreadsheets (I'm trying to build one using HTTP GET, but I'm stuck right now), but you can use a little trick I've found here.

Insert/Comment at a specific cell, and, in that comment "plus someone" - that is, type "+" and then the person's email or name NOTE: you will get a list of people in your domain as soon as you type the "+", filtered as you start typing their name/email the person you "plussed" will get an email with both the contents of the cell and your comment the link in that email will take them DIRECTLY TO THE TARGET CELL with the comment activated.

Add the person you want to send the link to, or yourself to get the link.

Best Answer

Related Solutions

Google-sheets – How to Send Html Emails in Google Spreadsheet

Google Sheets – Insert Bookmark

Related Topic