Google Answers Logo
View Question
 
Q: Excel's XML in HTML eventually using data islands ( No Answer,   1 Comment )
Question  
Subject: Excel's XML in HTML eventually using data islands
Category: Computers > Programming
Asked by: toby909-ga
List Price: $15.00
Posted: 14 Jul 2006 17:27 PDT
Expires: 13 Aug 2006 17:27 PDT
Question ID: 746461
Hi

I was wondering how I can embed an XML file created by excel into a
html. w3schools describes it for an XML file, and I am able to do
their method, except with XMLs that come from excel. This is probably
due to the fact that the lowest level data's ID is the same for all.
Ie each datavalue in an excel XML is IDed 'Cell', whereas in more
common XML files each value has a different dataid (as seen in the w3
examples). The examples below do not require one to know how many rows
there are in advance. I also would need this feature for columns. The
xml file that comes from excel cannot (in my problem there are
actually hundreds of them) be modified, since it is machine generated
and not under my control. With data islands, the solution then need
not be compatible with firefox, since data islands is MS IE's thing,
but a solution with higher compatibility, even not necessarily
including data islands is welcome too, although I do not want to have
a 'script' solution.
I previously tried it with CSS, if you have access to newsgroups, its
posted in comp.infosystems.www.authoring.html on 7/5/06.

Thanks

http://www.w3schools.com/xml/xml_data_island.asp
http://www.w3schools.com/xml/xml_applications.asp
Answer  
There is no answer at this time.

Comments  
Subject: Re: Excel's XML in HTML eventually using data islands
From: njovin-ga on 04 Aug 2006 17:25 PDT
 
To put it simply, you CAN'T do it without scripting.

WITH scripting (javascript, or server-side), it woud be very easy,
you'd just need to write some parsing to strip all the proprietary
stuff out of the excel file and display just the raw content in an XML
data island.

I don't know of any way to do find/replace (espcially of the complex
nature needed to clean up an XML doc) with CSS.

Why are you opposed to scripting the solution?

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy