How to get it read a database table?

Hello,

I must be missing something. I can’t find a description anywhere to tell me how I show database table data in the spreadsheet. Where do I specify the table to read?

Thank you!

Hi,
spreadsheet uses specific database table format to store information. You can’t use another tables.
But we provide PHP API and you can write a script to export information in required format.
Here are more details about PHP API:
docs.dhtmlx.com/doku.php?id=dhtm … :reference

Hi Again,
Thank you for replying. I am very sorry but, I still don’t understand how this plugin is intended to be used. I am trying to use the spreadsheet plugin in a wordpress website. I have installed the plugin as described on this page:

docs.dhtmlx.com/doku.php?id=dhtm … _wordpress

I have entered the [[spreadsheet]] shortcode on my page, and my page now displays an empty spreadsheet as have shown in the instructions.

What is the next step? Do I have to perform any additional installation steps for the wordpress installation?

I have typed data into the spreadsheet. How do I save the data?

Can I create more than one spreadsheet?

How do I set the number of columns to display, and set the column width?

Thank you for your help.

Hi,
you should be logged in as administrator. In such way you have ability to edit spreadsheet values, styles. Also there is a button ‘Settings’ on the right top corner. It enables you to edit number of rows/columns and some another options.
All changes are saved automatically. You don’t have to press any additional buttons to save data into database. It’s saved exactly after you closed editor.
You can create more than one spreadsheet using parameter id in short tag [[spreadsheet?id=table2]]. Different ids uses different datasets.