Title: Extract Cell Value without Table?
Last modified: July 8, 2018

---

# Extract Cell Value without Table?

 *  Resolved [bhagwad](https://wordpress.org/support/users/bhagwad/)
 * (@bhagwad)
 * [8 years, 1 month ago](https://wordpress.org/support/topic/extract-cell-value-without-table/)
 * Hi! First of all, thank you for a magnificent plugin! As a programmer myself,
   it’s hard for me to imagine the effort you must have put into this. We all owe
   you big time 🙂
 * 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.
 * Is there any way to get just the value without anything else?
 * 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…
 * Thanks for your help in advance!

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [8 years, 1 month ago](https://wordpress.org/support/topic/extract-cell-value-without-table/#post-10244930)
 * > 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.
 *  Thread Starter [bhagwad](https://wordpress.org/support/users/bhagwad/)
 * (@bhagwad)
 * [8 years, 1 month ago](https://wordpress.org/support/topic/extract-cell-value-without-table/#post-10245005)
 * 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]?
 *  Thread Starter [bhagwad](https://wordpress.org/support/users/bhagwad/)
 * (@bhagwad)
 * [8 years, 1 month ago](https://wordpress.org/support/topic/extract-cell-value-without-table/#post-10245009)
 * 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!
 *  Thread Starter [bhagwad](https://wordpress.org/support/users/bhagwad/)
 * (@bhagwad)
 * [8 years ago](https://wordpress.org/support/topic/extract-cell-value-without-table/#post-10271214)
 * I figured out how to do it.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Extract Cell Value without Table?’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/inline-google-spreadsheet-viewer.
   svg)
 * [Inline Google Spreadsheet Viewer](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/)
 * [Active Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [bhagwad](https://wordpress.org/support/users/bhagwad/)
 * Last activity: [8 years ago](https://wordpress.org/support/topic/extract-cell-value-without-table/#post-10271214)
 * Status: resolved