sheets2web.XSLT

xsl code that can generate a webpage from a xml exported spreadsheet

HOW TO Google Sheets:

1. get add-on "Export Sheet Data"
2. Add-ons -> Export Sheet Data -> Open Sidebar
3. Select:

• Export Format = XML
• Include first column in export

4. click Export
5. Move file to this folder, and open sheet.html on (local)server

To enable dropdown rows:

1. In sidebar, select "Child elements prefix"
2. Insert prefix in every column header that needs to be in the dropdown