PHP/Javascript based spreadsheet editor library

Posted on 2010-11-17
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 500 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 110

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.
Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

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 110

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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

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…
This article explains how to prepare an HTML email signature template file containing dynamic placeholders for users' Azure AD data. Furthermore, it explains how to use this file to remotely set up a department-wide email signature policy in Office …
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…

726 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