Hi,
*Heres the documentation:*
http://phpexcel.codeplex.com/releases/view/45412#DownloadId=212183
In user doc:
*4.2 Reading Only Named WorkSheets from a File*
*
*
and you can get all the sheet names:
http://www.auditbureau.org.au/a/Documentation/API/PHPExcel/PHPExcel.html#methodgetSheetNames
Wish I had heard PHPExcel before. I'm using a class to read excel files.
Ege.
Alinti Floyd Resler
Does anyone have much experience with PHPExcel? I'm having
difficulties in getting multiple sheet workbooks to work properly.
I haven't been able to find any practical examples.
Thanks!
Thanks Jessen/Marc, though the user provided format can be in xls, xlsx, or
csv. So i need a solution to support all formats.
Thanks for the ideas shiplu I'll get with the team and see if there's
anything there we aren't trying.
Chris.
On Mon, Oct 4, 2010 at 3:01 PM, shiplu wrote:
> On Tue,
On Tue, Oct 5, 2010 at 12:39 AM, chris h wrote:
> I'm currently working on a project that requires the parsing of excel files.
> Basically the user uploads an excel file, and then a script needs to save a
> row in a Postgres database for each row in the excel file. The issue we are
> having is t
I use this: http://code.google.com/p/php-csv-parser/
No idea if it's any better than your current solution. I presume
you've tried extending PHP's memory limit?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
chris h wrote:
> I'm currently working on a project that requires the parsing of excel
> files. Basically the user uploads an excel file, and then a script
> needs to save a row in a Postgres database for each row in the excel
> file. The issue we are having is that when we task PHPExcel with
>
Shawn McKenzie wrote:
On 7/3/08, Dan Shirah <[EMAIL PROTECTED]> wrote:
GOT IT!!!
I changed my code to the following:
$sql = "SELECT * FROM brev_pending_summary_detail WHERE name =
'$name_code'";
if (!empty($case_age)) {
$sql.=" AND case_age_group = '$case_age'";
}
if (!empty($case_cat))
Dan Shirah wrote:
GOT IT!!!
I changed my code to the following:
$sql = "SELECT * FROM brev_pending_summary_detail WHERE name =
'$name_code'";
if (!empty($case_age)) {
$sql.=" AND case_age_group = '$case_age'";
}
if (!empty($case_cat)) {
$sql.=" AND case_category = '$case_cat'";
}
if (
On 7/3/08, Dan Shirah <[EMAIL PROTECTED]> wrote:
GOT IT!!!
I changed my code to the following:
$sql = "SELECT * FROM brev_pending_summary_detail WHERE name =
'$name_code'";
if (!empty($case_age)) {
$sql.=" AND case_age_group = '$case_age'";
}
if (!empty($case_cat)) {
$sql.=" AND case_ca
Dan Shirah wrote:
UGH!
I am now constantly getting an error of "PHP Fatal error: Allowed memory
size of 16777216 bytes exhausted (tried to allocate 936 bytes) on line 689"
Is there a way to continuously write to the file and avoid getting this
error?
On 7/3/08, Dan Shirah <[EMAIL PROTECTED]>
I changed the max memory limit to 512MB and the max timeput to 60...
I'm trying to export a report that only has 3,600 rows and it still exceeds
my memory size/timeout.
any suggestions that I could make to my code to make it more efficient and
not use up so much memory?
On 7/3/08, Mario Guenter
On Thu, Jul 03, 2008 at 02:36:18PM -0400, Dan Shirah wrote:
> UGH!
>
> I am now constantly getting an error of "PHP Fatal error: Allowed memory
> size of 16777216 bytes exhausted (tried to allocate 936 bytes) on line 689"
>
> Is there a way to continuously write to the file and avoid getting this
Richard Heyes wrote:
*doh* I took for granted someone else had the date right... I rarely
know what day it is :)
It's not often I know what day it is... :-)
Oops, sorry, I read your message wrong.
--
Richard Heyes
Employ me:
http://www.phpguru.org/cv
--
PHP General Mailing List (http://www
*doh* I took for granted someone else had the date right... I rarely
know what day it is :)
It's not often I know what day it is... :-)
--
Richard Heyes
Employ me:
http://www.phpguru.org/cv
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
But this isn't a day of celebration for you guys, Richard, to be sure.
Depends how you look at it. My passing out parade (Navy not booze) was
on the 4th July.
Do you all just ignore the day, or do you hold some kind of
anti-celebration?
Well for me personally it's just another day. Can't s
UGH!
I am now constantly getting an error of "PHP Fatal error: Allowed memory
size of 16777216 bytes exhausted (tried to allocate 936 bytes) on line 689"
Is there a way to continuously write to the file and avoid getting this
error?
On 7/3/08, Dan Shirah <[EMAIL PROTECTED]> wrote:
>
> GOT IT!!
GOT IT!!!
I changed my code to the following:
$sql = "SELECT * FROM brev_pending_summary_detail WHERE name =
'$name_code'";
if (!empty($case_age)) {
$sql.=" AND case_age_group = '$case_age'";
}
if (!empty($case_cat)) {
$sql.=" AND case_category = '$case_cat'";
}
if (!empty($case_status)
On Thu, 2008-07-03 at 16:36 +0100, Richard Heyes wrote:
> >> Happy 4th of July!
> >
> > How did you know it was my sisters birthday today? Been an exciting
> > week, first Canada's birthday was on Monday, now my sister's birthday
> > today. What a thrill ride.
>
> Isn't it the 3rd?
*doh* I took
So how would I go about getting each result from my query into the
columns/rows?
Should I do my query, and then assign the first column to an array, the
second to another array, etc?
And then try to loop it using $i to count each row?
And just FYI, I put Happy 4th (even though today is the 3rd)
> -Original Message-
> From: David Giragosian [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 03, 2008 11:19 AM
> To: php-general@lists.php.net
> Subject: Re: [PHP] PHPExcel
>
> On 7/3/08, Shawn McKenzie <[EMAIL PROTECTED]> wrote:
>
> > Richard Heye
On 7/3/08, Shawn McKenzie <[EMAIL PROTECTED]> wrote:
> Richard Heyes wrote:
>
>> Happy 4th of July!
>>>
>>> How did you know it was my sisters birthday today? Been an exciting
>>> week, first Canada's birthday was on Monday, now my sister's birthday
>>> today. What a thrill ride.
>>>
>>
>> I
Richard Heyes wrote:
Happy 4th of July!
How did you know it was my sisters birthday today? Been an exciting
week, first Canada's birthday was on Monday, now my sister's birthday
today. What a thrill ride.
Isn't it the 3rd?
It is in the great Republic of Texas.
-Shawn
--
PHP General Mailin
Happy 4th of July!
How did you know it was my sisters birthday today? Been an exciting
week, first Canada's birthday was on Monday, now my sister's birthday
today. What a thrill ride.
Isn't it the 3rd?
--
Richard Heyes
Employ me:
http://www.phpguru.org/cv
--
PHP General Mailing List (http:/
On Thu, 2008-07-03 at 08:59 -0400, Dan Shirah wrote:
> Happy 4th of July!
How did you know it was my sisters birthday today? Been an exciting
week, first Canada's birthday was on Monday, now my sister's birthday
today. What a thrill ride.
>:)
Cheers,
Rob.
> I am having a little bit of a proble
Dan Shirah wrote:
Jim,
I placed it above like you said, but i get the same result. I think I need
to do something like the below:
if(!empty($query)) {
while ($row = ifx_fetch_row($query)) {
for ($i = 3; $i <= 50; $i++) {
$stat_year = $row['stat_year'];
$stat_month = $row['stat_month'];
$name
Jim,
I placed it above like you said, but i get the same result. I think I need
to do something like the below:
if(!empty($query)) {
while ($row = ifx_fetch_row($query)) {
for ($i = 3; $i <= 50; $i++) {
$stat_year = $row['stat_year'];
$stat_month = $row['stat_month'];
$name = $row['_name'];
$
Dan Shirah wrote:
Happy 4th of July!
I am having a little bit of a problem using PHPExcel. I think I'm doing
everything right but apparently not! I am basically trying to output results
of a query to Excel using PHPExcel.
My query works fine, my variables are being passed correctly, my database
27 matches
Mail list logo
