Solved

Excel read

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

I wanna read a Excel sheed, can I do that in HTML ?
0
Comment
Question by:win32
[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
  • 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 10 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

Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

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 . Websites are getting bigger and more complicated by the day. Video, images and custom fonts are all great for showcasing your product or service. But the price to pay in…
In this tutorial viewers will learn how to style transparent/translucent elements using alpha transparency in CSS Start with a normal styled element, such as a div.: Define its "background-color" property as "rgba (255, 255, 255, .5): The numbers in…
HTML5 has deprecated a few of the older ways of showing media as well as offering up a new way to create games and animations. Audio, video, and canvas are just a few of the adjustments made between XHTML and HTML5. As we learned in our last micr…

688 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