473,320 Members | 1,909 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Excel's XML to HTML using data islands

Hi All

Anyone came across this problem before?

I have an X<L file created by excel

<xml id="model">

<root>
<Row>
<Cell><Data ss:Type="String">EQUATION</Data></Cell>
<Cell><Data ss:Type="String">COEFFICIENT</Data></Cell>
<Cell><Data ss:Type="String">Gllamm</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String">ppi</Data></Cell>
<Cell><Data ss:Type="String">Constant</Data></Cell>
<Cell><Data ss:Type="String">0.160***</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String">(0.0054)</Data></Cell>
</Row>
</root>

And I know ingeneral how to use data islands to display the contents of the XML
in a html table and it works fine.
<table border="1" datasrc="#cdcat">
<tr>
<td><span datafld="Cell"></span></td>
</tr>
</table>

The problem with an excel created XML file is that values are all labeled "Cell"
whereas in most other regular XML, the individual values have their own label:
Cell1 and Cell2.
So my code works if each 'Row' has only one 'Cell'. But I want to use the html
code shown above repeatedly reading out each cell from a row, just as it does
read out and displays each row from the 'root' automatically.

Problem is, I cant change the XML, it machine generated and not under my control.

Thanks for any response.

Toby

Jul 7 '06 #1
4 1575
On Fri, 07 Jul 2006 16:07:45 -0700, to*****@hotpop.com wrote:
>Anyone came across this problem before?
Yes, when you posted it to c.i.w.a.h

You were told how to do it right then, and you're still insisting you
know better. Good luck.
Jul 8 '06 #2
Andy Dingley wrote:
On Fri, 07 Jul 2006 16:07:45 -0700, to*****@hotpop.com wrote:

>>Anyone came across this problem before?


Yes, when you posted it to c.i.w.a.h

You were told how to do it right then, and you're still insisting you
know better. Good luck.

You guys are pretty assumptious. How do you know that I can do what you
suggested? You are changing the 'givens'. Its like you have a math problem and
you suggest to change the task in order to solve it. Very smart of you guys.

The XML file is a given. It is machine generated and not under my control. Maybe
you did not work on large scale projects where the data to be displayed (XML) is
generated automatically and you have to find a way around how to display it.

Good luck with your assumptiousness.
Jul 9 '06 #3
to*****@hotpop.com wrote:
You guys are pretty assumptious.
One person has responded and you're already throwing names at everyone?
Not a good way to make folks want to help you.

I haven't attempted to use data islands, so I can't advise on whether
they can do what you want or not... but if they can't, they're too
broken to be interesting and you should consider a different technology,
eg more explicit scripting or server-side transformation.
--
() ASCII Ribbon Campaign | Joe Kesselman
/\ Stamp out HTML e-mail! | System architexture and kinetic poetry
Jul 9 '06 #4
Joe Kesselman wrote:
to*****@hotpop.com wrote:
>You guys are pretty assumptious.


One person has responded and you're already throwing names at everyone?
Not a good way to make folks want to help you.

I haven't attempted to use data islands, so I can't advise on whether
they can do what you want or not... but if they can't, they're too
broken to be interesting and you should consider a different technology,
eg more explicit scripting or server-side transformation.

Hi Joe, maybe you didnt follow the conversation cross listed in another newsgroup.
Jul 10 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: brianberlin | last post by:
I've been working on this website that uses this to display a catalog. http://www.w3schools.com/xml/tryit.asp?filename=cd_catalog_island I just figured out that it is only working on IE for...
2
by: Chris | last post by:
Im hoping someone can help me understand why this works? Requirement: Navigate DOM through javascript to perform DHTML actions. Issue: GIANT html document, up to 4MB in size, thousands and...
5
by: KathyB | last post by:
If someone could just explain this to me...I just don't get it! I have an aspx page where I retrieve several session variables and use xmlDocument to transform xml file with xsl file into an...
27
by: Alan Searle | last post by:
I currently use the MS-Access automatic report converter to throw some of my reports out as HTML. That works OK but often the report's layout is distorted and I would like to improve this. ...
4
by: Jae | last post by:
I'm writing a web application that exports and imports excel files. The application gets a list of users and their info and displays it in a datagrid .The user then selects to save the file as a...
14
by: pmud | last post by:
Hi, I need to use an Excel Sheet in ASP.NET application so that the users can enter (copy, paste ) large number of rows in this Excel Sheet. Also, Whatever the USER ENETRS needs to go to the...
22
by: Ubi | last post by:
I am looking for a list of countries and nationalities, against the top level domain. es: ..ar ==Argentina ==Argentinian ..al ==Albania ==Albanian etc. etc.
3
by: toffee | last post by:
Hi all, I got a pre-formatted spreadsheet. would it be possible using js to copy the data from a table on the current webpage, open the spreadsheet and paste the content ? if so, anyone got any...
3
by: sejal17 | last post by:
hello Can any one tell me how to read multiple worksheets from a single excel file.I have stored that excel in xml file.so i want to read that xml that has multiple worksheet.And i want to store...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.