Retrieve raw data from TablePress

Hi,

thanks for your question.

The “Single Cell Shortcode Extension” is a good start for this actually. When you check its source code, you can see the line

$table = TablePress::$controller->model_table->load( $table_id );

That’s the internal function that retrieves the table content from the database.
This is then a multi-dimensional array that contains all information about a table, like its data and the options. In particular, the table data is stored in the two-dimensional array

$table['data']

You can then use this to create any output (like a graph or whatever) from this array.

Another solution would be to use the tablepress_table_output filter hook, as that would allow you to overwrite the HTML table output with your own. That filter can be found it in the render.class.php of TablePress.

I’d however recommend the first idea, with using the function from the Shortcode. That’s easier and more flexible. In any case, you will need to do some PHP programming, but I guess you expected that.

Regards,
Tobias

Yep, I should have found it by myself. Thanks very much !

Hi,

sure, no problem! ?? I hope it helps!
If you manage to create graphs with this idea, please let me know. Sounds interesting!

Best wishes,
Tobias

P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

Hello Tobias, [Resolved]

I tried this approach:

$table = TablePress::$controller->model_table->load( $table_id );

and pulled the data from

$table['data']

I originally imported 1250 rows of data, and $table[‘data’] only retrieves the first 7 rows. Is there a parameter that limits the number of rows returned?

Sorry… the rows are being returned.. subsequent code truncates the number of rows.

Thanks
Richard

Hi Richard,

thanks for your post.

Good to hear that you were able to fix the problem already.
May I still ask what you are using this for? I’m always interested to see how people extend/use TablePress.

Regards,
Tobias