HTML - Html To Display Xls / Csv Data Record Problem
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. 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. Hello, I am having problems to correctly format the following two pages: http://www.rapidsmtp.com/product.html http://www.rapidsmtp.com/support.html They are displayed correctly in Firefox, but IE 6.0 displayes the HTML part wider than the flash menu. Can please somebody advice how to fix this? Also, IE 6.0 sometimes stalls for a minute when displaying my webpage (Firefox does not have this problem). Does somebody observe the same problem or is it a problem of my computer's setup? Kind regards, Alex Hi there, I'm curious of how to code a fix display size of html files. If I were to set the size (when launching) as a monitor size 1024 x 768, which means users don't need to scroll up and down anymore. It will exactly fit into the screen. How should I go about doing it? Thanks and cheers........... hello. i have a table in HTML (made with Dreamweaver) with some text in one row. when i browse it with IE the text is where I putted it but with Netscape the text is much lower. before the text i have one colored column (widith 2 pixels), in IE it is visible correct but with Netscape Navigator it is missing. only if i incrase the widith i can see it with Netscape. Can somebody help me solve this problems? Thank You in advance. Hi, I am very, very new to XML and I am not able to get my .xsl data file to read into the table in my .xsl file. Thank you, kriscann Greetings everyone. I have a form which i use to send information to one of our partners via POST. What the partner then returns is an XML response that looks like: Code: <?xml version="1.0" encoding="utf-8"?> <SendSMSResponseType xmlns="https://partnersite.com/"> <ServiceResult>ACCEPTED or MESSAGE_TOO_LONG or INVALID_CREDENTIALS or REJECTED or NOTFOUND</ServiceResult> <SequenceNumber>int</SequenceNumber> </SendSMSResponseType> what i want to do is have the form posted to an iframe in my site, and then return just the ServiceResult (or another message depending on what the ServiceResult is...), but i'm not certain how to do that. i have it posting to the iframe just fine, but it just displays the XML - which isn't very user friendly... How can i format their response, or parse their response and display my own message? I've got PHP and AJAX already happening on the page, so using either one is a possibility, i just don't know where to even start for some reason... Hi I need some help re drop shadows The above is a part screenshot of my site. When someone clicks a menu item, the grey transparent div comes up over the face (created using a 2 pixel square transparent gif - two pixels grey, the other two transparent). The idea is then to have content sitting on top of the transparent grey square. The content has to expand or contract depending on the size of the screen, so it will be made up of individual images. It would be great for the images to have drop shadows on them to make them stand out. Problem is, I can't add them in Photoshop, otherwise they will look bad when I make the images transparent gifs. My next option was to use solid block drop shadows, like in the image above, but they still look average. I was wondering if there is an html or css way of adding a drop shadow to images and text that will let the background from lower divs show through? So not a static, saved image drop shadow, - it has to be dynamic in that when the images move when the browser window or resolution changes, the new part of background image (the face) shows through the drop shadow. Hope this makes sense - it's late and I've had a lot of coffee. Cheers Shaun This has probably been asked before, but while the answer is so elusive it's darned frustrating. How do I display my own code in my own browser? I'm using Expression Web 4 and Textpad. Neither of which will display my HTML code that has passed the 3WC validity process. So presumably it's a Windows 7 thing with a setting somewhere that needs to be ticked? I can get the example at Http://www.w3schools.com/xml/xml_data_island.asp to work just fine but when I try it with my own XML and HTML files it only displays a little white box. My 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> - <DataType> <Datatype_id>2</Datatype_id> <name>Decimal</name> <description /> </DataType> - <DataType> <Datatype_id>3</Datatype_id> <name>INT</name> <description /> </DataType> - <DataType> <Datatype_id>4</Datatype_id> <name>Boolean</name> <description /> </DataType> - <DataType> <Datatype_id>5</Datatype_id> <name>DateTime</name> <description /> </DataType> - <IncidentReport> <IncidentReport_ID>0</IncidentReport_ID> <Name>new</Name> <TStamp>2006-11-06T18:00:01.8344249-06:00</TStamp> <ProfileName>Bomb Response</ProfileName> <GUID>b2d785ca-98c2-47dd-9343-3714598d8f31</GUID> <License>24CC0LFL5T0K5D3944700DLRWYNU3R</License> <Version>4.0.0.26014</Version> </IncidentReport> My HTML: Code: <html> <body> <xml id="log" src="CurrentLog.xml"></xml> <table border="1" datasrc="#log"> <tr> <td><span datafld="Name"></span></td> <td><span datafld="Version"></span></td> </tr> </table> </body> </html> First off let me say I am completely new at this! I seem to be having the most basic problem you can. I wrote this in wordpad: <html> <Head> <title>first attempt</title> </head> <body> <h1>first attempt</h1> <p>First attempt. </p> </body> </html> And saved it as an Open Document Text. When I open this using Internet Explorer I noticed I could save it as an HTML document. So I did and I opened it AGAIN in internet explorer...and this comes up: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content="text/html; charset=windows-1252" http-equiv=Content-Type></HEAD> <BODY><PRE><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content="text/html; charset=windows-1252" http-equiv=Content-Type> <META name=GENERATOR content="MSHTML 8.00.7600.16853"></HEAD> <BODY><PRE>&lt;!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"&gt; &lt;HTML&gt;&lt;HEAD&gt; &lt;META content="text/html; charset=windows-1252" http-equiv=Content-Type&gt;&lt;/HEAD&gt; &lt;BODY&gt;&lt;PRE&gt;&amp;lt;html&amp;gt; &amp;lt;Head&amp;gt; &amp;lt;title&amp;gt;first attempt&amp;lt;/title&amp;gt; &amp;lt;/head&amp;gt; &amp;lt;body&amp;gt; &amp;lt;h1&amp;gt;and so begins my genisus&amp;lt;/h1&amp;gt; &amp;lt;p&amp;gt;a new path for my life. &amp;lt;/p&amp;gt; &amp;lt;/body&amp;gt; &amp;lt;/html&amp;gt;&lt;/PRE&gt;&lt;/BODY&gt;&lt;/HTML&gt; </PRE></BODY></HTML> </PRE></BODY></HTML> What am I doing wrong if I just want it displayed as an offline website on my computer? I appolagize but The Missing Manual book I'm reading "Creating Web Sites" doesn't come up with this problem and says I should be able to view HTML as a website if it's on my computer using a web browser. So here's my problem: I had to create an HTML newsletter for a client to send on a monthly basis. I've tested it in several browsers and everything seemed to be working fine, until she received a reply from one of her subscribers, (from an AOL account) with a screenshot of what the newsletter looked liked on her screen. Everything was wrong! The newsletter didn't display pictures at all, some HTML comments were showing up and extra characters and no spaces had been placed between the text. I'm pretty new to HTML and CSS, so I tried to keep it as simple as possible to not compromise browser compatibility. And in different computers and browsers it was working perfectly fine. But now with this, I've no clue how to fix it! Help?? to view the source code: www.offinterarts.org/newsletter.html Good day I need some help. I created a website in adobe dreamworks a while ago. I have added another link to a html file hosted on my website, but it doesn't work in IE and works fine in Chrome and Firefox. the link works, but not the whole page loads any suggestions? I have tried to make a website with help from a mate, but i can't get it to work. I need the final pictures to work. They just keep on displaying as text, not pictures. *PLEASE NOTE*i'm not very good at HTML - please talk easy speak or suggest how coding of what i should use instead. my coding so far is as follows: *PLEASE NOTE* do not mind my picture/info - it isn't actually relevent, just examples! *coding* HTML Code: <html> <head> <title>Madmanbonzo</title> <script type="text/javascript"> confirm("Are you a person?") } </script> </head> <body> <table> <tr> <td> <font face="arail" size="8" color="blue"><b> Madmanbonzo's first website!!</b></font> </td> </tr> </table> <hr> <table align="center" width="700 pt"> <tr> <td align="center"> <font face="Times New Roman" size="4" color="green"><u><marquee>My first website!!!<button>Click Me If Bored!</button></u></marquee></font> </td> </tr> </table> <hr> <table align="center" width="100%" border="1"> <tr> <td align="left" width="50%"> <font face="arail" size="4" color="red">Links <ul> <li><a href="http://www.google.com" title="Google">Google</a> - A major search engine!</li> </ul> </font> </td> <td align="center" width="120"> <font face="arail" size="4" color="violet">This is my first ever website!!</font> <form> <input type=button value="click for 5 pounds" onClick="shut()"> </form> <form> <input type=button value="click for 10 pounds" onClick="shut()"> </form> </td> </tr> </table> <a href='http://www.draynor.net/'><img src='http://www.draynor.net/anim/mickeena.gif' alt='Draynor.net' /></a> <a href="http://www.draynor.net/" title="Draynor.net Skill-Goal Signature"><img src="http://www.draynor.net/skill/mithril/ranged/70/mickeena.png" alt="Draynor.net Stat Signature <a href="http://www.draynor.net/" title="Draynor.net Skill-Goal Signature"><img src="http://www.draynor.net/skill/mithril/attack/75/mickeena.png" alt="Draynor.net Stat Signature <a href="http://www.draynor.net/" title="Draynor.net Skill-Goal Signature"><img src="http://www.draynor.net/skill/mithril/overall/1250/mickeena.png" alt="Draynor.net Stat Signature <a href="http://www.draynor.net/" title="Draynor.net Skill-Goal Signature"><img src="http://www.draynor.net/skill/mithril/fishing/68/mickeena.png" alt="Draynor.net Stat Signature <a href="http://www.draynor.net/" title="Draynor.net Skill-Goal Signature"><img src="http://www.draynor.net/skill/mithril/mining/60/mickeena.png" alt="Draynor.net Stat Signature <a href="http://www.draynor.net/" title="Draynor.net Stat Signature"><img src="http://www.draynor.net/stat/mithril/male/dharok_set/Mickeena.png" alt="Draynor.net Stat Signature <a href="http://www.draynor.net/sgoal_signatures.php" title="Draynor.net Homeworld Bar"><img src="http://www.draynor.net/hw/mithril/129.png" alt="Draynor.net Stat Signature Bye </body> *coding above* Please help! case closed!!! I sorted the problem...thanks guys! i'm a bit confused.. it always worked, that i uplaoded the hml code as a new web page in the ftp web tool... (without even name it to .html at the end of the site name...) How can I make that the webpage which i uploaded is diplayed as the actual webpage (and not shown the html code instead) WITHOUT have to add .html to the url??? Example: url.com/contact --> shows only html code url.com/contact.html --> shows correct site but if u access any site... you usually never have to add .html to the url: e.g.: www.mtv.com/music PLEASE, thanks I have a following html document <html xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <body title="Integrated MedFacts Module"> <span class="normalFont" style="font-size:140%; width:100%; "><b>Tetracycline Capsules and Tablets</b></span><b>Pronunciation: </b>tet-ra-SYE-kleen<br><b>Brand Name: </b> Sumycin<br><br><b>This medicine is used for:</b><p>Treating infections caused by certain bacteria.</p> </body> </html> The above document when seen in IE 7 shows Tetracycline Capsules and Tablets and Pronunciation in separate lines. But the same documetn when seen in Mozilla FireFox or Opera is showing Tetracycline Capsules and Tablets and Pronunciation in same lines without any space between them. Can anyone let me know why this is hapenning? Thanks, Ragha display html code without creating an actual link? I am writing an instruction manual an am having problems showing the html code without it becoming a link. I just started learning HTML, and made a file just to try out the various things I have learned. The below is said file. When I attempt to view it my picture does not appear, and I don't understand why. Help is much appreciated. <html> <head> <title>Test page</title> </head> <body> <center><h1>Yay for me</h1></center> <p>This is cool</p> <p>Bla bla bak</p> <ul> <li>Yay</li> <li>for</li> <li>me</li> </ul> <br> <img src=“Caster.jpg” /> </body> </html> Hello Are there any valid HTML tags that you can embed in a page that do not display content on the page? I am looking to store data that a RSS feed can retrieve on a news page, but I don't want the content to display on the news page, only be pulled for the RSS feed. Paul I am new to writing html and have really had a tough time trying to find any info on how to do this. I want to have a folder with word/powerpoint documents in it and a list of download links to those documents viewable inside a div on a webpage. I want the list to be able to display whatever is in the folder so that it will update as the contents of the folder are updated. how would I go about doing this? Hello, We are developing a consumer applicance here with a simple web interface. The web pages are served using "echo" statements in bash scripts, so nothing very advanced. The pages interact with the a server application on the box, to display various text data such as statistics, and to allow the user to edit various configuration data. We would like to extend this as follows. The user will enter numeric data, which will be processed by the server application. The application will generate a rating score 0-100, which we would like to display to user using a simple visual display such as an analog VU-meter, or by some other means. It would be a bonus if the "100" and "0" ends of the display "100" side could be colored red and green. Are there simple HTML-coded widgets available that can do this? The fact that I don't even know what these widgets are called, shows up my limited level of GUI design. Many thanks, Paul |