Extract Cell Value without Table?

I’d like to use this plugin to get the value of a single cell, without any HTML table formatting. I’m aware of another thread here that asks the same question, but in that, the returned value is still within a <table> tag.

This has not changed since that thread. If you do not want the HTML table, but for some reason still want to use this plugin instead of calling your spreadsheet data yourself (it is a one-liner with WordPress’s wp_remote_get() function) you could strip the HTML yourself with the gdoc_table_html filter. But that seems ridiculous. Just get your raw data yourself?

Also, is there a way to link to a range within a spreadsheet? The plugin would then just display that range instead of the entire sheet…

Did you not read this plugin’s readme file? Use the shortcode’s query attribute.

Why don’t more people—especially programmers—read the readme files? Sigh.

I did read about the “query” attribute, but couldn’t figure out how to reference a range of cells. From what I understand, queries allow you to use SQL.

Perhaps you’re suggesting that I create a separate “ID” column and use the SQL query like:

Select columns where ID between [some range]?

Also, could you point me in the right direction to using wp_remote_get() to extract a cell value from Google spreadsheet? Would be grateful!

I figured out how to do it.