if you choose to Create a wpDataTable and upload the Excel file :
in which case you get to select the file (upload it) that'll be used to pull the data.
This file will be stored in ../wp-content/uploads/YEAR/MONTH/ folder.
The file on that location can be changed/edited, but the column structure can't.
So, if you have the file with the same name,
the same number of columns, same headers, and the same order of columns - you'd be able to replace the original file with the new file, and wpDataTables would pick that up.
-
Alternatively, if you select "URL from any domain"
Creating a table linked to an Excel file by providing its URL is pretty much the same as it is for creating a table by uploading an Excel file.
The only difference is that you would choose the URL from any domain option instead of the WordPress Media Library option under File location when creating the table,
and when you want to edit the source file, you don't have to edit the one that is now in your Media Library folder,
but you can edit on the original source file.
Please note: For the option of “URL from any domain”,
this source file needs to be accessible online in order to create a table from it, and the path to the file has to end with the file extention, for example with “.XLSX” or other Excel format.
If the URL path to the source file does not end with a dot and its extension,
it will not work.
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 :
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)
hi,
I would like to know if can wpdatatables support importing (syncing) data to an existing table by uploading Excel files.
Hi Giam,
Yes, this is only possible for Manual Tables.
You can make a Manual Table from scratch, like explained on this Documentation;
Or you can Creating editable tables by importing data from Excel, CSV or Google Spreadsheets.
Then, when you have an existing Manual table,
you can Update manual tables from source files (CSV, Excel or Google sheet).
Let me know if that is what you meant to achieve.
Thanks.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Giam,
My apology, just one more detail, you mentioned you wish to 'sync' data with an existing Table.
I was not sure if you need the source file to be synchonized/linked to a Table?
-
So i will elaborate in more details about two ways how you can use Excel as data source for our Tables.
If you would use Excel spreadsheets,
there are two ways to create wpDataTables:
1. Create a table linked to an existing Excel file,
if you choose to Create a wpDataTable and upload the Excel file :
in which case you get to select the file (upload it) that'll be used to pull the data.
This file will be stored in ../wp-content/uploads/YEAR/MONTH/ folder.
The file on that location can be changed/edited, but the column structure can't.
So, if you have the file with the same name,
the same number of columns, same headers, and the same order of columns - you'd be able to replace the original file with the new file, and wpDataTables would pick that up.
-
Alternatively, if you select "URL from any domain"
Creating a table linked to an Excel file by providing its URL is pretty much the same as it is for creating a table by uploading an Excel file.
The only difference is that you would choose the URL from any domain option instead of the WordPress Media Library option under File location when creating the table,
and when you want to edit the source file, you don't have to edit the one that is now in your Media Library folder,
but you can edit on the original source file.
Please note: For the option of “URL from any domain”, this source file needs to be accessible online in order to create a table from it, and the path to the file has to end with the file extention, for example with “.XLSX” or other Excel format. If the URL path to the source file does not end with a dot and its extension, it will not work.
2. Or, 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 :
You can see more details on Updating manual tables from source files (CSV, Excel or Google sheet) here.
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.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables