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?
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).
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).