Solved

Display an excel spreadsheet on a web page

Posted on 2006-11-09
3
331 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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
This article discusses four methods for overlaying images in a container on a web page
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
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…

772 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

16 Experts available now in Live!

Get 1:1 Help Now