Solved

Excel read

Posted on 2001-06-24
4
218 Views
Last Modified: 2010-04-09
Hi

I wanna read a Excel sheed, can I do that in HTML ?
0
Comment
Question by:win32
  • 2
4 Comments
 
LVL 17

Expert Comment

by:dorward
Comment Utility
You can make a link to <a href="some-work-book.xls">Some Work Book</a>.

Assuming that the end user has a program that can read xls files and that said program is asociated with the xls file entension then the file will be displayed, or a prompt to download it shown.

You can not use HTML to link to a specific part of the workbook, not you you use HTML to convert the workbook in to a table.

With some server side programs you might be able to generate data based on the workbook but you would be much much better off using a database (e.g. mySQL or Microsoft SQL server) as those programs are designed to do that job.
0
 
LVL 1

Accepted Solution

by:
Ernest022699 earned 10 total points
Comment Utility
dorward is correct that the most portable way to display the data is by exporting it to an HTML table.  Don't even think of referencing the Excel spreadsheet directly.  You must keep in mind that not all your users may have Excel or even Micro$oft products.

You could either do a "File ... Save As" in Excel or write a VBA program to export the data in a better (i.e., tagged) format.
0
 

Author Comment

by:win32
Comment Utility
Sure, and I don't seem to get why is it that Microsoft does'nt support a better HTML generator for there .xml sheets ?

-- Aniwayes thanks for the comments on my question
CB
0
 
LVL 1

Expert Comment

by:Ernest022699
Comment Utility
win32:  Thank you for the high grade and the points!

My best suggestion is to export the Excel data in Comma Seperated Variable (.csv) format and then import those data into an HTML document.  Or you could even create the HTML file via a VBA macro within Excel.

The most important thing to remember is portability.

Good luck!
0

Featured Post

IT, Stop Being Called Into Every Meeting

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!

Join & Write a Comment

Deprecated and Headed for the Dustbin By now, you have probably heard that some PHP features, while convenient, can also cause PHP security problems.  This article discusses one of those, called register_globals.  It is a thing you do not want.  …
Do you want to insert HTML5 video into your site? This is the tutorial how to do so. What are the main advantages of HTML5 video? 1) Have good compression, good image quality, and low decode processor use. 2) It is royalty-free 3) It is easi…
In this Micro Tutorial viewers will learn how to create navigation buttons that change on rollover, using CSS (Continuation of the CSS Image Sprite tutorial) Create a parent ID for all the list items       - Specify position: absolute and display: block…
In this tutorial viewers will learn how to position overlapping items using z-index in CSS. They will also learn the restrictions on the z-index property.  Create a new HTML document with an internal stylesheet.: Create a div in CSS and name it Red.…

744 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

17 Experts available now in Live!

Get 1:1 Help Now