Hi, abdo.

Thanks for reaching out to us.

-

1. First i will give you some introduction in using Google Spreadsheets with our plugin.

When we deal with large data sets,  if they go over couple thousand rows, if you have to link the Spreadsheet to a table, it is recommended ty try our cache and auto-update cache feature.

There are two ways how you can use Google Sheets data in our plugin ;

1a. Link the table to Google Spreadsheets, 

when you modify or add new rows on the source sheet,

 the plugin will show those changes within 15 minutes (since there's cache on Google's side). More details here. 

If you don't want to face any issues with cache, you can use the Google Sheets API method. ( more details here-)

- But this table will not be ediable from the plugin side,  you can just edit the source sheet.

-

And if you have more than a couple thousand rows, the table will become very slow or even break the page,

so it is recommended to try our caching and auto-update cache feature.

With the new caching option, the load time is significantly lowered, but we still recommend keeping the data in these files down to around 5.000 rows.

If it goes over 5 thousand rows - then we recommend to use the other method, import the Sheet to make a new Manual table, which we go over in more details below.

1b. If you import the file, the plugin reads the source file and creates a manual table. 

Once the table is created, it is no longer linked to the source file, so changing data in the table will not show up in Excel or Google Spreadsheet, and vice-versa. 

To modify this table, you can either switch to the Excel-like view, 

and then select and copy the range of cells you want to paste from the source file, and paste it in the Excel-like view, 

or you can import a new/edited CSV to update the table, as well, in the following ways :

• Update manual tables: Replace data within an existing table.
• Update manual tables: Add data to an existing table.
•  Update manual tables: Replace the entire table with new data.

-

2. Can I add your plugin to a page in a way where the user can select the rows and columns they want to display?

It depends exactly what you mean by this.

If you mean simply to allow filtering for the front-end user, so that they can use filters to "narrow down" what they need to see, 

please check our available filter options here.

-

In regards to selecting which columns are visible, we have this option in Table Tools/ Column visibility.

It is a tool to allow front-end users to toggle column visibility.

You can learn more here.

3. Can I upload the entire table onto my WordPress website, but have the ability to display only specific rows and columns on each page of my website?

-

For pre-filtering different rows of the same table on different pages, we have  multiple solutions.

If you wish to try Pre-filtering tables through URL,  please check out this page with examples.

-

You can also use placeholders for table generation.

1. For example, if you have a MySQL query-based table, you can use this query:

SELECT * FROM yourDatabaseTable
WHERE columnName = '%VAR1%'

%VAR1% can be defined in the Placeholders tab when you're creating a table, 

or you can pass VAR1 value in the table's shortcode.

-

For example if i have this Master Manual Table,

and i want to make a dynamic SQL Table with VAR1 placeholder.  ( Then later i can input different VAR1 in the table shortcode on different pages).

My example SQL Query for the table will be :

SELECT * FROM wp_wpdatatable_44
WHERE company = '%VAR1%'

First, just to initially generate an SQL table with the VAR1 ,

i will set the Cakewalk  company name in the VAR1 , in table's Placeholders tab :

-

Then, for example, if i want to make a different page for another Company,

 let's say "Adobe".  Then i pass that value in the VAR1 of the table shortcode :

2. 

Or, if you don't add the condition in an SQL query, you can add %VAR1% in column settings -> Filtering, under "Predefined filtering value".

Then, you can have different versions of the same table, with the VAR1 value passed in the shortcode,

let's say if we had a "Regions" column and we wish to filter a different region per each page.

If we want page 1 for example only filtered for "Region A" , you can set predefined filter to this column as %VAR1% (filter type has to be set as text) :

Then for a page where we need only Region 1 filtered, use shortcode [wpdatatable id=1 var1='Region A'] ,

 page 2 for only "Region B", shortcode would be [wpdatatable id=1 var1='Region B'] and so on, 

to apply the values defined in the shortcode to the filter.

( This filtering method can be used for any table type, besides Simple Tables)

-

I also made a short video example - please check it out here.

In regards to having the same table show different columns on different pages,

for this we don't currently have a solution.

The only workaround is to make multiple SQL Query-based tables from the same source table from the database,

then you can have each table with different columns on different pages.

For example, if you have a main Manual Table,  with all columns, check what's the SQL table name under Editing,

then paste that table name for a new SQL table, for example :

SELECT column1, 
    column2,     
    column 3
FROM main_Table_Name

then in another SQL table for page 3, you can set

SELECT column4, 
    column5,     
    column 6
FROM main_Table_Name

and so on.

-

And i just wanted to point out that you can try wpDataTables before purchasing

 on our sandbox Demo sites ( you can find links for the main plugin Demo,  

as well as add-on Demos, in my signature),

and there is a 15-day money-back guarantee period, 

so if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)

Let me know if you have any additional questions.