|
|
Posted by Hemanth on 11/04/05 20:34
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.
- Hemanth
Navigation:
[Reply to this message]
|