count last row in a excel file

[ganesanji]

Hi all,


I have written a php coding for uploading a csv file to database. I want to know the last row of the csv file. How to calculate the the last row of the excel file using php coding. Please anyone give me help.... I am not good in english if u found any mistake in my words plz dont mistake me......

Please send me the php coding to calculate the last row of excel file....


thanks.

[Atli]

Hi.

Have you made any attempt at this yourself?
Could we see what you did?
Why (how) did it not work?
Are you getting any errors?

We are more than happy to help you solve problems you are having with your code, but we won't write the code for you.

[ganesanji]

Hi.

Have you made any attempt at this yourself?
Could we see what you did?
Why (how) did it not work?
Are you getting any errors?

We are more than happy to help you solve problems you are having with your code, but we won't write the code for you.

<?php
session_start();
?>
<?php
  $name1=$_SESSION['name'];  
  $file1=$_SESSION['path'];
  echo $file1;
  echo "<br/>";
  require_once('reader.php'); // include the class
  $data = new Spreadsheet_Excel_Reader(); // instantiate the object
  $data->setOutputEncoding('CP1251'); // select output encoding
  $data->read("$file1/*.xls"); // specify the file to read
/* We start reading the file from row 4 because that's where the 
  data in the table starts */
   $startRow = 2;
 
/* Get all the cells of the sheet */
  $cells = $data->sheets[0]['cells'];
/* We create a nice table to display the data */
//  echo "<table border='1' style='font-size:14px;font-family:Arial;'>
//  <tr><td>Phone No.</td><td>First Name</td><td>Last Name</td><td>Address1</td><td>Address2</td><td>State</td><td>City</td>
//  <td>Zip</td></tr>";
/* Loop through the table. In this case we know that the table has only
  4 rows.*/
  for ($row = $startRow;$row <= 10;$row++) 
 
  {
  /* Assign all the columns */
  $phone = $cells[$row][1]; 
  $firstname = $cells[$row][2];
  $lastname = $cells[$row][3];
  $address1 = $cells[$row][4];
  $address2 = $cells[$row][5];
  $state = $cells[$row][6];
  $city = $cells[$row][7];
  $zip = $cells[$row][8];
  $id = $cells[$row][9];
 /* Then display them 
  echo "<tr><td>" . $phone . "</td>";
  echo "<td>" . $firstname . "</td>";
  echo "<td>" . $lastname . "</td>";
  echo "<td>" . $address1 . "</td>";
  echo "<td>" . $address2 . "</td>";
  echo "<td>" . $state . "</td>";
  echo "<td>" . $city . "</td>";
  echo "<td>" . $zip . "</td>";
  echo "<td>" . $id . "</td></tr>";  */
  mysql_connect('localhost','root','123456');
  mysql_select_db("dialer");  
  mysql_query("insert into $name1(phone,firstname,lastname,address1,address2,state,city,zip)values('$phone','$firstname',
  '$lastname','$address1','$address2','$state','$city','$zip')");  
  }
  echo "Successfully Inserted";
  ?>
 

In this code I used one for loop that loop I specified the range limit that is 10 ,
we don't know how many rows data is there .so that I want the last
row in every file how to find .

[Atli]

OK. I think I understand how the Spreadsheet_Excel_Reader object works.

You should be able to find the last row somewhat like this:

# Get first sheet
$sheet = $data->sheets[0];
 
# Get all rows in the sheet
$rows = $sheet['cells'];;
 
# Find total number of rows
$rowCount = count($rows);
 
# Show data from last row
echo "<table><tr>";
foreach($rows[$rowCount -1] as $col) {
  echo "<td>$col</td>";
}
echo "</tr></table>";
 

P.S.
Please use [code] tags when posting source code. It is impossible to read your code without them!

[ganesanji]

hi Atli,

I thank a lot.........
Its now working perfectly.......

Again thank a lot...........

[zensunni]

May I ask where you got that reader.php script? I would like very much to be able to read xls documents.

Thanks.

[Atli]

Hi.

I Googled the class name and I found this link.

I think this is what he is using, tho there may be a small bug in the reader.php code. Namely the require_once function at line 31 may need to be altered to fit the downloaded files.

[vannthns]

@Atli

where to download the 'OLERead.php' file that required in line 31..?

[johny10151981]

I didnt read your code.

But from you initial question I am totally confused.

I want to know the last row of the csv file. How to calculate the the last row of the excel file using php coding.

What do you want last row of csv file or last row or excel file or both?

do you actually need last row of the file or count of rows?

in case of php you dont need any special software. But in case of excel I would suggest you to try PHPExcel. If you download PHPExcel you will also get OLERead.php file.