Title: Spreadsheet and WordPress
Last modified: April 18, 2017

---

# Spreadsheet and WordPress

 *  Anonymous User 14711751
 * (@anonymized-14711751)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/spreadsheet-and-wordpress-2/)
 * I used CMS Made Simple before WordPress and I had a web based spreadsheet. Users
   were able to calculate with it and the formulas were protected.
 * It inculed .php-file which had html such as: input type=”submit”, {$varABC} etc.
 * And then an user defined tag which included formulas such as:
    $varABC = $_POST[‘
   formABC’]; $smarty->assign(‘varABC’, $_POST[‘formABC’]); $varABC = $varCDE + 
   $varFGH; $smarty->assign(‘varABC’, $varABC);
 * What would be the best and easiest way to do that in WordPress?
 * Thanks
    Syreeni

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * (@bcworkz)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/spreadsheet-and-wordpress-2/#post-9043376)
 * You probably should just use Google sheets. Your sheet can be embedded on a WP
   page by pasting in some iframe code provided when you pick the sheet’s Publish
   to Web menu item. Google sheets have an API where you can remotely manipulate
   the sheet by script. So I imagine you could have some input fields on the page
   with the embedded sheet and when submitted, the data can be sent to the sheet
   through the API and placed in certain cells. Then the formula cells will update
   accordingly.
 * Depending on what your sheet is actually calculating, it may make more sense 
   to build a custom calculator app that takes user input, crunches the data, then
   updates the display with the results. Nowhere near as flexible as a spreadsheet,
   but when a sheet’s formulas are protected, it’s no longer flexible. Depending
   on your need, all the calculation could be handled by JavaScript. Being event
   driven, the resulting app could be very interactive and be just as satisfying
   to the user as a sheet with protected formulas.
 *  Thread Starter Anonymous User 14711751
 * (@anonymized-14711751)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/spreadsheet-and-wordpress-2/#post-9043405)
 * Thank you bcworkz! Your answer gave me good image what are the possibilities 
   with WP. I think the second option would be the best one.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Spreadsheet and WordPress’ is closed to new replies.

## Tags

 * [php](https://wordpress.org/support/topic-tag/php/)
 * [spreadsheet](https://wordpress.org/support/topic-tag/spreadsheet/)

 * In: [Developing with WordPress](https://wordpress.org/support/forum/wp-advanced/)
 * 2 replies
 * 2 participants
 * Last reply from: Anonymous User 14711751
 * Last activity: [9 years, 1 month ago](https://wordpress.org/support/topic/spreadsheet-and-wordpress-2/#post-9043405)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics