WordPress has basic HTML table settings but essentially that is all she wrote. If users want to add sophisticated spreadsheets or data grids to their Pages/Posts there are few options available from the 20,000 WordPress plugins [try it by searching the WP plugins directory for “data grid” or “spreadsheet”].There are two plugins which display Office files including spreadsheets – Scribd and Google Docs viewer. But each of these has drawbacks – Scribd requires users to upload files to their website where they become public property while Google Docs viewer has problems displaying MS 2007 XML file formats.The upgrades to TablePress allow users to import CSV and XLS files but at the price of losing Excel simple formulas and problems with cells containing date or timestamp data.
Sample spreadsheet component showing formating options
Finally, the spreadsheet needs to be made read-only. Here DHTMLX only comes partially to the rescue. By right-mouse clicking on the spreadsheet one can lock the spreadsheet.However, any user could discover this and change the scores. But because the data is so easy to up & download such changes would quickly be spotted and corrected.
True, DHMLX Spreadsheet is far from perfect – it does not support macros, has a fraction of the standard Excel functions and ditto for formatting features But WordPress support of tables and spreadsheets is close to antediluvian, making this DHTMLX Spreadsheet solution not just effective but very attractive for WordPress users.