|
HTML - Conversing An Html Data To Xls
Hi All,
I've a issue in converting html file into xls,txt. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8"> <title>Data</title> <script type="text/javascript" src="sorttable.js"></script> <style type="text/css"> a.hidecolumn { cursor:pointer; text-decoration:none; font-weight:lighter; } a:hover.hidecolumn { color:red; } table.sortable a.sortheader { background-color:#e0e0e0; color:#666666; font-weight: bold; text-decoration: none; display: block; } table.sortable th {background-color:#e0e0e0;} table.sortable span.sortarrow { color: black; text-decoration: none; } </style></head> <body> <H1>Checks</H1> <H2> Checks</H2><table id="Checks" border="1" cellpadding="2" cellspacing="0" class="sortable"><tr class="sortheaderrow"><td valign="top" align="left">Table name</td><td valign="top" align="left">Check name</td><td valign="top" align="left">Description</td><td valign="top" align="left">SQLString</td></tr> <tr> <td><a href="party_0-length _1.html">SELECT COUNT(*) FROM (SELECT 1 as one FROM party WHERE LENGTH(ID) = 0 OR LENGTH(NUMBER) = 0 OR...</a></td> </tr> If you see the line href="party_0-length _1.html">SELECT COUNT(*) FROM (SELECT 1 as one FROM party WHERE LENGTH(ID) = 0 OR LENGTH(NUMBER) = 0 OR... It has a part of the data prefixed with the href. If I click the href I can get the complete data. When I tried to convert the data to XLS I'm getting the truncated data. Please help me Similar TutorialsThis is what I need: User opens HTML file---->data from XML file is displayed in order in HTML file This is my problem: User opens HTML file----> Only the heading "current log" and "tstamp" and "entry" are displayed I took the HTML and SXL from http://www.w3schools.com/xsl/xsl_client.asp HTML: Code: <html>
<body>
<script type="text/javascript">// Load XML
var xml = new ActiveXObject("Microsoft.XMLDOM")
xml.async = false
xml.load("CurrentLog.xml")// Load XSL
var xsl = new ActiveXObject("Microsoft.XMLDOM")
xsl.async = false
xsl.load("CurrentLog.xsl")// Transform
document.write(xml.transformNode(xsl))
</script>
</body>
</html>
XML: Code: <?xml version="1.0" standalone="yes" ?> - <IncrepDataset xmlns="http://tempuri.org/IncrepDataset.xsd"> - <Control> <Control_ID>0</Control_ID> <Name>DocViewer</Name> <Filename>docviewer.dll</Filename> <Icon>doc</Icon> <IncrepLoadable>true</IncrepLoadable> <Version>4.0.0.28546</Version> <TStamp>2006-11-06T18:00:09.4160070-06:00</TStamp> </Control> - <Control> <Control_ID>-1</Control_ID> <Name>RIDS</Name> <Filename>ridswrapper.dll</Filename> <Icon>tool</Icon> <IncrepLoadable>true</IncrepLoadable> <Version>4.0.0.28559</Version> <TStamp>2006-11-06T18:00:32.8518090-06:00</TStamp> </Control> - <Control> <Control_ID>-2</Control_ID> <Name>Explosives</Name> <Filename>atfwrapper.dll</Filename> <Icon>tool_bomb</Icon> <IncrepLoadable>true</IncrepLoadable> <Version>4.0.0.28559</Version> <TStamp>2006-11-06T18:01:01.2952610-06:00</TStamp> </Control> - <Control> <Control_ID>-3</Control_ID> <Name>ChecklistViewer.Bomb Response</Name> <Filename>checklistwrapper.dll</Filename> <Icon>tool_checklist</Icon> <IncrepLoadable>false</IncrepLoadable> <Version>4.0.0.28559</Version> <TStamp>2006-11-06T18:01:21.5461976-06:00</TStamp> </Control> - <DataType> <Datatype_id>1</Datatype_id> <name>String</name> <description /> </DataType> - <IncidentLog> <IncidentLog_ID>-10</IncidentLog_ID> <TStamp>2006-11-06T18:01:26.7541536-06:00</TStamp> <Entry>- 'COMMENCE IED SOP/ERG ACTIONS. GATHER ALL INFO.' checked</Entry> <AddedByUser>false</AddedByUser> <submission_id>0</submission_id> <Priority>Low</Priority> <Control_ID>-3</Control_ID> </IncidentLog> - <IncidentLog> <IncidentLog_ID>-11</IncidentLog_ID> <TStamp>2006-11-06T18:01:26.8142454-06:00</TStamp> <Entry>- 'SET INITIAL EXCLUSION AREA.' checked</Entry> <AddedByUser>false</AddedByUser> <submission_id>0</submission_id> <Priority>Low</Priority> <Control_ID>-3</Control_ID> </IncidentLog> - <IncidentLog> <IncidentLog_ID>-12</IncidentLog_ID> <TStamp>2006-11-06T18:01:26.8943678-06:00</TStamp> <Entry>- 'MAKE ALL NOTIFICATIONS.' checked</Entry> <AddedByUser>false</AddedByUser> <submission_id>0</submission_id> <Priority>Low</Priority> <Control_ID>-3</Control_ID> </IncidentLog> - <IncidentLog> <IncidentLog_ID>-13</IncidentLog_ID> <TStamp>2006-11-06T18:01:26.9644749-06:00</TStamp> <Entry>- 'IDENTIFY ON-SCENE COMMAND (OSC)/ COMMAND POST (CP) LOCATION.' checked</Entry> <AddedByUser>false</AddedByUser> <submission_id>0</submission_id> <Priority>Low</Priority> <Control_ID>-3</Control_ID> </IncidentLog> - <IncidentLog> <IncidentLog_ID>-14</IncidentLog_ID> <TStamp>2006-11-06T18:01:38.6222841-06:00</TStamp> <Entry>Incident Summary selected</Entry> <AddedByUser>false</AddedByUser> <submission_id>0</submission_id> <Priority>Low</Priority> </IncidentLog> </IncrepDataset> XSL: Code: <?xml version="1.0" encoding="ISO-8859-1"?>
<!-- Edited with XML Spy v2006 (http://www.altova.com) -->
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method='html' version='1.0' encoding='UTF-8' indent='yes'/>
<xsl:template match="/">
<html>
<body>
<h2>Current Log</h2>
<table border="1">
<tr bgcolor="#9acd32">
<th align="left">TStamp</th>
<th align="left">Entry</th>
</tr>
<xsl:for-each select="tstamp/entry">
<tr>
<td><xsl:value-of select="TStamp"/></td>
<td><xsl:value-of select="Entry"/></td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
I have two other versions of the HTML file that don't require XSL but they only half work. One displays everything I want but not in the right order the other displays in the right order but only displays the first TStamp and Entry. Hi, I have a situation where I have to transfer some data (from a text area in the first page, on submit) to the second page. Both the pages should be strictly in HTML. Is there any way to do it? I understand that we cannot receive any data from a Form unless we use a server side language. I am a newbie to HTML.. and would greatly appreciate any help.. Thanks! Hello, wondering if someone can help me on the following: I am trying to convert a list of links over 350 collected over the years into html. The data is in text in the following format, <link title> "/" <actual http link> "/" <description> I could type each link into html but there is got to be a way to do it automatically.. since it is already formated in a text file with a clearly defined delimiter. Any ideas?? Thanks in advance for any ideas. Hi everyone I'm new to this forum and I have a question. I need to create an input form that asks users for a zip code. Once they type in their zip code and hit submit I need to take their zip code and put it in the URL. EX. if 12345 was typed, after they hit submit it would take them to "www.example.com/12345" Does this make sense? hi, I had created a form using html.Can i collect all the data tht key in by the user at the form to .txt file? can ths be done by php or html? Can u please guide me step-by-step? Thanks in advance. Hi My problems: Q1: I am getting data from mySQL to populate fields to generate a report in html. The report are in two pages. Sometimes page two comes into page one. is there a way we can force page two to be only in page two. Q2: If I am printing only 1 page report, is there a way to force print (without changing print setting to print) into one page. Thanks Siva Hello, Sam here. Hope we are doing great. The sole reason i joined this forum is to learn more about HTML < Obvious. I am working on a code which requires me to convert a static html form data feeded/recorded by a user to save to a excel file. i have seen many examples of this using jscript or vbscript. Can someone walk me through this. e.g. html form contains 2 feilds name and place and a submit button. when you click submit button i want the values in the feilds say f1 and f2 to be saved to excel rows. Again i make changes to name and place and hit submit i need the same file appended with the next set of values by user. i appreciate your help. please comment on all functions or calls which saves form data to excel. I am ok with html not this stuff. Regards, Sam Hello I have some preexisiting html pages in which I want to populate some tags with data read from an xml file. ..What is the best pssible way to do so? The data changes every week. I am OK with running a javascript which imports the xml data into html and then just use those static html pages. But how will this work? I am new to this client side stuff and hence the questions. Any pointers will be greatly appreciated. Thx Hello guys, Not sure if this is the right board to post this one, but I need some help. I'm trying to carry over a field of numbers from one form to another. However, with the code, only some of the numbers show up. It's easier if i post the code here. Code:
post.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>post</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"/>
<script type="text/javascript">
//<![CDATA[
function checkSelect() {
var df=document.forms[0][0];
if(df.options[df.selectedIndex].value=='') {
alert('Please enter a valid phone number');
return false;
}
}
//]]>
</script>
</head>
<body>
<form action="post1.htm" name="Phone" enctype="multipart/form-data" method="get" onsubmit="return checkSelect()">
<Input type=text value="Phone" name="" size="20">
<input type="submit" target="blank" value="Submit"/>
</form>
</body>
</html>
and the page that the numbers should carry over to: Code:
post1.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>post1</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"/>
<script type="text/javascript">
<!--
function addInfo() {
document.forms[0][0].value=parent.location.search.substr(6);
}
onload=addInfo;
//-->
</script>
</head>
<body>
<form action="#">
<input type="text"/>
</form>
</body>
</html>
Can someone please tell me what I'm doing wrong? Cheers! Hi Everyone I have a problem with my form in that I have an html page with a dropdown list. I need the value selected to be passed to another html file. However I need this done with html and not javascript/css/asp etc. As an e.g. of what I have: <form name="connect" action="trace.php" method="get"> <select name="sites"> <option selected option value="http://www/connect.php">Choose A Site</option> <option value="http://10.20.12.50" name="Site1">Site1</option> <option value="http://10.20.12.55" name="Site2">Site2</option> <option value=http://10.20.12.40" name="Site3">Site3</option> </select> <br><br> <input type="Submit" value="Traceroute"> </form> So if the user selects site2 I need the name (or value) from the option field sent to trace.php and from the trace.php website i need to retrieve the value selected from the above. Can someone please help me by telling me how to do this? At the moment I cannot retrieve the value from the trace.php site. I have used $_POST & $_GET, but neither seem to work and I am not sure what I am doing wrong. TIA Hi guys, I'm new to this forum and fairly new to html I've been asked to create a webpage for work that is pretty much an on-line diary for where plant & equipment has been. I have done all the easy stuff, but I don't know if it's possible to display and save input in a cronological order as a list. Is it possible to simply use html code and get this task done? To be more specific, the user can enter the arrival and deparature date of equipment, which i need to be displayed and saved. Any help will be greatly appreciated, and please keep in mind that I have limited knowledge with html code and JS. Regards, Daniel. any1 knows how to add and remove data into/from html list at runtime Dear all, May I have sulotion to solve my problem in: I have one of web page product_A.html. It have product information and the price. May I link with xls(price_list.xls) to update the product price with out edit the html each time? It is better with out .net/ php/ Java ..etc May I use html only to do that? product_A.html and price_list.xls save it web server do not support MYSQL / MSSQL current I need chage it each time: http://www.nova-etrade.com/allpmp.html Thank you very much. Hi all, I have an HTML SELECT on my page, the default size with which it shows fields in the drop down is too large for my page. Do you know a way for me to make the text in the drop down fields smaller? Is there a good css I can use as the style? Thanks, Jehan I have a html table that contains data and i want to insert the data into an Access database. Any ideas how to do this? Table1: 01, Rich, Mike, 23, fred lane, 02, James, milner, 45, School Lane, 03, Rob, Matthews, 89, College Road, I connect to the database using this code: $db_conn = new COM("ADODB.Connection"); $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("./Database1.mdb").";"; $db_conn->open($connstr); Hi Experts, I am designing a webpage where based on the year selection the associated years webtable needs to be displayed in the webpage. Pls give som suggestions and if possible the code on to how to code this using HTML and Jav Script. I know I have to write afunction and then call the fn based on the input.but need your help on this. Thanks, Bsquare So I've got a form with some input text. In addition to the data in the input text I want to send some other data that has already been predetermined on initial page load. How would I declare the other data within the form element? Thanks I have been using my site for some time now and it carries the image name over when you clicked on purchasing the print. It carries it still, but when you submit the form, the image name isnt there and the form errors because the field is blank. Here is the site: www.sthompsonphoto.com I cant seem to figure out why it disappears when you click Submit? Any help would be great! Hi everybody! I have a jsp page with a form and a table. My aim is that when i press the submit button of the form,collect the data and fill the table with it. I am working with J2EE. I have already collected the data in a Java class,but I dont know how to introduce this data into the table. Best Regards! |
|||||||