Create custom layout on webpage

I’m not sure I understand the question.

If your spreadsheet contains different kinds of data that is unrelated, you should consider redesigning the structure of your spreadsheet. Spreadsheets are also not really useful for supplying layout data generally. If you’re unsure about how to use spreadsheets or what they are useful for, I recommend the free classes by ExcelShir.com. (It says Excel but everything he teaches applies to Google Spreadsheets, too.)

Like he suggests in his many classes, you can also create a new sheet that references data in another sheet in order to use for different purposes. That might be a workaround useful in your case.

Hi Meitar, thanks for your response and this plugin!

To clarify I have a spreadsheet that has 30 cols and 1000 rows.

On my web page I’m using the Inline viewer to view the entire sheet. What I’m looking to do is actually create a single web page with only data from a single row. The end result would be like a yelp page listing, that would let me call a single cell on the sheet to place wherever I want on the final web page. So, rather than a row of data I’m looking to create a template where I could call individual cells to populate.

Thanks again!

Ah, I see. Well, you can use the query attribute attribute to select a certain row using a where clause, or define an offset and then a limit of 1 to fetch only one row at a particular spot in your spreadsheet. But doing this programmatically in your templates is left as an exercise to the reader. ??

Ok gotcha. Thanks again for this plugin, great work!