A
A
Alexey Smirnov2014-04-13 08:34:02
Google Sheets
Alexey Smirnov, 2014-04-13 08:34:02

How can I display data from only one cell of a Google Docs spreadsheet on a web page?

There is such a table:
https://docs.google.com/spreadsheet/ccc?key=0ApUv4...
I need to display textual information from only one cell of this table on the site.
For example, this is cell C3.
How can I do that?
PS I found this method on the Internet:
www.bdnyc.org/2012/08/22/how-to-embed-a-live-googl...
but in this way (via iframe) I can only display the entire table, and NOT one cell. Maybe I'm doing something wrong... Maybe there is another way...

Answer the question

In order to leave comments, you need to log in

3 answer(s)
I
Illarion Labahua, 2015-09-27
@ERAFY

1. Create a new table that consists of one cell and embed it in the site
2. The value of the cell is calculated based on a formula similar to this one:
=IMPORTRANGE("1Y0Se2V_oTfOUSUG6diWm1yL8Pr0GR8B_vRSM8ou_0BQ";"Aladdin! A1"
) by function "IMPORTRANGE" : https://support.google.com/docs/answer/3093340?hl=en

V
Vitaly Bogryashov, 2015-12-10
@vitalybogryashov

Here too it is interesting to me (without re-reading of a heap of docks). Maybe someone will answer how to get table cells to your site (PHP, JS - it doesn't matter). Interested precisely - is there a ready-made script / api / application? It seems to me that there definitely is, but if someone has already solved such a problem for themselves, please share.

K
Konstantin, 2020-01-28
@wizhub

Here you can find out https://marketello.ru/lesson/google-sheets-data-to... The person
told how to take a range or one cell

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question