Solved

PHP/Javascript based spreadsheet editor library

Posted on 2010-11-17
6
941 Views
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.

0
Comment
Question by:Frosty555
  • 3
  • 2
6 Comments
 
LVL 13

Accepted Solution

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

http://www.trirand.com/blog/

The site have a lot of examples to check.

http://www.trirand.com/blog/jqgrid/jqgrid.html



0
 
LVL 31

Author Comment

by:Frosty555
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.
0
 
LVL 108

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.
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 31

Author Comment

by:Frosty555
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?
0
 
LVL 108

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.
0
 
LVL 31

Author Comment

by:Frosty555
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.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
In this tutorial viewers will learn how to code links for mobile sites that, once clicked, send a call or text to a specified number. For a telephone link (once clicked, calls a number), begin with a normal "<a href=" link tag. For the href, specify…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

746 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now