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
Solved

Excel read

Posted on 2001-06-24
4
221 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 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

Suggested Solutions

Title # Comments Views Activity
Sort Order Icons on HTML Table 3 33
Media Queries  not Firing 6 17
simple html dom php accessing table/cell  values 4 18
Bootstrap 3 - Style a dropdown 1 11
Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
This article explains how to prepare an HTML email signature template file containing dynamic placeholders for users' Azure AD data. Furthermore, it explains how to use this file to remotely set up a department-wide email signature policy in Office …
In this tutorial viewers will learn how to embed Flash content in a webpage using HTML5. Ensure your DOCTYPE declaration is set to HTML5: "<!DOCTYPE html>": Use the <object> tag to embed Flash content.: To specify that the object is Flash content, d…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

808 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