Count the number of lines in an Excel File

Question

Possible Duplicate:
Efficiently counting the number of lines of a text file. (200mb+)
How do I determine the end of the file using PHPExcel library in chunk loop?

I can't seem to get this to work in PHP

I'm trying to count the number of lines in an uploaded EXcel file

Here is what I have but it always multiplies this by two and I want to remove the first row because it is just headers, please help:

$countthelines= count(file($file)) -1;

Excel files aren't text files, they're binary blobs. Are you confusing it with a CSV file perhaps? — mario, Jan 08 '13 at 22:24
Possibly but what I want to do is count the number of lines in an EXCEL file not CSV so any help would be appreciated — Dude Looking, Jan 08 '13 at 22:25
If your excel file just contains a single table you can convert your file to csv without losing data. — Benjamin Paap, Jan 08 '13 at 22:26

score 1 · Answer 1 · answered Jan 08 '13 at 22:25

1

Convert your Excel file to a CSV file and try something like this:

$countthelines = count(file($file, FILE_SKIP_EMPTY_LINES)) - 1;

answered Jan 08 '13 at 22:25

Benjamin Paap

2,744
2
21
33

But it has to be an Excel file not a CSV, any way to do that or do an inline conversion into a CSV? – Dude Looking Jan 08 '13 at 22:34

Count the number of lines in an Excel File

1 Answers1