How to link a xls or xml file to a web page?

Hi!

I'm making a web page that needs daily updating of pictures (stock charts), and a table of numbers & text.

I would like to just update an xls or xml file, to make the site possible to maintain on a daily basis.
I use Frontpage now, and the only option I have tried is to insert an office component; the spread sheet. But this only works with Internet Explorer. I also want it to work with firefox.

Please: Any suggestions or alternative methods?

Also, is there any specific html programs that makes regular updating easier?

simen041200Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ecc204Commented:
Read the xml at the server and render it as pure html to the client.
simen041200Author Commented:
ecc204: Thanks for your reply!
I must clarify that i have very little knowledge of html-coding, allthough I have done some basic html, c, c++ and java before. Are you able to describe more directly how I do this? Can it be done by a function, or must i hard code it?
ecc204Commented:
You can, but do not need to, use Microsoft's XML family of API's.  Those would require hard-coding and knowledge of COM, too.

You would need to do some scripting.  I think the following article is right on point.

Create Dynamic HTML Forms with ADO, XML and XSL
at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnasdj01/html/asp0152.asp

Great ASP.NET Reports May be Easier Than You Thought!
at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnhcvs03/html/vs03g9.asp

If these are not enough, you can look at Chapter 13 of ASP.net Unleashed, starting at p. 656.

I guess we know how you are spending this weekend.  Good luck.
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

simen041200Author Commented:
Hehe ... I liked the title  " ASP.NET .. Easier Than You Thought"   I don't even want to know the name :)

Is hard coding really the only way to display an excel file on web? Can it not be done by a simple link or insert feature? I thought maybe some other progams than Frontpage could have such a feature, but that Frontpage doesn't due to favorising of I.E..

What about saving the file as csv, can that be inserted without hard-coding?

God, I live in Norway, summer is not that long... :)
ecc204Commented:
The first article I sent you is not that technical.  Also the ASP.net book simply describes how to use a .net component by using simple scripts.   I believe if you give it 2 hours, you will master the way of doing it.  It would be well worth the effort.  I do not believe that FrontPage would do the magic any easier.  The trick is that some component must be able to read the xml according to some rules that you will supply thru scripting.

So, here are my words of encouragement, give up 2-3 hours of your time, pull up your sleeves, and jump right into it.  You would be glad you did.
simen041200Author Commented:
Ok then... I just wanted to know the easiest way. If that is ASP, then so be it. The server I use doesn't even support ASP I just found out. But thats ok.. I will do what I have to do.

But I don't believe that I have to hard code ASP if I don't want to. I'm just doing the most basic thing, to display a part of a spreadsheet. There gotta be visual design programs for this...?  And maybe also a free one?

Any suggestions for a free web-host offering ASP support?
simen041200Author Commented:
And thanks for your suggestions ecc204, and for the encouraging part! :) Not that I'm lazy, I just have made kind of a principle not to do programming any more. Cause it usually gets very time consuming, cause I want to know more and more functions the longer I proceed. Oh, maybe I will cave in.. We will see..    

I will take a break, be back later.

Any further comments are welcome, please!
DevastatedCommented:
Hiya,

have you tried fiddling with the spreadsheet program? (excel maybe?) does it output in html ? most do nowadays...

therefore perhaps the easiest thing would be to get to grips with the spreadsheet proggie to see whats available there first, e.g. excel allows a lot of manipulation via VBA VB for applications basically.

Hope this helps.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rkannan2000Commented:

You can better use the CSV (Comma Seperated Values) for storing the data/Table. you can directly write the data to a file
on your server and make your Webpage to read from the Text file...I think it will be easy for you to do....
ecc204Commented:
Well, this may be the answer:

ASP101.com has a short article about XML to HTML.  Here is the article and address

Update: Common Functions for Working with XML and XSL Files
at http://www.asp101.com/samples/xmlxsl.asp
simen041200Author Commented:
Devestated:  This was not a bad idea, I didn't think about it.. I've tried it now, and it seems like it's actually making some kind of xml script. So maybe this is ASP too. I will test it some more.

I really just need a very simple table of two rows in the top of my web-page. Even though my question was focused on linking, the clue is just to get a simple table display in an easy way. Where the main goal is quick and easy updating with as few mouseclicks as possible. And the ability to reflect my formatting changes of the spreadsheet directly without any further editing. Actually I'm considering the option to just use a macro to take a cropped screenshot of the spreadsheet rows, and FTP it to the server. That or some ASP solution.  I will see...  

But... for ASP: are there any free web hosters with ASP support.. ?

Also, does any1 have a tip on macro programs? good once or even free once if it exists... ?
simen041200Author Commented:
Thanks ecc204! Those links you post gives me a good starting point. I will read up on it if I chose this solution.
DevastatedCommented:
Perhaps i think what would be easier is to use a macro that suits you from here "A macro to make an HTML page from an Excel worksheet":- http://www.meadinkent.co.uk/xladvhtml.htm
there are examples which will allow you to build an entire web page using a simple macro.

or if you insist on xml there is an excellent macro available here that will allow you to "Export an Excel Worksheet to XML (Excel Macro)":- http://www.freevbcode.com/ShowCode.Asp?ID=1694

happy to help

sumo_the_catCommented:
Whaaat?!

You don't need a new web host or a new development platform or even (really) any programming!

When you look at a modern HTML (XHTML) document in a browser, you're looking at XML. You need to simply transform your XML into XHTML.

Why on earth has no one mentioned XSLT?
simen041200Author Commented:
sumo_the_cat:     That sounds interesting, but I don't know if my host accept it;

My current host does NOT support:  CGI-scripts, ASP, PHP, SSI, Java servlets or MySQL.  Kind of poor, but anyway, that's what I have atm. I don't mind changing web host, but it I want to go for a free host, since my site is so basic.

Just for your reference, here is a screenshot close to how I want it to look:
http://www.home.no/cbr929rr/example.jpg 
simen041200Author Commented:
It's ok to save my spreadsheet as html.. But I have troubles displaying it in a tight area. Cause if I make it to some sort of html file, I have 2 files to display. Frames does not work I think, cause I want the table to scroll up... Inline frame creates a high scrollbar which is also not desirable.
sumo_the_catCommented:
http://www.w3schools.com/xsl/

It's not a technology a web host needs to support; rather it defines a way of transforming XML documents which can be interpreted by modern browsers.

It is the correct solution to your problem, but the disadvantage is you will need you learn how to use it (or at the least find examples you can apply to your problem).

But obviously you'll need to be able to write some general html if you want you page to be laid out like this screenshot.

Sumo ;-))

sumo_the_catCommented:
simen041200Author Commented:
Well, still it creates in the end a xhtml file, which i have to display, and that gives me the same issues as described in my last post. My problem is to get it into the same single html file.. So its rather a layout problem at this point. To have 2 html files brings alot of trouble... at least I find it hard to keep a nice layout with it.
simen041200Author Commented:
If I just want to display a spreadsheet on a single page, then I can just save it as a web page, works fine. Don't need to do any XSL or similar for that...
sumo_the_catCommented:
What you're trying to do is create a dynamic web page which changes its contents based on an XML document. XSLT is the correct way to do this.

If it were just a matter of saving the speadsheet as a static html file, you wouldn't be asking this question, and there would be far fewer web developers in steady employent!
simen041200Author Commented:
Well don't focus too much on my initial question. That was just my first thought and might not be the best solution. I dont really need a true dynamic page.

The clue is what I want to display. The page will be updated manually about every day, with editing of pictures and text by opening the page in Frontpage, and manual FTP upload. So I just want to automate what can be automated. But I'm not turning into a web developer to achieve this 2-row table. Then I will just do a copy paste in stead.

Actually, with second thought, I will change my page layout, so I will get rid of the problem. I will just let the table be displayed through a link as a html page.

So thanks for all guidance to my question. Sorry for not picking up the solutions. But at least now I know where the limitations are, and can continue my work in a productive way with the knowledge of what options I have available.

I will close the thread later, making dinner..  :)
sumo_the_catCommented:
No probs; good luck with it - and have a nice dinner! Sumo.
simen041200Author Commented:
Hi again!

Sorry i've been away, I rushed on for vacation and forgot to close the post. Well, it got a bit confusing this thread, as I didn't really favor the method I initially asked about, so I'll split some points and hope its fair. Anyway, thanks to all who made posts, for helping and for making this such a great site!

Oh, btw: I ended up just using Excels web export feature.

Simen
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Networking

From novice to tech pro — start learning today.