Newbie question - can't figure out xsl
-
I've tried to figure this out myself. I want to import XML data from webpage, strip the data from the 'report' div not the 'menu' div, and save as an M$ Office XML 2003 spreadsheet. I've looked at a couple of tutorials w3c and devguru, but to no avail! If I could get it, my worthless code at the bottom of this post, to display the cell data and stop 'up chucking' (displaying) the original xml, I might get somewhere! Please help!! Thanks in advance for any help to get me started. Clueless. My source is a webpage which I download with wget looks like this: <code> <?xml version="1.0" encoding="utf-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head><link rel="stylesheet" type="text/css" href="style/body.css" /> <link rel="stylesheet" type="text/css" href="style/menu.css" /><link rel="stylesheet" type="text/css" href="style/report.css" /> <meta http-equiv="Content-type" content="text/html;charset=UTF-8" /><title>Report</title></head> <body><div id="menu"> <ul id="nav"><li><a href="?d=dia">dia</a></li> <li class="activelink"> <li><a href="?d=oth">Other</a></li> <li><a href="?d=all">All</a></li> </li></ul></div> <div id="report"><table id="filter"><tr><td><b>Showing all systems</b></td></tr><tr><td><hr /></td></tr> <tr><td>Show only systems verifed within past: <a href="/ci/rep_browsers1.asp?d=dia&z=1">1</a>|<a href="/ci/rep_browsers1.asp?d=dia&z=3">3</a>|<a href="/ci/rep_browsers1.asp?d=dia&z=7">5</a>|<a href="/ci/rep_browsers1.asp?d=dia&z=7">7</a>|<a href="/ci/rep_browsers1.asp?d=dia&z=14">14</a>|<a href="/ci/rep_browsers1
-
I've tried to figure this out myself. I want to import XML data from webpage, strip the data from the 'report' div not the 'menu' div, and save as an M$ Office XML 2003 spreadsheet. I've looked at a couple of tutorials w3c and devguru, but to no avail! If I could get it, my worthless code at the bottom of this post, to display the cell data and stop 'up chucking' (displaying) the original xml, I might get somewhere! Please help!! Thanks in advance for any help to get me started. Clueless. My source is a webpage which I download with wget looks like this: <code> <?xml version="1.0" encoding="utf-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head><link rel="stylesheet" type="text/css" href="style/body.css" /> <link rel="stylesheet" type="text/css" href="style/menu.css" /><link rel="stylesheet" type="text/css" href="style/report.css" /> <meta http-equiv="Content-type" content="text/html;charset=UTF-8" /><title>Report</title></head> <body><div id="menu"> <ul id="nav"><li><a href="?d=dia">dia</a></li> <li class="activelink"> <li><a href="?d=oth">Other</a></li> <li><a href="?d=all">All</a></li> </li></ul></div> <div id="report"><table id="filter"><tr><td><b>Showing all systems</b></td></tr><tr><td><hr /></td></tr> <tr><td>Show only systems verifed within past: <a href="/ci/rep_browsers1.asp?d=dia&z=1">1</a>|<a href="/ci/rep_browsers1.asp?d=dia&z=3">3</a>|<a href="/ci/rep_browsers1.asp?d=dia&z=7">5</a>|<a href="/ci/rep_browsers1.asp?d=dia&z=7">7</a>|<a href="/ci/rep_browsers1.asp?d=dia&z=14">14</a>|<a href="/ci/rep_browsers1
No one is going to look at this mess of unformatted garbage.
I know the language. I've read a book. - _Madmatt
-
I've tried to figure this out myself. I want to import XML data from webpage, strip the data from the 'report' div not the 'menu' div, and save as an M$ Office XML 2003 spreadsheet. I've looked at a couple of tutorials w3c and devguru, but to no avail! If I could get it, my worthless code at the bottom of this post, to display the cell data and stop 'up chucking' (displaying) the original xml, I might get somewhere! Please help!! Thanks in advance for any help to get me started. Clueless. My source is a webpage which I download with wget looks like this: <code> <?xml version="1.0" encoding="utf-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head><link rel="stylesheet" type="text/css" href="style/body.css" /> <link rel="stylesheet" type="text/css" href="style/menu.css" /><link rel="stylesheet" type="text/css" href="style/report.css" /> <meta http-equiv="Content-type" content="text/html;charset=UTF-8" /><title>Report</title></head> <body><div id="menu"> <ul id="nav"><li><a href="?d=dia">dia</a></li> <li class="activelink"> <li><a href="?d=oth">Other</a></li> <li><a href="?d=all">All</a></li> </li></ul></div> <div id="report"><table id="filter"><tr><td><b>Showing all systems</b></td></tr><tr><td><hr /></td></tr> <tr><td>Show only systems verifed within past: <a href="/ci/rep_browsers1.asp?d=dia&z=1">1</a>|<a href="/ci/rep_browsers1.asp?d=dia&z=3">3</a>|<a href="/ci/rep_browsers1.asp?d=dia&z=7">5</a>|<a href="/ci/rep_browsers1.asp?d=dia&z=7">7</a>|<a href="/ci/rep_browsers1.asp?d=dia&z=14">14</a>|<a href="/ci/rep_browsers1
Did you bother to preview this before you posted it, or read it afterwards? I assume not as it is unreadable. Please edit the content and place between <pre></pre> tags using the "code block" button at the top of the edit window.
MVP 2010 - are they mad?