October 13, 2008, 02:32:25 *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Add your links to our directory. Click here to add your links.
 
  Home   Forum   Help Search Directory Calendar Login Register    RSS 2.0 feedAtom feed


News
Add your links to our directory. Click here to add your links.
IT Resources
Pages: [1]
« previous next »
  Print  
Author Topic:

Importing cells from Excel into Tables in PHP

 (Read 799 times)
0 Members and 1 Guest are viewing this topic.
drunkenglishman
Jr. Member
**

Points: 0
Offline Offline

Posts: 7
« on: February 07, 2007, 18:00:59 »
Does anyone know how I do this? I have a feeling it's the same as in HTML, however, when I try to import from Excel, I get the whole worksheet and not the cells I need...


Can anyone shed some light on it please?

Thanks
Logged


TheGodFather
Administrator
Hero Member
*****

Points: 202
Offline Offline

Posts: 2570



WWW
« Reply #1 on: February 07, 2007, 20:02:41 »
Do you want to read an xls file in php ?

Read the info from this link  http://www.phpclasses.org/browse/package/1919.html... it also provides some code examples ... but you need to register there Smiley

Regards
Logged
█ Deleted Domains
█ Hostmaster Web Tools
█ Webmaster Web Tools
drunkenglishman
Jr. Member
**

Points: 0
Offline Offline

Posts: 7
« Reply #2 on: February 07, 2007, 20:55:12 »
Either a .xls file or .csv file

But thank you, I shall register and read your suggestion...

Thank you! Smiley
Logged
TheGodFather
Administrator
Hero Member
*****

Points: 202
Offline Offline

Posts: 2570



WWW
« Reply #3 on: February 07, 2007, 21:39:21 »
csv is more simple ... just "explode" line by line after comma (,) Smiley

Regards
Logged
█ Deleted Domains
█ Hostmaster Web Tools
█ Webmaster Web Tools
drunkenglishman
Jr. Member
**

Points: 0
Offline Offline

Posts: 7
« Reply #4 on: February 07, 2007, 21:54:02 »
I'm sorry! I have no idea what that means!

To be honest, the link you sent me was a little alien to me and I don't understand what the guy is saying. I'm just kind of looking for instructions in plain English.

I'm a bit of a dummy when it comes to this and I'm a total novice.

Sorry, maybe I should just stick to plain html!

Regards
Logged
TheGodFather
Administrator
Hero Member
*****

Points: 202
Offline Offline

Posts: 2570



WWW
« Reply #5 on: February 07, 2007, 22:37:51 »
Just try to learn some php ... is not so hard... anyway a fast solution is:
Code:
<?php
$row = 1;
$handle = fopen("test.csv", "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
   $num = count($data);
   echo "<p> $num fields in line $row: <br /></p>\n";
   $row++;
   for ($c=0; $c < $num; $c++) {
       echo $data[$c] . "<br />\n";
   }
}
fclose($handle);
?>

http://www.php.net/fgetcsv

Regards
Logged
█ Deleted Domains
█ Hostmaster Web Tools
█ Webmaster Web Tools
Pages: [1]
  Print  
« previous next »
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.4 | SMF © 2006, Simple Machines LLC
Seo4Smf v0.2 © Webmaster's Talks
TinyPortal v0.9.7 © Bloc 		Valid XHTML 1.0! Valid CSS!