dhtmlxSpreadsheet: Easy-to-Use Ajax Spreadsheet

| Comments (33)

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 those who need to integrate, manage, and share web-based data tables on the web.

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) and enables you to put an Excel-like spreadsheet anywhere on a webpage.

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.

dhtmlxSpreadsheet - JavaScript & PHP Spreadsheet

dhtmlxSpreadsheet - JavaScript & PHP Spreadsheet

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.

 
Easy Initialization

dhtmlxSpreadsheet comes with a special installer that configures the database settings and creates a necessary database structure.

dhtmlxSpreadsheet Installer

dhtmlxSpreadsheet Installer

When the database is configured, all you need is just one line of code, for example:

<script src="./dhtmlx/spreadsheet.php?sheet=price_report" ></script>

This code generates dhtmlxSpreadsheet on a web page and you get a nice-looking table to organize and share your data.

 
CMS Integration Plugins

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

 
Basic Formatting

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.

Spreadsheet Settings

Spreadsheet Settings

 
Math Functions

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.

dhtmlxSpreadsheet - Math Functions

dhtmlxSpreadsheet - Math Functions

 
Export to PDF and Excel

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

dhtmlxSpreadsheet - Export to PDF

dhtmlxSpreadsheet - Export to PDF

 
Clipboard Support

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.

 
You 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.

Comments

  1. zee October 31, 2011 at 10:40 am

    Excellent addition to dhtmlx lib. Keep it on guys:-)!

  2. FranX October 31, 2011 at 2:54 pm

    Thanks again for the great work you delivered with this!

    Although there seems to be an error in the formulas code. When I try to use the SUM() formula like =SUM(A1:A5) an error in the calculated cell apears with value: #ARG_ERROR. Creating the SUM() works as expected but the error apears after the cell was edited.

    • Stan November 3, 2011 at 11:42 am

      Packages updated, so the above error must not occur anymore.

  3. Iliya November 5, 2011 at 6:33 pm

    Cool! Will supporting Asp.net?

    • Ivan November 8, 2011 at 6:31 pm

      We do not plan to release an ASP.NET version in the near future, maybe later.

  4. Krishnan November 9, 2011 at 5:30 pm

    this is working fine in localhost.But its not working when configured in remote access.Pl help me out

  5. Karvesh November 18, 2011 at 12:28 pm

    I tried it, and it is brillant. The ease of inputting data is great. Just a question: for the moment the APIs seem quite basic. Will there be the possibility to lock columns or rows or even add validations in the future?

    • Ivan November 21, 2011 at 12:04 pm

      Locked rows and columns will be added for sure (we have many requests for it).

      As for validation, it looks as a good addition as well.

      Not quite sure, but I think that version with these features will be available till the end of the year.

  6. Marina March 16, 2012 at 7:08 pm

    Hello,

    Thanks for the great application! Two questions: a) Can you select all by clicking on the top leftmost cell, like in Excel? b) Is it possible to undo and redo using CTRL-Z and CTRIL-Y, like in Excel? Thanks again!

    Marina.

    • Marina March 16, 2012 at 11:58 pm

      Ivan, let me rephrase my last question. Is dhtmlxgrid_undo.js available under the GPL open-source license?

      Thanks,
      Marina.

      • Ivan March 19, 2012 at 4:02 pm

        Marina, these features aren’t available in the current version of dhtmlxSpreadsheet (v.1.0). They will be implemented in the next version. Unfortunately, there is no a specific release date yet.

  7. Satish June 29, 2012 at 11:42 am

    Can i use the Spreadsheet in ASP.NET application anyhow?

    • Ivan June 29, 2012 at 3:58 pm

      You need PHP to use dhtmlxSpreadsheet. Unfortunately, we don’t have an ASP.NET version yet.

  8. Yogiraj January 2, 2013 at 10:57 am

    Hello,
    We will like to use your spreadsheet in ASP.NET.
    Have you upgraded the Spreadsheet package for ASP.NET?

    • Ivan January 3, 2013 at 2:43 pm

      Unfortunately, there is no version for ASP.NET.

  9. Joseph January 9, 2013 at 9:02 am

    is there any function for Opening File in PC or Local files?

    • Inga January 9, 2013 at 5:35 pm

      Joseph, not sure what you mean. Please clarify your question.

      If you mean export to Excel, there is a button in the header of the spreadsheet.

  10. Suvra July 8, 2013 at 12:35 pm

    how to get updated version…. [fx] is not working…..

    • Ivan July 8, 2013 at 4:04 pm

      You can download the latest available version here. If you have any issues with dhtmlxSpreadsheet features, please post your questions to the forum.

  11. tony November 30, 2013 at 8:58 am

    can i load a spreadsheet from php with math formulas .user will be able to change few fields but not math formulas

    • Ivan December 3, 2013 at 6:36 pm

      Tony, unfortunately there is no way to deny editing some cells. You may lock the cell with formula, so it will prevent editing of cell, but user can’t unlock it if he wants. Lock/Unlock was designed to prevent occasional changing cells, but not to deny users to edit cells at all.

  12. abhijeet September 2, 2014 at 5:35 pm

    Can we mearge cell in this please help me

    • Ivan (DHTMLX team) September 3, 2014 at 12:45 pm

      Unfortunately, there is no such an option.

  13. abhijeet September 3, 2014 at 2:24 pm

    How to get AVERAGE in that

  14. sreenivasa yarram January 7, 2015 at 9:40 am

    Hi
    We will like to use your spreadsheet in ASP.NET.
    Have you upgraded the Spreadsheet package for ASP.NET?

    • Ivan (DHTMLX team) January 8, 2015 at 5:26 pm

      Unfortunately, we don’t plan to release ASP.NET version in the near future.

  15. John Velling June 4, 2015 at 1:53 am

    Having trouble implementing a COUNTIF function: =COUNTIF(A1:A10;”<1") gives error message. Any suggestion as to how this might be handled?

  16. Zick September 19, 2015 at 5:55 am

    How can i auto refresh the formula that i put in dhtml? i inserted already the fromula in the database to make the user don’t put the formula, i already set the fromula for them, now my problem is that the field numbers of in the formula don’t set to its coresponding number. how to do this?

  17. Zick September 19, 2015 at 6:22 am

    and also when i copy the data in the field, the formula inside that field don’t a dopt when i paste it to other field, only the viewed data that i can copy, but the hidden formula inside it does can’t copy

  18. Udhay November 11, 2015 at 3:14 pm

    How to disable the display buttons is optional

  19. Peter Hii March 22, 2016 at 5:55 am

    after installing plugin in WordPress the spreadsheet display fine, but maths functions did not show up. Why?

Leave a Reply