Import a cell?

Return row 1, column A (cell A1):

[gdoc key="ABCDEFG" query="select A limit 1"]

Return row 5, column 3 (cell C5):

[gdoc key="ABCDEFG" query="select C limit 1 offset 4"]

However, in practice you probably want to restructure your spreadsheet or your query if you just want to return a single value. For example:

Pre-processing data with Google Queries

You can pre-process your Google Spreadsheets or CSV files before retrieving data from them by passing a Google Charts API Query Language query to the shortcode’s query attribute. This lets you interact with the data in your Google Spreadsheet or CSV file as though it were a relational database table. For instance, if you wish to display the team that scored the most goals on your website, you might use a shortcode like this to query your Google Spreadsheet and display the highest-scoring team, where the team name is the first column (column A) and that team’s score is the second column (column B):

[gdoc key="ABCDEFG" query="select A where max(B)"]

It worked but still displaying the header of the selected column .

It worked but still displaying the header of the selected column.

Use strip="1" to strip the column headers.

[gdoc key="ABCDEFG" strip="1" query="select A limit 1"]

Hi,
is it possible to hide all the table, displaying just the value?

Using [gdoc key=”ABCDEFG” strip=”1″ query=”select R limit 1 offset 1″]
I get this:
https://s21.postimg.org/6ehtq7p8n/cap.jpg

I’d like to show just the content which in this case is “7”

Thank you for your help

The table is the value. If you hide the table, you hide the value. You probably want to hide the search, sort and paging features. Do that by adding class="no-datatables" to your shortcode.

I’m looking for the same solution, just the value to place inline with other text. With the code above, The value still appears in a box, can that box/table be removed within the shortcode?

The value still appears in a box, can that box/table be removed within the shortcode?

No. You should use CSS to make it appear inline. (Change the elements display value.)