?
Solved

Display an excel spreadsheet on a web page

Posted on 2006-11-09
3
Medium Priority
?
385 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
[X]
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 Comments
 
LVL 16

Assisted Solution

by:HackneyCab
HackneyCab earned 1000 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 1000 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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…
This article discusses how to implement server side field validation and display customized error messages to the client.
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 look for a specific file type in a local or remote server directory using PHP.
Suggested Courses

762 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