Improve company productivity with a Business Account.Sign Up

x
?
Solved

PHP/Javascript based spreadsheet editor library

Posted on 2010-11-17
6
Medium Priority
?
987 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 2000 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 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.
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will receive an overview of the basics of CSS showing inline styles. In the head tags set up your style tags: (CODE) Reference the nav tag and set your properties.: (CODE) Set the reference for the UL element and styles for it to ensu…

589 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