I want to create a table using imported data from an Excel, but my question of what if some cells has formulas instead of plain numbers? Will that import work? How can be done? Any documentation to read?
Hi Lucas, Thank you for your interest in wpdatatables.
When working with Excel-based tables, please note 2 things:
Formulas and merged cells are not supported,
They generally work slower than CSV-files, or even Google Spreadsheets; so if your table is large, it is much better to port it to a different format, or – even better – to MySQL table (you can use “Create a table by importing data from data source” to import your Excel file to MySQL).
We have Lite version of wpdatatables which you can try for free.
wpDataTables Lite is a basic version of a popular best-selling WordPress table plugin. While some premium features are reduced, wpDataTables Lite is still quite a handy tool that allows you to quickly create tables in WordPress from different sources. You can download it from this link.
Also, you can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin premium features.
All useful information about all wpdatatables features that are explained (video and text) you can find in our DOCUMENTATION.
I want to create a table using imported data from an Excel, but my question of what if some cells has formulas instead of plain numbers? Will that import work? How can be done? Any documentation to read?
Hi Lucas,
Thank you for your interest in wpdatatables.
When working with Excel-based tables, please note 2 things:
What we have is Formula (calculated) columns.
We have Lite version of wpdatatables which you can try for free.
wpDataTables Lite is a basic version of a popular best-selling WordPress table plugin. While some premium features are reduced, wpDataTables Lite is still quite a handy tool that allows you to quickly create tables in WordPress from different sources. You can download it from this link.
Also, you can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin premium features.
All useful information about all wpdatatables features that are explained (video and text) you can find in our DOCUMENTATION.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables