Frequently asked questions for self help.

Knowledge base article 137

Generating a web page from spreadsheet data

It is possible to use functions to generate the table structure that copies the rows and columns of a spreadsheet and then save the result as HTML. The idea is to use a spare sheet and then make use of the CONCAT function to add the html tags to surround the data from the sheet you want to export.

For example, see sheet2 in in the following: makehtml.aws. Note that this replicates sheet1 but in html form - the result can be copied into a text editor and saved as a web page.