Solved

Display an excel spreadsheet on a web page

Posted on 2006-11-09
3
344 Views
Last Modified: 2011-10-03
Hi, I've been researching this but haven't gotten a lot of solutions in PHP. I would like to know how to display an excel spreadsheet on a web page, just display it. The users don't need to change information, just view it. There are several documents that are posted around the department, and I would like to place them on the Intranet for consulation purposes. The web page was created using PHP and MySQL. It resides on a Linux box running Fedora 5 and Apache. Any ideas will be appreciated. Thanks!
0
Comment
Question by:horalia
3 Comments
 
LVL 16

Assisted Solution

by:HackneyCab
HackneyCab earned 250 total points
ID: 17911127
Other than using Excel to save the document as an HTML file,

http://office.microsoft.com/en-us/help/HP052561501033.aspx

I don't fancy your chances.

Possibly there exists an ActiveX control that acts as an Excel viewer, and possibly that ActiveX control could be embedded in a web page. But if such a thing exists, I'm betting it would either be very expensive, totally flaky, or both. Microsoft were never keen on people writing third-party apps for their data formats, so support tends to be a bit patchy for non-basic features.

If it's purely tables of numbers you'd want to share, you may be able to export Excel documents as a text-based format, such as CSV, and then write a PHP script that parses the data to produce HTML tables. But graphs would mean more work still.
0
 
LVL 48

Accepted Solution

by:
hernst42 earned 250 total points
ID: 17912781
If you want .xls files to display you can use http://chicago.sourceforge.net/xlhtml/ to convert and display xls-files as HTML. Its not a php-solution but gives good quality. Else you can try http://sourceforge.net/projects/phpexcelreader
0
 

Author Comment

by:horalia
ID: 17999525
I will divide the points between both answers, I haven't had a chance to look at either, but I hate leaving questions opened for a long time.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
calculated column 12 74
Calculate values in an array 18 33
Is this error or Notice in php error log? 6 32
html input type 3 22
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit (http://en.wikipedia.org/wiki/PHPUnit) and similar technologies have enjoyed wide adoption, making it possib…
The viewer will learn how to count occurrences of each item in an array.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

910 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

21 Experts available now in Live!

Get 1:1 Help Now