[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Excel read

Posted on 2001-06-24
4
Medium Priority
?
227 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
ID: 6222933
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 40 total points
ID: 6226318
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
ID: 6265377
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
ID: 6266366
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When it comes to write a Context Sensitive Help (an online help that is obtained from a specific point in state of software to provide help with that state) ,  first we need to make the file that contains all topics, which are given exclusive IDs. …
Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…
Suggested Courses

591 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