Holiday Notice – Support Unavailable on April 18 and April 21
We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!
In the meantime, if you need any help, feel free to:
-
Use the support widget in the bottom right corner on our websites (Amelia and wpDataTables) — our latest AI-powered assistant is there 24/7 to help with basic and intermediate questions,
-
Browse our detailed documentation (Amelia, wpDataTables)
-
Explore helpful articles,
-
Or check out our YouTube channels for video guides!
Amelia YouTube Channel
wpDataTables YouTube Channel
Thank you for your understanding, and we wish you a wonderful holiday weekend!
Hello,
I have a client who has created a formula in an Excel spreadsheet, and what he wants to do is display only specific values to a WordPress page, with the ability to auto-update from time to time.
I was hoping your plugin might be able to help me accomplish that?
Beven
Any feedback on this question?
Hi Beven
Thank you for reaching out to us.
Importing or linking to Excel files that have formulae is not possible. You would need to copy the columns and rows that contain raw data, and then use formula columns to perform the same calculations in wpDataTables.
Our Formula Columns accept only basic mathematical operations, and you can't use complicated formulas in there. The formulas in wpDataTables are not the same as in Excel, so you may be able to achieve what you need with nested formulas (for example if Formula1 column is A*B/12; and you need to divide Formula1 column in another Formula2 column, you'd need to include the formula again, so Formula2 would be (A*B/12)/4).