PHP/Javascript based spreadsheet editor library

Posted on 2010-11-17
Medium Priority
Last Modified: 2012-08-13
I'm looking for a php/javascript/jquery based library which I can drop into my web application that will provide excel-like spreadsheet editing capabilities.

I'm looking for something fairly simple to implement, that supports your usual spread-sheet like functions, though I am specifically looking for Excel's "expanding a selection" features and some basic formula capabilities.

Question by:Frosty555
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 13

Accepted Solution

F Igor earned 2000 total points
ID: 34160173
you could try the jqgrid plugin


The site have a lot of examples to check.


LVL 31

Author Comment

ID: 34162258
jqgrid is not a spreadsheet, as far as I can tell it does not have any facilities for having the user add/remove rows and columns, doesn't support formulas, doesn't support row resizing, doesn't support loading/saving to csv or some similar format. It can load from XML but from what I can see there's no way to save.
LVL 111

Expert Comment

by:Ray Paseur
ID: 34164219
It's an interesting question.  This sounds like something that would be very expensive.  Any chance you might want to use Google Apps?  There might also be some wrapper for a part of the open-office applications.
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 31

Author Comment

ID: 34172647
I'd consider using a google product - but it needs to integrate fairly seamlessly into my existing web application. Can you do that with a google spreadsheet?
LVL 111

Expert Comment

by:Ray Paseur
ID: 34172737
I never tried integrating anything Google into another site, except for Google Search -- and that worked great.  But as far as a skin for the look and feel of another site, I do not know.  There might be a paid option without ads or something like that.
LVL 31

Author Comment

ID: 34211721
I think I may end up going with the jqGrid option, looking into it more I think I can store the data in JSON format. I'll just have to add my own facilities for adding/removing columns.

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question