|
|
Posted by Jeff North on 11/04/05 22:51
On 4 Nov 2005 10:34:21 -0800, in comp.lang.php "Hemanth"
<hemanth.singamsetty@gmail.com> wrote:
>|
>| Jeff North wrote:
>| > On 3 Nov 2005 16:26:33 -0800, in comp.lang.php "Hemanth"
>| > <hemanth.singamsetty@gmail.com> wrote:
>| >
>| > >| Hello there,
>| > >|
>| > >| I'm trying to read an excel worksheet (with more than 5000 rows and 30
>| > >| columns) using PHP. I'm using the "excelreader" script I found over the
>| > >| web - http://sourceforge.net/projects/phpexcelreader/.
>| > >|
>| > >| Seems to me, the script reads the values in all cells correctly and
>| > >| stores the total number of rows and columns existing in the worksheet
>| > >| (For example, in the excel file I'm using - total rows: 5375 and cols:
>| > >| 37). The problem is when I try to print the values as a HTML table
>| > >| (using two for loops), the script prints only first 236 rows and stops
>| > >| execution. The following is the code snippet I use:
>| > >|
>| > >| for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++)
>| > >| {
>| > >| echo "<TR>";
>| > >| for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++)
>| > >| {
>| > >| echo "<TD>".$data->sheets[0]['cells'][$i][$j];
>| > >| }
>| > >| echo "<BR>";
>| > >| }
>| >
>| > You might want to put a closing </td> and </tr> at the end of your
>| > statements. You could get away with this years ago but browsers are
>| > becoming more unforgiving (thank goodness).
>| >
>|
>| .....I don't see that as a problem. Anyway, I placed the closing tags
>| but it didn't help.
OK, now put some echo statements in the read loop to see what is
actually coming in and being processed.
Also have a look at the spreadsheet row 236. Is there anything strange
within that row that could be causing problems?
---------------------------------------------------------------
jnorthau@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------
Navigation:
[Reply to this message]
|