I am not clear on what you want!
You want to read Excel Sheet that have data spread over several sheets. Your
current script return result from the first sheet only (sheet index is 0).
>From the script you have posted I can see that the script count the number of
>rows in the first sheet ' $totalrow=$data->rowcount($sheet_index=0); ' and
>search/filter the data in the first sheet only '
>$data2=$data->val($startno+$i,2); '.
If you want to search/filter data from all XSL file you have to loop all of the
sheets in the file and filter the result or combined the data from all sheets
and then filter it. Read the documentations
http://code.google.com/p/php-excel-reader/wiki/Documentation for more details
on how to do it.
CheersMohamed
Date: Wed, 27 Jul 2011 11:34:38 +0800
Subject: Re: [phpug] PHP with Excel Sheet
From: [email protected]
To: [email protected]
Hi there.
on the reader php file , as u said earlier , its define as 0 "
val($row,$col,$sheet=0) " , so do i need to make changes on it? or is that okay
to leave it like that?
and my scripts should work rite. but its giving result from first result page
only. unable to get data from balance pages.
("" $totalrow=$data->rowcount($sheet_index=1);
$rows=20;if ($_GET['page']!="")
$page=$_GET['page'];
else
$page=1; "")
is there any wrong here to get data from all pages?
On Wed, Jul 27, 2011 at 11:15 AM, S.Mohammed Alsharaf <[email protected]>
wrote:
Yes you are right. the script you have should work for one sheet.
Sheet index starts with 0 not 1.
CheersMohammed
Blog: http://jamandcheese-on-phptoast.com/Email: [email protected]
Mobile: 012 139 5924
Date: Wed, 27 Jul 2011 10:22:10 +0800
Subject: Re: [phpug] PHP with Excel Sheet
From: [email protected]
To: [email protected]
Hi Mohammed,
Thanks for ur msg, and i wanna say something here and i need ur advice .
1) i have 1 sheet only in my xls file, which is sheet 1. with 150 rows only.
2) i think the 2 points u indicate here, its wont be a problem here. am i right?
im expecting ur advice on this.
thnx..
On Wed, Jul 27, 2011 at 6:51 AM, S.Mohammed Alsharaf <[email protected]>
wrote:
Hi
If you search the reader php file, you will find a call to the val() function.
There is a third parameter ' $sheet '. I think this is the sheet index. '
val($row,$col,$sheet=0) '
In the script below:1. $totalrow=$data->rowcount($sheet_index=0);
you always returning the total number of rows in the first sheet
2. $data2=$data->val($startno+$i,2); return the value at, - row number
$startno+$i
- column number 2 - no sheet index specified. The default number is 0,
which is the first sheet.
CheersMohammed
Blog: http://jamandcheese-on-phptoast.com/Email: [email protected]
> Date: Mon, 25 Jul 2011 22:38:27 -0700
> Subject: [phpug] PHP with Excel Sheet
> From: [email protected]
> To: [email protected]
>
> Hi.
>
> im doing a php page which is retrieving data from xls sheet and its
> works well the xls sheet having 150 records. its limited to 20 records
> per page to show on result page .there is a search box and button to
> search some specific data , the search parameter giving the result
> from first page result only. i can't get result from full excel sheet.
>
> $searchparameter=$_GET['searchparameter'];
> $totalrow=$data->rowcount($sheet_index=0);
> $rows=20;
> if ($_GET['page']!="")
> $page=$_GET['page'];
>
> else
> $page=1;
> echo 'table';
>
>
>
> $count=0;
> $recordno=1;
> for($i=0;$i<$totalrow-6;$i++)
> {
>
> if((($page-1)*$rows)<=$i && $i<=($page*$rows))
> {
> //$data1=$data->val($startno+$i,1);
> $data2=$data->val($startno+$i,2);
> $data3=$data->val($startno+$i,3);
> $data4=$data->val($startno+$i,6);
>
>
> if((stristr($data2,$searchparameter) ||
> stristr($data3,$searchparameter)|| stristr($data4,$searchparameter))||
> $searchparameter=="")
> {
> echo 'table';
> }
>
>
> i dont understan whats wrong here, y can't search full records on xls
> sheet.
> im expecting some ones help to solve my problem.
> thnxx..
>
> --
> NZ PHP Users Group: http://groups.google.com/group/nzphpug
> To post, send email to [email protected]
> To unsubscribe, send email to
> [email protected]
--
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to [email protected]
To unsubscribe, send email to
[email protected]
--
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to [email protected]
To unsubscribe, send email to
[email protected]
--
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to [email protected]
To unsubscribe, send email to
[email protected]
--
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to [email protected]
To unsubscribe, send email to
[email protected]
--
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to [email protected]
To unsubscribe, send email to
[email protected]
