excel shipping sheet into my store

May 17, 2004

Hi guys

I have been trying this for while now.

I want to incorporate my excel-sheet into the exsisting shipping.php for my store.

I have the coding for excel-sheet tried inserting it in my admin hoping it would appear on my shipping& returns page. no luck

my original shiping code is below and this is where i want to insert excel-sheet

<?php
/*

$Id: conditions.php,v 1.3 2001/12/20 14:14:14 dgw_ Exp $

The Exchange Project - Community Made Shopping!

http://www.theexchangeproject.org

Copyright © 2000,2001 The Exchange Project

Released under the GNU General Public License

Mod Created by Craig Harrison

*/

?>

<?php

require('includes/application_top.php');

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_SHIPPING);

$breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_SHIPPING, '', 'NONSSL'));

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

<title><?php echo TITLE; ?></title>

<base href="<?php echo (getenv('HTTPS') == 'on' ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<link rel="stylesheet" type="text/css" href="stylesheet.css">

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">



<?php require(DIR_WS_INCLUDES . 'header.php'); ?>





<table border="0" width="100%" cellspacing="3" cellpadding="3">

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">



<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>



</table></td>



<td valign="top">

<?php

$sql=mysql_query('SELECT * FROM info_shipping')

or die(mysql_error());

$row=mysql_fetch_array($sql);

?>

<br><br>

<table width="100%" cellspacing="0" cellpadding="0" >

<tr class="header">

<td class="headerNavigation" width="10">

<img border="0" src="images/infobox/corner_right_left.gif"></td>

<td class="headerNavigation">Shipping & Returns</td>

</tr>

</table>

<table border="0" width="100%" cellspacing="0" cellpadding="1" class="infoBox">

<tr>

<td>

<table width="100%" border="0" cellpadding="4" cellspacing="4" class="infoBoxContents">

<tr>

<td class="boxtext" valign="top">

<?php

echo str_replace("\r\n", "<br>", $row['Text']);

?>

</td>

</tr>

</table>

</td>

</tr>

</table>

</td>



<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">



<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>



</table></td>

</tr>

</table>





<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>



<br>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

now i tried taking all from from my excel-code between the bodies <body>& </body> and all from the styles-code <style>& </style> into style.ccs but haven't been succesfull.

my excel-code:

<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"

xmlns="http://www.w3.org/TR/REC-html40">

<head>

<meta http-equiv=Content-Type content="text/html; charset=windows-1252">

<meta name=ProgId content=Excel.Sheet>

<meta name=Generator content="Microsoft Excel 10">

<link rel=File-List href="Shipping%20Rates_files/filelist.xml">

<style id="Shipping Rates_6049_Styles"></style>

<style id="Shipping Rates_8312_Styles">



</style>

</head>

<body>













<div id="Shipping Rates_6049" align=center x:publishsource="Excel"></div>



















<div id="Shipping Rates_8312" align=center x:publishsource="Excel">

<table x:str border=0 cellpadding=0 cellspacing=0 width=251 style='border-collapse:

collapse;table-layout:fixed;width:188pt'>

<col width=64 span=3 style='width:48pt'>

<col width=59 style='mso-width-source:userset;mso-width-alt:2157;width:44pt'>

<tr height=21 style='height:15.75pt'>

<td colspan=4 height=21 class=xl418312 width=251 style='border-right:.5pt solid black;

height:15.75pt;width:188pt'>Shipping Rates</td>

</tr>

<tr height=17 style='height:12.75pt'>

<td height=17 class=xl248312 style='height:12.75pt;border-top:none'> </td>

<td class=xl258312 style='border-top:none'> </td>

<td class=xl258312 style='border-top:none'> </td>

<td class=xl298312 style='border-top:none'> </td>

</tr>

<tr height=17 style='height:12.75pt'>

<td colspan=2 height=17 class=xl378312 style='border-right:.5pt solid black;

height:12.75pt'>Amount Spent</td>

<td colspan=2 class=xl398312 style='border-right:.5pt solid black'>Shipping

Rate</td>

</tr>

<tr height=17 style='height:12.75pt'>

<td colspan=2 height=17 class=xl358312 style='border-right:.5pt solid black;

height:12.75pt'>$0-$25</td>

<td colspan=2 class=xl448312 style='border-right:.5pt solid black'

x:num="6.95">$6.95 </td>

</tr>

<tr height=17 style='height:12.75pt'>

<td colspan=2 height=17 class=xl488312 style='border-right:.5pt solid black;

height:12.75pt'>$25-$50</td>

<td colspan=2 class=xl318312 style='border-right:.5pt solid black'

x:num="8.95">$8.95 </td>

</tr>

<tr height=17 style='height:12.75pt'>

<td colspan=2 height=17 class=xl348312 style='border-right:.5pt solid black;

height:12.75pt'>$50-$75</td>

<td colspan=2 class=xl468312 style='border-right:.5pt solid black'

x:num="10.95">$10.95 </td>

</tr>

<tr height=17 style='height:12.75pt'>

<td colspan=2 height=17 class=xl488312 style='border-right:.5pt solid black;

height:12.75pt'>$75-$100</td>

<td colspan=2 class=xl318312 style='border-right:.5pt solid black'

x:num="12.95">$12.95 </td>

</tr>

<tr height=17 style='height:12.75pt'>

<td colspan=2 height=17 class=xl348312 style='border-right:.5pt solid black;

height:12.75pt'>$100-$125</td>

<td colspan=2 class=xl468312 style='border-right:.5pt solid black'

x:num="14.95">$14.95 </td>

</tr>

<tr height=17 style='height:12.75pt'>

<td colspan=2 height=17 class=xl488312 style='border-right:.5pt solid black;

height:12.75pt'>$125-$150</td>

<td colspan=2 class=xl318312 style='border-right:.5pt solid black'

x:num="16.95">$16.95 </td>

</tr>

<tr height=17 style='height:12.75pt'>

<td colspan=2 height=17 class=xl348312 style='border-right:.5pt solid black;

height:12.75pt'>$150-$175</td>

<td colspan=2 class=xl468312 style='border-right:.5pt solid black'

x:num="18.95">$18.95 </td>

</tr>

<tr height=17 style='height:12.75pt'>

<td colspan=2 height=17 class=xl488312 style='border-right:.5pt solid black;

height:12.75pt'>$175-$200</td>

<td colspan=2 class=xl318312 style='border-right:.5pt solid black'

x:num="20.95">$20.95 </td>

</tr>

<tr height=17 style='height:12.75pt'>

<td colspan=2 height=17 class=xl348312 style='border-right:.5pt solid black;

height:12.75pt'>$200-$225</td>

<td colspan=2 class=xl468312 style='border-right:.5pt solid black'

x:num="22.95">$22.95 </td>

</tr>

<tr height=17 style='height:12.75pt'>

<td colspan=2 height=17 class=xl488312 style='border-right:.5pt solid black;

height:12.75pt'>$225-$250</td>

<td colspan=2 class=xl318312 style='border-right:.5pt solid black'

x:num="24.95">$24.95 </td>

</tr>

<tr height=17 style='height:12.75pt'>

<td colspan=2 height=17 class=xl348312 style='border-right:.5pt solid black;

height:12.75pt'>$250-$275</td>

<td colspan=2 class=xl468312 style='border-right:.5pt solid black'

x:num="26.95">$26.95 </td>

</tr>

<tr height=17 style='height:12.75pt'>

<td colspan=2 height=17 class=xl488312 style='border-right:.5pt solid black;

height:12.75pt'>$275-$300</td>

<td colspan=2 class=xl318312 style='border-right:.5pt solid black'

x:num="28.95">$28.95 </td>

</tr>

<tr height=17 style='height:12.75pt'>

<td colspan=2 height=17 class=xl348312 style='border-right:.5pt solid black;

height:12.75pt'>$300-$325</td>

<td colspan=2 class=xl468312 style='border-right:.5pt solid black'

x:num="30.95">$30.95 </td>

</tr>

<tr height=17 style='height:12.75pt'>

<td colspan=2 height=17 class=xl488312 style='border-right:.5pt solid black;

height:12.75pt'>$325-$350</td>

<td colspan=2 class=xl318312 style='border-right:.5pt solid black'

x:num="32.95">$32.95 </td>

</tr>

<tr height=17 style='height:12.75pt'>

<td colspan=2 height=17 class=xl368312 style='border-right:.5pt solid black;

height:12.75pt'>etc.</td>

<td colspan=2 class=xl338312 style='border-right:.5pt solid black'>etc.</td>

</tr>

<tr height=17 style='height:12.75pt'>

<td height=17 class=xl268312 style='height:12.75pt'> </td>

<td class=xl288312> </td>

<td class=xl278312> </td>

<td class=xl288312> </td>

</tr>

<![if supportMisalignedColumns]>

<tr height=0 style='display:none'>

<td width=64 style='width:48pt'></td>

<td width=64 style='width:48pt'></td>

<td width=64 style='width:48pt'></td>

<td width=59 style='width:44pt'></td>

</tr>

<![endif]>

</table>

</div>







</body>

</html>

Thanks in advance for your help

Papito

vasttech · May 17, 2004

When you use the publish html feature in Excel it publishes it as an ASP.NET page, that is why you are seeing some strange codes in there. The easiest way to do what you want is to get a good HTML editor and create an HTML table with the info in it. It will be much quicker and easier for you. If you need assistance e-mail me.

excel shipping sheet into my store

Recommended Posts

Guest

vasttech

Archived

Browse

Activity