|
HTML - Excel Lookandfeel-alike Html Tables
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 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 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>
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 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 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 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 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! 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. I create html pages for my small business, and I am experiencing great frustrations. I am creating a calendar, and I have tried restricting the cell widths to specific px and % sizes and have tried the same in using style attributes, but nothing I try will prevent the cell from expanding with the text and distorting the calendar format. Is there a way to absolutely restrict the width of a column/cell in a table? Hi html world, My name is Ken G (globalsolutions). I hope I am posting in the right place. I have an issue with one of my pages I created. Since I cannot put a link to the page, may I post the html code? The page looks almost alright. The page was screwed up so I took out the <td> and the <tr> tags, kinda straightened out allot of the mistakes. Now The header will not show up on the page. The page is an one time offer with 45 + products, so the page is quite long and it has 3 images that it uses for the frame border. I had to add 1 in more than once to extend the page. I have in put a background image graphic and the table is white, at the bottom I have sometimes more sometimes less black area on each side of the frame that I cannot get to go away. I tried for some time to fix this, and to no avail. I would like to learn how to fix this problem, so I can move on to new ones, lol I have allot more pages to build.Again I Hope I posted in the right area. Thanks in advance I am trying to create a HTML table with 1 row and 2 columns. Each column contains an already made table. I want to be able to scroll both columns down together but only scroll the right one across. I have attempted to do this with the following code: <div style=' height:500px; width:screen.width; overflow-y:scroll; overflow-x:hidden'><table> <tr> <td>".$left_column_table."</td> <td > <div style=' width:screen.width-200px; height: 500px; overflow-x:scroll; overflow-y:hidden'>". $right_column_table."</div> </td> </tr> </table> </div> The problem with this code is that the horizontal scroll bar isn't visible if the vertical scroll bar is scrolled up. How do I make the horizontal scroll bar stay on top so that it is always visible? A table with 3 colunms in each 2 rows and only one column in the 3rd row, hw to write html scrip for this? Hi im new here, and im going to start off with a table related question what I am trying to do is have table with a image in the back ground, this I can do fine, the other thing I want to have with in that first table is another table (5 x 16) For some reason when i try this it will work as two table one after the other when table one has a image but works fine when there is no image, does any one have any ideas as to why this is happening. or type the code our for me to see where im going wrong Thanks for looking, 09ricardo23 HTML Code: <table border="0" cellpadding="0" cellspacing="0" width="600">
<tbody>
<tr>
<td rowspan="10">
<img src="images/blank-1.gif" width="27" height="1035" />
</td>
<td>
<img src="images/blank-2.gif" width="445" height="43" />
</td>
<td>
<img src="images/s-trip-logo.gif" width="128" height="43" alt="S-Trip!" />
</td>
</tr>
<tr>
<td width="425px">
<a href="http://www.edgeacademy.ca"><img src="images/edge-logo.gif" alt="EDGE Academy" width="425" height="115" /></a>
</td>
</tr>
<tr>
<td width="425px">
<img src="images/travel-for-credit.gif" width="425" height="34" alt="Travel for Credit \ Costa Rica \ England & France" />
</td>
</tr>
<tr>
<td>
<img src="images/book-now.gif" alt="Book now and save up to $500" width="148" height="150" />
</td>
</tr>
</tbody>
</table>
this is what it's producing: http://imageshack.us/photo/my-images...104at123t.png/ I'm trying to get the "book now and save" .gif to go up beside the EDGE logo. I'm a newbie at tables and am frustrated at this. When I "inspect element" the logo's <td> is saying the width is 445px when the width in the html is 425px. hey guys, Just wanted to know if this is at all possible. I have php pages that create tables through html that show data from my database. I want to know if i added like a print button on the page then get whatever is in the table and sent it to a pdf file to print out for a user. are there any example anyone could post or if this is in anyway remotely possible Ok guys, here is my problem. I want to start off first by saying I know tableless layouts are the way to go. With that said I inherited this site and only have to add some functionality. The problem is if you look at http://innonmainmanasquan.com/test/rates-302a.php in IE there is separations in the table, I have edited till I am blue in the face and have no Idea why it is doing this. FF displays it just fine. I have been trying to figure this out for the past 8 hours and still no dice. The code is below if someone could at least point me in the right direction that would be awsome. HTML Code: <html>
<head>
<title>Inn On Main Manasquan - A Unique Jersey Shore Bed And Breakfast</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="style.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style5 {color: #FFFFFF}
-->
</style>
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<?php
$page = "rooms";
$room = "302";
include('get.info.php');
?>
<div class="main">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top">
<td align="center"> <table id="Table_01" width="762" height="551" border="0" cellpadding="0" cellspacing="0">
<tr valign="top">
<td> <a href="index.php"><img src="images/Manasquan-Inn-Logo.gif" width="412" height="54" alt="home" border="0"></a></td>
<td colspan="4" background="images/Jersey-Shore-Nav-Background.jpg" valign="middle"><div class="nav"><a href="location-north.php">Location</a> | <a href="accommodation.php">Rooms</a> | <a href="reservation.php">Reservations</a></div></td>
</tr>
<tr valign="top">
<td colspan="5"> <img src="images/Jersey-Bed-Breakfast-Establ.gif" width="762" height="25" alt=""></td>
</tr>
<tr valign="top">
<td width="762" height="259" colspan="5" valign="top">
<!-------------INSERTION HERE------------->
<table id="Table_02" border="0" cellpadding="0" cellspacing="0">
<tr valign="top">
<td>
<img src="rooms/images/room_302-1_01.png" width="410" height="259" usemap="#Map" border="0"/>
<map id="_Map" name="Map">
<area shape="rect" coords="281,210,307,235" href="rates-302a.php" alt="Image 1" title="Image 1" />
<area shape="rect" coords="312,209,336,236" href="rates-302b.php" alt="Image 2" title="Image 2" />
</map>
</td>
<td background="rooms/images/room_302-1_02.gif" width="352" height="259">
<div class="center7">
<p>
<span class="style5">
<strong>
Room 302
</strong>
<br>
</span>
<?php echo stripslashes($returned['description']); ?>
<br />
<b>
<center>
<?php echo stripslashes($returned['cost']); ?>
</center>
<br />
<center>
<i>
Click link for availability and best rates.
</i>
</center>
<center>
<a href="http://www.webervations.com/magic-scripts/resbook.asp?memberid=richjo" target="_blank">
<u>
Check Availability
</u>
</a>
</center>
</b>
</p>
</div>
<div class="center8">
<center>
<strong>
<u>
Rooms
</u>
</strong>
<br>
<!--------------ROOM LINKS BELOW------------->
<a href="rates-201.php">201</a> - <a href="rates-202.php">202</a> - <a href="rates-203.php">203</a> - <a href="rates-204.php">204</a> - <a href="rates-205.php">205</a> - <a href="rates-206.php">206</a> <br>
<a href="rates-207.php">207</a> - <a href="rates-301.php">301</a> - <a href="rates-302a.php">302</a> - <a href="rates-303.php">303</a> - <a href="rates-304.php">304</a> - <a href="rates-305.php">305</a>
</center>
</div>
</td>
</tr>
</table>
<!--INSERTION OVER------>
</td>
</tr>
<tr valign="top">
<td colspan="5"> <img src="images/Jersey-Shore-Inn-Bottom.gif" width="762" height="25"></td>
</tr>
<tr valign="top">
<td colspan="2" background="images/Bottom-Left.gif" width="762" height="187" valign="top"><div class="bottom">
<div align="center"><img src="images/inn_facade.jpg" width="190" height="106" border="1"><br>
<?php $query="SELECT * FROM bottomhome"; $result = mysql_query($query) or die(mysql_error()); $resultarray = mysql_fetch_assoc($result); echo stripslashes($resultarray['artist']); ?></div>
</div></td>
<td colspan="3" background="images/Bed-Breakfast-Manasquan.gif" width="289" height="187" valign="top"><div class="bottom"><img src="images/Inn-On-Main-Bed.jpg" width="130" height="106" hspace="10" vspace="5" align="left"><strong>Our Rooms </strong><br></span>
<?php $query="SELECT * FROM bottomhome"; $result = mysql_query($query) or die(mysql_error()); $resultarray = mysql_fetch_assoc($result); echo stripslashes($resultarray['rooms']); ?><br>
<a href="inn-packages.php">Click Here for More Info »</a></div></td>
</tr>
<tr valign="top">
<td> <img src="images/spacer.gif" width="412" height="1" alt=""></td>
<td> <img src="images/spacer.gif" width="61" height="1" alt=""></td>
<td> <img src="images/spacer.gif" width="34" height="1" alt=""></td>
<td> <img src="images/spacer.gif" width="136" height="1" alt=""></td>
<td> <img src="images/spacer.gif" width="119" height="1" alt=""></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr valign="top">
<td align="center"><span class="style4">Inn On Main - 152 Main Street - Manasquan, NJ - (732) 528-0099 - </span><a href="mailto:info@innonmainmanasquan.com"><span class="style4">info@innonmainmanasquan.com</span></a><br>
<br><a href="http://www.tripadvisor.com/"><img src="http://www.tripadvisor.com/img/triplogo162w.gif" border="0" alt="TripAdvisor.com"></a>
<span class="bottom"><br>
Read unbiased opinions about <a href="http://www.tripadvisor.com/">hotels</a> and <a href="http://www.tripadvisor.com/">vacations</a> at TripAdvisor.</span> <br>
<img src='http://counter.dreamhost.com/cgi-bin/Count.cgi?df=jcnh74-countername.dat&pad=F&ft=0&dd=C&istrip=T'></td>
</tr>
</table></td>
</tr>
</table>
</div>
</body>
</html>
CSS Code: body {
background-image: url(images/Inn-On-Main-Background.gif);
font-family: "Times New Roman", Times, serif;
font-size: 12px;
overflow:hidden;
}
.main{
text-align: center;
padding-top: 30px;
padding-right: 0px;
padding-bottom: 0px;
padding-left: 0px;
margin-bottom: 5px;
overflow:hidden;
}
.main a:link{
color:#CCCCCC;
text-decoration: none;overflow:hidden;
}
.main a:hover{
color: #999999;
text-decoration: underline;overflow:hidden;
}
.main a:visited{
color:#CCCCCC;
text-decoration: none;overflow:hidden;
}
.center{
color: #FFFFFF;
padding: 0px;
margin-top:10px;
margin-left: 430px;
font-size: 12px;overflow:hidden;
}
.packpic{
padding-top: 0px;
padding-right: 0px;
padding-bottom: 30px;
padding-left: 0px;
overflow:hidden;
}
.center2{
color: #FFFFFF;
padding: 5px 20px 20px;
margin-left: 480px;
vertical-align: top;
text-align: center;
font-size: 12px;
overflow:hidden;
}
.center3{
color: #FFFFFF;
padding: 20px;
margin-left: 480px;
vertical-align: top;
text-align: center;
font-size: 12px;
overflow:hidden;
}
.center4{
color: #FFFFFF;
padding: 0px 20px;
margin-left: 480px;
vertical-align: top;
text-align: center;
font-size: 12px;
overflow:hidden;
}
.center7{
color: #FFFFFF;
padding: 0px;
margin-left:10px;
font-size: 12px;
overflow:hidden;
}
.center8{
color: #FFFFFF;
padding: 0px;
margin-left: 100px;
font-size: 12px;
overflow:hidden;
}
.center6{
color: #FFFFFF;
padding: -9px 20px -5px;
margin-left: 480px;
vertical-align: top;
text-align: center;
font-size: 12px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
overflow:hidden;
}
.nav{
color: #FFFFFF;
text-align: center;
padding: 5px;
overflow:hidden;
}
.bottom {
color: #082156;
padding: 8px;
font-size: 12px;
overflow:hidden;
}
.bottom a:link{
color:#666666;
text-decoration: none;
overflow:hidden;
}
.bottom a:hover{
color:#666666;
text-decoration: none;
overflow:hidden;
}
.bottom a:visited{
color:#666666;
text-decoration: none;
overflow:hidden;
}
.style2 {
font-size: 16px;
font-weight: bold;
overflow:hidden;
}
.style3 {
font-size: 14px;
font-weight: bold;
overflow:hidden;
}
.style4 {color: #003366}.rates {
color: #FFFFFF;
padding: 80px 0px 0px;
background-color: #666666;
overflow:hidden;
}
.bg01 {
background-image: url(images/innonmain_country.jpg);
background-repeat: no-repeat;
overflow:hidden;
}
.tbl{
width:762px;
overflow:hidden;
}
Any help would be very much appreciated!!!!! Thanks All! Hi, not very good at HTML. Need help. Currently have laid out my site design all within a table. Inside that table there are two tables on the top side by side out of which one is aligned to the right. Below these two tables I have other tables all aligned to the left. PROBLEM The top table aligned to the right, it is 160 width pixels by 900 pixels length. I want to keep the other tables below it exactly where they are but as this table grows in length, the other tables keeps getting pushed down. Hope I am clear. Pls help. Am willing to post my html layout if need to. Tnks. Hi all ! I have a quick question regarding a scoreboard app I am writing that displays 3 numbers on a large VGA screen. The question deals with best practice to build this page. I am using Visual Studio and but not any specific ASP.NET controls. The display consist of one table with 3 cells. one cell onto, 2 cells below the top one. Since I do not know the exact resolution of the VGA screen where my web page will display I have ventured to play with the zoom. However, using the zoom seems to offset the page downwards, meaning it does not zoom centered (or from the middle if you like). The more zoom I apply from the html the larger the page becomes, but it also moves down on the VGA screen. I am running the page in browser kiosk mode. It also seems to be very tricky to make the page position itself on the very top of the browser window. Using tables a problem, and if so, should I go with CSS ?? Thanks for input and thoughts on this.. Anders |
|||||||