|
HTML - Excel -> Html Issues.
Hello all! New to the forum here, so smack me into shape if i step outside of the rules...
Have recently been attempting to maintain a (very basic) website for my parent's cottage. I aimed to keep it low maintenance in order to allow me not to have to do too much to it! The address is http://www.bettwsbach.co.uk Recently, i've been attempting to add a new 2009 price list to the website, which has come to me in the form of an excel spreadsheet. Here's how it should look: http://www.bettwsbach.co.uk/Misc/BBPrice.jpg I've used Excel's in-house save-to-webpage feature, and with a bit of jiggery-pokery to make the background come up (!!) here's how it appears as part of a frameset on my mac: http://www.bettwsbach.co.uk/Misc/BBPriceMac.jpg HOWEVER! I'm reliably informed that on various computers, the formatting gets pretty screwed. If you have time, go through the link to the website above, click on 2009 prices, and see if it's legible. I can only think it might be a browser-related issue (i'm on firefox), or perhaps a resolution issue - maybe the page is trying to sort its own sizing out for each computer. Either way, you can see that the formatting changes markedly between Excel and the HTM page it pushes out. So i guess my questions a 1) Anyone come across this before? Any idea why it's messing me around? 2) Any idea how to make it better? 3) Is there a better solution to the webpage (i.e., not using Excel altogether) that i've inadvertently disregarded? Bear in mind the whole thing has been put together by me and notepad, and i've had to teach myself HTML, with very little time dedicated to the running of the website. Many thanks in advance. Rob Similar TutorialsHey, I'm wondering how to easily convert Excel documents into HTML, so that i can open them up in notepad/text edit. I read this article (http://www.granneman.com/webdev/codi...texceltotables) which says to save the excel document as a CSV file, then when using dreamweaver you can import that into a tabular form. Is there a way of doing this without using dreamweaver? I don't necessarily mean that it will be converted into straight HTML <table><tr> etc, but just so it's easily editable. When i open the CSV file in notepad i get a bunch of commas like this: ,,,,, ,,,,, ,,,,, Does anyone know how to do this in the most efficiently quick way? Either using notepad or text edit. Thanks so far i've created the calendar.html that contains the layout and the events.html from excel and i'd like to know the code or how to LINK the events.html into the calendar.html file rather than copy/pasting the enter code within the events.html file everytime so whenever i update the events.html i don't have to go into the calendar.html to update the codes, i can just replace the events.html file and woolah! when i save the excel file i can choose to save it as a webpage but then that's 2 html files, i'm just trying to get the table inside the calendar.html while keeping the layout and ease of being able to create it within excel thanks a bunch, TIA Hi everyone, Unfortunately a database is and .NET is out fo the question. The application is limited to HTML / JS only. I am creating a form that will search these accounts for amounts greater than $X. For ease of editing and the end user, the account numbers are stored on an Excel sheet. How would I reference the spreadsheet and cell range in HTML to allow querying on these account numbers? This is what I had so far in my attempts of searching and trying to piece together this segment. Code:
<head>
<SCRIPT>
function openwb() {
var Excel;
Excel = new ActiveXObject("Excel.Application");
Excel.Visible = false;
form1.my_textarea2.value = Excel.Workbooks.Open("C:/Sean/HTML/account_numbers.xls").ActiveSheet.Cells(1,1).Value;
Excel.Quit();
}
</SCRIPT>
</head>
<body>
<tr>
<td width="200" >
<p align=right><font face="Times New Roman" size="3">Account Number</font>
</td>
<td>
<SELECT name=OBOperKey_51_1>
<OPTION selected>AND</OPTION><OPTION>OR</OPTION></SELECT>
</td>
</p>
<td>
<INPUT type="hidden" name=OBOperKey_51_1 onFocus="openwb();" value="Get Excel Data">
</td>
</tr>
</body>
Hello, I am new here, name is Eric and I have a quick question in hopes someone can point me in the right direction. I am trying to make a web page that acts as a quick quote site for potential clients. Pretty much all it's going to do is use a formula like Excel does to take a number a client inputs into a field and times it by another number to give you a quote...will be a couple other fields that the client will input to get a more accurate number...but same idea throughout the page just different formulas. I have been using Zoho which embeds a Excel spread sheet, but problem is...it looks like an excel spreadsheet. I am trying to do the same functions but I would like to make it more appealing then just an excel spreadsheet. I would like to just use fields and make the site clean and look noting like a spreadsheet but still use the formulas that excel allows you to use. I would appreciate any help on the topic. Thanks in advance! -Tilly I require to output html to excel( right click on html table and option "export to MS excel" ) and getting following error. "unable to open "html path". Cannot download the information you requested. I am using MS EXCEL 2007. any workaround is greatly appreciated. Thanks Al Is there a way to create names of reports and place in a list box or combo box and select the report and click a button to open the report? I also have added a link to a file ( that would be on the server) for the user to open the file, but I click the hyperlink the file does not open. <a href="Attrition (2).doc">Attrition</a><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> I am trying to figure out how to send information that people submit on an internet website, from the website to an excel worksheet. Reason being I no longer want to do the "grunt work" for a fellow employee of mine. Any help would be great! 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 What would I need to add to a form in HTML to have it saved to an Excel Document when it is submitted? I want each <input type="text"/> to be put on the same line, then the next person to fill out the form goes on the next line. This is what I have so far, and I have no idea how to get it to link with an Excel Document. <html> <head> <title>Please Sign In</title> </head> <body> <h2>Please Sign In</h2> <form> Name: <input type="text" name="name" value="" size="20"/><br/> Date: <input type="text" name="date" value="" size="20"/><br/> <input type="radio" name="inout" id="in"/> In <br/> <input type="radio" name="inout" id="out"/> Out <br/> <input type="submit" value="Submit" size="20"/> </form> </body> </html> For the radio buttons, would it be possible to have an In column and an Out column in the excel sheet and whichever is selected would put an X in that column? Thanks in advance for any help. Hi Folks, I am new at HTML and presently trying to build an html table whose cells react like excel ones. That is to say: - If I click into a cell, then its border should become bold and thicker -If I enter text into a cell and the text overflows the given length, then a linebreak should automatically added and the cell should become higher Somebody told me that one can perform such a task with html and css. Is it true? Does somebody what I shoud combinate with Html in order to perform such a task? Regards, Bu === I'm on a Mac and I'm noticing that the site I'm developing is having major <TABLE> issues on IE for the PC -- like seen in this Screen Shot he http://sample.studiopresence.com What it should look like is seen on this Screen Shot he http://sample.studiopresence.com/site_v2B.htm Here's the actual HTML version of the site: http://australianwellnesscentre.studiopresence.com Any help on this is GREATLY APPRECIATED!!! Thanks in advance! === Hello all, I am having a problem which I can't seem to figure out with an html page. I sliced up a photoshop image then turned it into a web page. I took the html table from the sliced up header, and plugged it into the final web page. It looked like it was aligned properly in Dreamweaver, however when I viewed the webpage there were some alignment issues with the page. Here is the link to the misaligned page: http://test.gridpointpm.com Here is the code for part of the index page that includes the header with the alignment issues: Code: <!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>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<link href="style.css" rel="stylesheet" type="text/css" />
<link href="layout.css" rel="stylesheet" type="text/css" />
<script src="maxheight.js" type="text/javascript"></script>
</head>
<body id="page1" onload="new ElementMaxHeight()">
<div class="w">
<div class="site_center">
<div class="site_center1">
<div id="header">
<div class="flash">
<!-- Save for Web Slices (indexheader.psd) -->
<table id="Table_01" width="866" height="441" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="13">
<img src="images/index_01.jpg" width="866" height="66" alt=""></td>
<td>
<img src="images/spacerh.gif" width="1" height="66" alt=""></td>
</tr>
<tr>
<td colspan="13"><img src="images/index_02.jpg" width="866" height="206" alt="" /></td>
<td>
<img src="images/spacerh.gif" width="1" height="206" alt=""></td>
</tr>
<tr>
<td colspan="7" rowspan="2">
<img src="images/index_03.jpg" width="632" height="114" alt=""></td>
<td colspan="5">
<img src="images/index_04.jpg" width="157" height="34" alt=""></td>
<td rowspan="6">
<img src="images/index_05.jpg" width="77" height="169" alt=""></td>
<td>
<img src="images/spacerh.gif" width="1" height="34" alt=""></td>
</tr>
<tr>
<td colspan="5" rowspan="2">
<img src="images/index_06.jpg" width="157" height="95" alt=""></td>
<td>
<img src="images/spacerh.gif" width="1" height="80" alt=""></td>
</tr>
<tr>
<td colspan="5">
<img src="images/index_07.jpg" width="360" height="15" alt=""></td>
<td rowspan="3">
<img src="images/index_08.jpg" width="180" height="40" alt=""></td>
<td rowspan="4">
<img src="images/index_09.jpg" width="92" height="55" alt=""></td>
<td>
<img src="images/spacerh.gif" width="1" height="15" alt=""></td>
</tr>
<tr>
<td rowspan="3">
<img src="images/index_10.jpg" width="153" height="40" alt=""></td>
<td>
<img src="images/index_11.jpg" width="42" height="16" alt=""></td>
<td rowspan="3">
<img src="images/index_12.jpg" width="9" height="40" alt=""></td>
<td>
<img src="images/index_13.jpg" width="58" height="16" alt=""></td>
<td rowspan="3">
<img src="images/index_14.jpg" width="98" height="40" alt=""></td>
<td rowspan="3">
<img src="images/index_15.jpg" width="31" height="40" alt=""></td>
<td>
<img src="images/index_16.jpg" width="44" height="16" alt=""></td>
<td rowspan="3">
<img src="images/index_17.jpg" width="7" height="40" alt=""></td>
<td>
<img src="images/index_18.jpg" width="55" height="16" alt=""></td>
<td rowspan="3">
<img src="images/index_19.jpg" width="20" height="40" alt=""></td>
<td>
<img src="images/spacerh.gif" width="1" height="16" alt=""></td>
</tr>
<tr>
<td rowspan="2">
<img src="images/index_20.jpg" width="42" height="24" alt=""></td>
<td rowspan="2">
<img src="images/index_21.jpg" width="58" height="24" alt=""></td>
<td rowspan="2">
<img src="images/index_22.jpg" width="44" height="24" alt=""></td>
<td rowspan="2">
<img src="images/index_23.jpg" width="55" height="24" alt=""></td>
<td>
<img src="images/spacerh.gif" width="1" height="9" alt=""></td>
</tr>
<tr>
<td>
<img src="images/index_24.jpg" width="180" height="15" alt=""></td>
<td>
<img src="images/spacerh.gif" width="1" height="15" alt=""></td>
</tr>
</table>
<!-- End Save for Web Slices -->
</div>
</div>
Any help would be much appreciated. Thanks in advance. Hi all, Not sure if im posting in the right place but i am having some problems, well, a lot of issues, with an email im sending in outlook. As you can see outlook has put hue gaps in before each section, although the gap in the right column is supposed to be there. Any one have any advice on how to fix this? Its works well in every other email inbox... really stumped! Thanks for any help in advance. Matt Can anyone expain to me why this page I am working on looks fine in both Google Chrome and Mozilla Firefox, but looks completely askew when using Microsoft Internet Explorer? Any help would be appreciated! http://imxevent.com/imx2011/Public/C...ortMenu=101005 view-source:http://imxevent.com/imx2011/Public/C...ortMenu=101005 I think it is this piece of code that is causing me problems (lines 281-287)... HTML Code: <p><font style="FONT-SIZE: 20px" color="#c00000"><strong>imX Keynote Sessions</strong></font></p> <p><span style="FONT-FAMILY: Univers 57 Condensed; COLOR: black"><font style="FONT-SIZE: 15px">An extension of the forward thinking that has defined the development of imX, these Keynote Presentations reflect imX’s position as a high-level gathering place for manufacturing thought leaders from across the country and around the world. If it’s important for U.S. manufacturing, it's discussed at imX.</font></span> </p><p><table style="width: 510px; height: 138px; " class="RadEDomMouseOver"> <tbody> <tr> <td colspan="3"> <strong>KEYNOTE SESSION - DAY ONE</strong></td></tr> <tr><td style="text-align: center; vertical-align: top; "> <img alt="Michael Molnar" src="http://www.imxevent.com/imx2011/CUSTOM/images/molnar.jpg">&nbsp;</td><td>&nbsp;</td><td style="text-align: left; vertical-align: middle; "><font><font><br><url=http://www.imxevent.com/imx2011/public/Content.aspx?ID=316&amp;sortMenu=102003 style="color: rgb(255, 0, 0); font-family: arial, Verdana, sans-serif; font-size: 14px; font-weight: bold; ">Michael F. Molnar</a></font></font><b style="font-family: arial, Verdana, sans-serif; font-size: 14px; ">, FSME, CMfgE, PE</b><br><br><table class="RadEDomMouseOver" style="font-family: arial, Verdana, sans-serif; font-size: 14px; font-weight: bold; width: 510px; height: 138px; "><tbody><tr><td style="text-align: left; vertical-align: top; "><strong><font color="#ff0000">Date:</font></strong></td><td> </td><td style="text-align: left; vertical-align: top; ">Monday, September 12, 2011</td></tr><tr><td style="text-align: left; vertical-align: top; "><strong><font color="#ff0000">Speaker:</font></strong></td><td> </td><td style="text-align: left; vertical-align: top; ">Michael F. Molnar, FSME, CMfgE, PE</td></tr><tr><td style="text-align: left; vertical-align: top; "><strong><font color="#ff0000">Title:</font></strong></td><td> </td><td style="text-align: left; vertical-align: top; ">The U.S. Advanced Manufacturing Initiative: <br>Your Role in Public Private Partnerships</td></tr></tbody></table></td></tr><tr><td style="TEXT-ALIGN: left; VERTICAL-ALIGN: top" colspan="3"> <iframe width="480" height="315" src="http://www.youtube.com/embed/VUzBbwlpIFk" frameborder="0" allowfullscreen=""></iframe></td></tr></tbody></table></p> <p><a name="schutz"></a> Hi guys maybe some one could help me here iv made a template in photoshop see below now i have the header and footer stretching perfectly now the issues is when i try to insert the content in the middle (content is a thumbnail gallery script) 2 left and right sidebar disappear and they do not stretch up and down i duno what im missing ??? is there a way to do this?? iv tried using a table inbetween the top and bottom half but still i just removes the side bars... in other words im try to "make a square(theme) with content in the middle of it" if you catch my drift with the side bars streting up and down as the content grows larger i think an iframe in the middle would work but the CMS im using does not like Iframes and i know iframes are a bit outdated here is the code im using... ANy help will be very much appreciated HTML Code: <style type="text/css">
<!--
body,td,th {
color: #0F0;
}
-->
</style><center>
<style type="text/css">
<!--
body {
background-color: #0b0b0b;
}
-->
</style><table id="Table_01" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2">
<img src="images/steamlounge_01.png" width="213" height="185" alt=""></td>
<td background="images/steamlounge_02_STR.png" width="100%" height="185" alt=""></td>
<td colspan="2">
<img src="images/steamlounge_04.png" width="238" height="185" alt=""></td>
</tr>
</table>
<table id="Table_02" align="left" width="87" height"100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td background="images/steamlounge_05_STR.png" alt=""></td>
</tr>
</table>
<p>hgjdgjdghjjdg
hjd
ghjd
gh
g
g
g
g
g
g
g
g
g
g
g
g
g
g
g
g
g
g
g
gg </p>
<p>g</p>
<p>g</p>
<p>g</p>
<p>g</p>
<p> </p>
<table id="Table_02" align="right" width="87" height"100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td background="images/steamlounge_07_STR.png" alt=""></td>
</tr>
</table>
<table id="Table_01" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2">
<img src="images/steamlounge_10.png" width="213" height="68" alt=""></td>
<td background="images/steamlounge_11_STR.png" width="100%" height="68" alt=""></td>
<td colspan="2">
<img src="images/steamlounge_13.png" width="238" height="68" alt=""></td>
</tr>
</table>
</center>
I am attempting to make it so when a member posts to the tumblr blog that their name and image appear next to their posts. I noticed that there was some block:post variables that describe this function as being somewhat of a possibility. Am I wrong in that assumption? I am unfamiliar with where to place this code or if it needs any associative div tags to make this functionality take place. I plan to have 5 additional users and that will all have TUMBLR accounts and profile images. What variables and in what location/format would I have to include in the HTML editor to achieve this function? I found the following groupMember block variables on the custom themes section and am at a loss. Any help would be appreciated. Thank you very much! Here is the different types of variables: http://www.tumblr.com/docs/en/custom_themes#text-posts Group Members Variable Description {block:GroupMembers} {/block:GroupMembers} Rendered on additional public group blogs. {block:GroupMember} {/block:GroupMember} Rendered for each additional public group blog member. {GroupMemberName} The username of the member's blog. {GroupMemberTitle} The title of the member's blog. {GroupMemberURL} The URL for the member's blog. {GroupMemberPortraitURL-16} Portrait photo URL for the member. 16-pixels by 16-pixels Hi, I have a table with a background image. i want that this background image adjust itself dynamically according to the size of the table. Can this be achieved. can anyone post any technique of doing this? Thanks in advance geniuses htmlgroom Hello, I designed this website http://www.aitputd.org/conference and found that it has compatibility issues when viewed with different browsers. e.g. The 'font' of the menu changes (becomes bold) when viewed in IE and Chrome browsers as opposed to FF3.5 Also The title 'sponsors' on the left does not stay at the center in IE and FF3.5 but seems good in Chrome. Is there a solution to address these problems?? Any help is highly appreciated. Regards, NP I am not an amatuer, I'd think, but for some reason I am having trouble slicing up this image into a site (http://www.pigseldesign.com/tartan_mod.jpg). The top menu is the problem area, but I think my trouble comes into play due to me using tables. I haven't really delved into DIV tags yet to understand how to make it work in that form, but it doesn't seem like it would be difficult. I've just split the image into four columns and the menu falls into the 3rd. Problem is, when I make the cell's background the black/gray gradient, it spans to match the height of the patterned banner on the left (in another cell), even after I set the menu's cell's height to what it should be. I know there isn't much concrete information to work with, but any help would be greatly appreciated. Even if there were a program where I could just slap this in and have it spit out what I need. I just want the code clean, correct and looking right. |
|||||||