{"id":1052,"date":"2011-10-27T18:00:53","date_gmt":"2011-10-27T14:00:53","guid":{"rendered":"http:\/\/www.dhtmlx.com\/blog\/?p=1052"},"modified":"2023-05-05T14:14:18","modified_gmt":"2023-05-05T11:14:18","slug":"dhtmlx-web-based-spreadsheet","status":"publish","type":"post","link":"https:\/\/dhtmlx.com\/blog\/dhtmlx-web-based-spreadsheet\/","title":{"rendered":"dhtmlxSpreadsheet: Easy-to-Use Ajax Spreadsheet"},"content":{"rendered":"

Offering the tools that make the life of a web developer easier, we would like to introduce another helper – dhtmlxSpreadsheet<\/a>. It can save a lot of time for those who need to integrate, manage, and share web-based data tables on the web. <\/p>\n

Unlike online services (Google Docs, etc.), dhtmlxSpreadsheet can be installed on your website, allowing you to store the data in your own database. This tool is written in JavaScript and PHP (based on dhtmlxGrid<\/a>) and enables you to put an Excel-like spreadsheet anywhere on a webpage. <\/p>\n

dhtmlxSpreadsheet uses Ajax to load and update data on the server side. While the user edits the spreadsheet, adds or removes records, all these changes are automatically saved to the database.<\/p>\n

\"dhtmlxSpreadsheet

dhtmlxSpreadsheet - JavaScript & PHP Spreadsheet<\/p><\/div>\n

dhtmlxSpreadsheet is very easy to use. You only need a few minutes to get an editable data table with basic cell formatting, math functions, and keyboard navigation. <\/p>\n

 
\nEasy Initialization<\/strong><\/p>\n

dhtmlxSpreadsheet comes with a special installer that configures the database settings and creates a necessary database structure.<\/p>\n

\"dhtmlxSpreadsheet

dhtmlxSpreadsheet Installer<\/p><\/div>\n

When the database is configured, all you need is just one line of code, for example:<\/p>\n

<script<\/span> src<\/span>=<\/span>".\/dhtmlx\/spreadsheet.php?sheet=price_report"<\/span> ><\/<\/span>script<\/span>><\/span><\/div><\/div>\n

This code generates dhtmlxSpreadsheet on a web page and you get a nice-looking table to organize and share your data.<\/p>\n

 
\nCMS Integration Plugins<\/strong> <\/p>\n

To facilitate the integration of dhtmlxSpreadsheet with CMS platforms, we offer ready-to-use plugins for Joomla!, WordPress, Drupal, and ModX. Use the plugins to quickly add a spreadsheet on your website and configure the editing rights (you can set password protection to edit the records).<\/p>\n

 
\nBasic Formatting<\/strong><\/p>\n

The spreadsheet supports basic cell formatting options: you can change text color, cell background, set text align, rename column headings, etc. You can also navigate through the spreadsheet with the keyboard and define basic settings right there.<\/p>\n

\"Spreadsheet

Spreadsheet Settings<\/p><\/div>\n

 
\nMath Functions<\/strong><\/p>\n

Providing a set of built-in math functions, dhtmlxSpreadsheet allows you to perform different mathematical operations on a cell or group of cells. All calculations are made on the server side so you can be sure that they are accurate and precise.<\/p>\n

\"dhtmlxSpreadsheet

dhtmlxSpreadsheet - Math Functions<\/p><\/div>\n

 
\nExport to PDF and Excel<\/strong><\/p>\n

You can easily export your spreadsheets to PDF and Excel formats by clicking the buttons in the top right corner (displaying the buttons is optional). <\/p>\n

\"dhtmlxSpreadsheet

dhtmlxSpreadsheet - Export to PDF<\/p><\/div>\n

 
\nClipboard Support<\/strong> <\/p>\n

By using ctr+c, ctr+v, you can copy and paste a cell or selected block of cells from dhtmlxSpreadsheet to the Excel document, and vice-versa.<\/p>\n

 
\nYou can place the spreadsheet anywhere on your website and share it with your clients, colleagues, or friends. To learn more about our spreadsheet solution and download the package, visit dhtmlxSpreadsheet homepage<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

Offering the tools that make the life of a web developer easier, we would like to introduce another helper – dhtmlxSpreadsheet. It can save a lot of time for …<\/p>\n","protected":false},"author":2,"featured_media":3367,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[70,38],"tags":[33,6,34],"class_list":["post-1052","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-releases","category-visible","tag-all-posts","tag-dhtmlxgrid","tag-spreadsheet"],"_links":{"self":[{"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/posts\/1052","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/comments?post=1052"}],"version-history":[{"count":1,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/posts\/1052\/revisions"}],"predecessor-version":[{"id":10836,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/posts\/1052\/revisions\/10836"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/media\/3367"}],"wp:attachment":[{"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/media?parent=1052"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/categories?post=1052"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/tags?post=1052"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}