Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

excel sheet and php scripting


Guest

Recommended Posts

Hi there

 

I'm looking for the code to insert an excel sheet into the shipping & returns tab.

 

I have a sheet with 2 colums displaying shiping rates etc. Now i want it displayed just as it looks in excel.

 

Can i get some help as how to insert this in the shipping php-script

 

Thnx guys

 

Papito

Link to comment
Share on other sites

Excel->File->Save As->Html

 

Open save file in an HTML or text editor, cut and paste everything between the <Body></Body> tags into your shipping text.

 

Cut and paste everything between the <Style></Style> tags into your stylesheet.css

I'd rather be flying!

Link to comment
Share on other sites

Im back ...

 

I don't seem to be having any luck with this..

 

 

My excel is in code and i took code between body and /body /: now i placed it into my admin where the shipping info would go also added styles into style sheet (do they have to be within specific tags? - doesn't seem to affect any?)

 

I did completely erase code in includes/english path - to see what would happen replaced with all of my excel sheet code and it came out fine - however i need my header footer etc so i changed all that back - now i can't seem to figure out where to place the body-text so it would work on page

 

 

this is how page displays

 

http://www.theadulttoysforless.com/store/shipping.php

 

 

Can you please assist me further?Thnx

 

Papito

Link to comment
Share on other sites

When I view your source, I see you inlcluded <BODY> and </BODY>.

<br><br><body><br><!--The following information was generated by Microsoft Excel\'s Publish as Web

You need to cut-and-paste everthing that is between those two tags.

 

I cleaned up the table code for you. Try putting this into your shipping text:

 

<table border=0 cellpadding=4 cellspacing=0 style="border:1px solid black;" width=260 ID="Table1">
<tr height=21 style="height:15.75pt">
<td colspan=4 height=21 class=xl418312 width=251 style="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-top:1px solid black;height:12.75pt">Amount Spent</td>
<td colspan=2 class=xl398312 style="border-top:1px solid black">Shipping Rate</td>
</tr>
<tr height=17 style="height:12.75pt">
<td colspan=2 height=17 class=xl358312 style="border-top:1px solid black;height:12.75pt">$0-$25</td>
<td colspan=2 class=xl448312 style="border-top:1px 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-top:1px solid black;height:12.75pt">$25-$50</td>
<td colspan=2 class=xl318312 style="border-top:1px 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-top:1px solid black;height:12.75pt">$50-$75</td>
<td colspan=2 class=xl468312 style="border-top:1px 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-top:1px solid black;height:12.75pt">$75-$100</td>
<td colspan=2 class=xl318312 style="border-top:1px 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-top:1px solid black;height:12.75pt">$100-$125</td>
<td colspan=2 class=xl468312 style="border-top:1px 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-top:1px solid black;height:12.75pt">$125-$150</td>
<td colspan=2 class=xl318312 style="border-top:1px 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-top:1px solid black;height:12.75pt">$150-$175</td>
<td colspan=2 class=xl468312 style="border-top:1px 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-top:1px solid black;height:12.75pt">$175-$200</td>
<td colspan=2 class=xl318312 style="border-top:1px 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-top:1px solid black;height:12.75pt">$200-$225</td>
<td colspan=2 class=xl468312 style="border-top:1px 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-top:1px solid black;height:12.75pt">$225-$250</td>
<td colspan=2 class=xl318312 style="border-top:1px 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-top:1px solid black;height:12.75pt">$250-$275</td>
<td colspan=2 class=xl468312 style="border-top:1px 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-top:1px solid black;height:12.75pt">$275-$300</td>
<td colspan=2 class=xl318312 style="border-top:1px 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-top:1px solid black;height:12.75pt">$300-$325</td>
<td colspan=2 class=xl468312 style="border-top:1px 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-top:1px solid black;height:12.75pt">$325-$350</td>
<td colspan=2 class=xl318312 style="border-top:1px 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-top:1px solid black;height:12.75pt">etc.</td>
<td colspan=2 class=xl338312 style="border-top:1px solid black">etc.</td>
</table>

I'd rather be flying!

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...