Hi,
Do you know if there is a way to generate a formated Excel report.
I want some rows to be of different colors than the others.
Thank you
__
Get the name you've always wanted @ymail.com or @rocketmail.com! Go to
-Original Message-
From: Php Developer [mailto:pdevelo...@rocketmail.com]
Sent: Tuesday, April 20, 2010 8:30 AM
To: php-general@lists.php.net
Subject: [PHP] Excel Report Formatting
Hi,
Do you know if there is a way to generate a formated Excel report.
I want some rows
[snip]
Do you know if there is a way to generate a formated Excel report.
I want some rows to be of different colors than the others.
[/snip]
STFW or STFA much? This was posted yesterday
Stupid browser tricks
http://www.evolt.org/node/26896
--
PHP General Mailing List
-Original Message-
From: Jay Blanchard [mailto:jblanch...@pocket.com]
Sent: Tuesday, April 20, 2010 8:40 AM
To: Php Developer; php-general@lists.php.net
Subject: RE: [PHP] Excel Report Formatting
[snip]
Do you know if there is a way to generate a formated Excel report.
I want
[snip]I believe the OP wants to format the excel for download. And not
display the data in excel like in the web browser.[/snip]
He didn't specify that, but you can change the code in the article to
save the file and make available for download.
--
PHP General Mailing List
Its good to see we're all playing nice today!
--
-Dan Joseph
www.canishosting.com - Unlimited Hosting Plans start @ $3.95/month. Promo
Code NEWTHINGS for 10% off initial order
http://www.facebook.com/canishosting
http://www.facebook.com/originalpoetry
Sent: Tue, April 20, 2010 11:37:21 AM
Subject: RE: [PHP] Excel Report Formatting
-Original Message-
From: Php Developer [mailto:pdevelo...@rocketmail.com]
Sent: Tuesday, April 20, 2010 8:30 AM
To: php-general@lists.php.net
Subject: [PHP] Excel Report Formatting
Hi,
Do you know
On Tue, 2010-04-20 at 12:50 -0400, Dan Joseph wrote:
Its good to see we're all playing nice today!
It's still not an excel file but an HTML table sent with an Excel
mime-type. This is just asking for trouble if the user does not use
Excel, as it's exploiting behaviour that looks very
-Original Message-
From: Php Developer [mailto:pdevelo...@rocketmail.com]
Sent: Tuesday, April 20, 2010 9:52 AM
To: Tommy Pham; php-general@lists.php.net
Subject: Re: [PHP] Excel Report Formatting
Hi Tommy,
The code in the link is traightforward. The problem is you need
[snip]
It's still not an excel file but an HTML table sent with an Excel
mime-type. This is just asking for trouble if the user does not use
Excel, as it's exploiting behaviour that looks very particular to Excel
and not ALL spreadsheet software.
[/snip]
This is true, it is exploiting behavior
pdevelo...@rocketmail.com; php-general@lists.php.net
Sent: Tue, April 20, 2010 1:47:40 PM
Subject: RE: [PHP] Excel Report Formatting
-Original Message-
From: Php Developer [mailto:pdevelo...@rocketmail.com]
Sent: Tuesday, April 20, 2010 9:52 AM
To: Tommy Pham; php-general@lists.php.net
From: Tommy Pham tommy...@gmail.com
To: Php Developer pdevelo...@rocketmail.com; php-general@lists.php.net
Sent: Tue, April 20, 2010 1:47:40 PM
Subject: RE: [PHP] Excel Report Formatting
-Original Message-
From: Php Developer [mailto:pdevelo...@rocketmail.com]
Sent: Tuesday
[snip]
Hi, somebody knows if it is possible to open excel content in a new
window? what i want is basically initialize the headers and instead of
echo $content i want it to open in a new window. is that possible?
[/snip]
Yes, it is possible. a href= target=_blank Is this too obvious?
i want it to open in a new window. is that possible?
- Original Message
From: Tommy Pham tommy...@gmail.com
To: Php Developer pdevelo...@rocketmail.com; php-general@lists.php.net
Sent: Tue, April 20, 2010 1:47:40 PM
Subject: RE: [PHP] Excel Report Formatting
-Original
On Fri, Feb 26, 2010 at 3:47 PM, Ian Robertson
irobert...@americantextile.com wrote:
Thank you all very much for your replies.
I learned about a few new approaches.
I didn't see it come up yet, so I'll post the URL of what I have been using.
php_writeexcel -
,
wherever you are, haha.
-Original Message-
From: Jay Blanchard [mailto:jblanch...@pocket.com]
Sent: Sunday, February 21, 2010 9:44 PM
To: Ian Robertson; php-general@lists.php.net
Subject: RE: [PHP] Excel Spreadsheets and PHP
[snip]
What are you using, if anything, to create Excel
[snip]
What are you using, if anything, to create Excel spreadsheets with PHP?
[/snip]
PHP
http://www.evolt.org/node/26896
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On 19-2-2010 21:28, Ian Robertson wrote:
Hello, everyone.
Just a quick question.
What are you using, if anything, to create Excel spreadsheets with PHP?
Thank you in advance.
Hello Ian,
You can use the PHPExcel class. It can read, write and convert between
Excel versions without the
Bastien Koert wrote:
You can also create an htnl table and excel will happily handle that as well.
The real trick is to get IE to accept the stream as a file download. I
find that I need to save the file first and the push the file down.
+1 this approach; Excel is HTTP aware and you can
Hello, everyone.
Just a quick question.
What are you using, if anything, to create Excel spreadsheets with PHP?
Thank you in advance.
From: Ian Robertson
What are you using, if anything, to create Excel spreadsheets with
PHP?
Output CSV files with the correct MIME type. MS-Windows will open them
in Excel by default in both IE and Firefox.
Unfortunately, this happens even if you have Open Office installed and
would prefer
On Fri, 2010-02-19 at 15:36 -0500, Bob McConnell wrote:
From: Ian Robertson
What are you using, if anything, to create Excel spreadsheets with
PHP?
Output CSV files with the correct MIME type. MS-Windows will open them
in Excel by default in both IE and Firefox.
Unfortunately,
On Fri, Feb 19, 2010 at 3:36 PM, Bob McConnell r...@cbord.com wrote:
From: Ian Robertson
What are you using, if anything, to create Excel spreadsheets with
PHP?
Output CSV files with the correct MIME type. MS-Windows will open them
in Excel by default in both IE and Firefox.
-Original Message-
From: Ian Robertson [mailto:irobert...@americantextile.com]
Sent: Friday, February 19, 2010 1:28 PM
To: php-general@lists.php.net
Subject: [PHP] Excel Spreadsheets and PHP
Hello, everyone.
Just a quick question.
What are you using, if anything, to create
-
From: Ian Robertson [mailto:irobert...@americantextile.com]
Sent: Friday, February 19, 2010 1:28 PM
To: php-general@lists.php.net
Subject: [PHP] Excel Spreadsheets and PHP
Hello, everyone.
Just a quick question.
What are you using, if anything, to create Excel spreadsheets
with PHP
-Original Message-
From: Ian Robertson [mailto:irobert...@americantextile.com]
Sent: Friday, February 19, 2010 1:28 PM
To: php-general@lists.php.net
Subject: [PHP] Excel Spreadsheets and PHP
Hello, everyone.
Just a quick question.
What are you using, if anything
Hi,
I have the task to create excel sheet with embedded charts and graphs
through PHP. The charts are pie chart and bar chart. The project will be run
on the linux server. My question is it is possible to implement this through
PHP? If yes, then please suggest the available implementations.
On 5/2/07, Anton Krall [EMAIL PROTECTED] wrote:
Guys.. I have a problem and I was wondering if somebody with good php
knowledge could help.
I have this excel macro that converts number currency (mexican) into a
string and I was wondering if somebody could help translating it to php...
Her eis
Sie nicht auch sprechen Spanischen, Tij?
On 5/3/07, Tijnema ! [EMAIL PROTECTED] wrote:
On 5/2/07, Anton Krall [EMAIL PROTECTED] wrote:
Guys.. I have a problem and I was wondering if somebody with good php
knowledge could help.
I have this excel macro that converts number currency
On 5/3/07, Daniel Brown [EMAIL PROTECTED] wrote:
Sie nicht auch sprechen Spanischen, Tij?
Nein, aber mein deutsch ist also nicht gut ;) Sprechen sie Spanischen Daniel?\
Tijnema
On 5/3/07, Tijnema ! [EMAIL PROTECTED] wrote:
On 5/2/07, Anton Krall [EMAIL PROTECTED] wrote:
Guys.. I
On Thu, May 3, 2007 4:37 am, Tijnema ! wrote:
On 5/2/07, Anton Krall [EMAIL PROTECTED] wrote:
Guys.. I have a problem and I was wondering if somebody with good
php
knowledge could help.
I have this excel macro that converts number currency (mexican) into
a
string and I was wondering if
Tij:
Ja, spreche ich Spanischen. Me habla espanol bien no muy bien, pero
bastante bueno. Ik leer enkel het Nederlands. Het is als het Engels, maar
er is één of ander verschil.
Richard (the original, if you want it):
Guys.. I have a problem and I was wondering if somebody with
On Thu, May 3, 2007 11:17 am, Daniel Brown wrote:
Function CantidadEnLetra(tyCantidad As Currency) As String
function CantidadEnLetra ($tyCantidad) {
/*
Dim lyCantidad As Currency, lyCentavos As Currency, lnDigito As Byte,
lnPrimerDigito As Byte, lnSegundoDigito As Byte, lnTercerDigito As
On 5/3/07, Daniel Brown [EMAIL PROTECTED] wrote:
Tij:
Ja, spreche ich Spanischen. Me habla espanol bien no muy bien, pero
bastante bueno. Ik leer enkel het Nederlands. Het is als het Engels, maar
er is één of ander verschil.
Haha, dat is toch redelijk nederlands :) Dutch
Bien,
Actually, yes, about half but I didn't use a translator, dork! ;-P
On 5/3/07, Tijnema ! [EMAIL PROTECTED] wrote:
On 5/3/07, Daniel Brown [EMAIL PROTECTED] wrote:
Tij:
Ja, spreche ich Spanischen. Me habla espanol bien no muy bien,
pero
bastante bueno. Ik leer enkel het
Guys.. I have a problem and I was wondering if somebody with good php
knowledge could help.
I have this excel macro that converts number currency (mexican) into a
string and I was wondering if somebody could help translating it to php...
Her eis the macro, if you could help, I would really
for that) and HTML are both good quick and dirty
download-to-Excel options.
And as Richard mentioned, COM requires Windows, but if you want to do anything
with it, you need to have something for PHP to talk to via COM. In this
instance, we're talking about PHP + Excel.
There's little things you have
Hi all,
Can PHP be used to generate an excel file that A) Contains Macros B) Allows
Graphics to be attached C) where cells can contain borders as well as cells
being merged. I know there is some PHP excel functionality so i am assume
basics like underlines, italics and i am hoping vertical
[snip]
Can PHP be used to generate an excel file
[/snip]
http://www.php.net/com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
to be attached C) where cells can contain borders as well as cells
being merged. I know there is some PHP excel functionality so i am assume
basics like underlines, italics and i am hoping vertical alignments can be
done.
If the answer is no, then can a template that has all of these be opened and
read
Or, even better and more useful:
http://pear.php.net/package/Spreadsheet_Excel_Writer
It's not perfect, but it does the basic job.
Also, if you output an HTML table and set the content type in your header to an
Excel content type, it should ask the client PC to open the page in Excel
Jonathan Kahan wrote:
Can PHP be used to generate an excel file that A) Contains Macros B)
Allows Graphics to be attached C) where cells can contain borders as
well as cells being merged. I know there is some PHP excel functionality
so i am assume basics like underlines, italics and i am
2007. 04. 18, szerda keltezéssel 12.25-kor [EMAIL PROTECTED]
ezt írta:
Or, even better and more useful:
http://pear.php.net/package/Spreadsheet_Excel_Writer
It's not perfect, but it does the basic job.
Also, if you output an HTML table and set the content type in your header to
an
On Wed, April 18, 2007 10:46 am, Jonathan Kahan wrote:
Can PHP be used to generate an excel file that A) Contains Macros B)
Allows
Graphics to be attached C) where cells can contain borders as well as
cells
being merged. I know there is some PHP excel functionality so i am
assume
basics
On Wed, April 18, 2007 11:25 am, [EMAIL PROTECTED] wrote:
Also, if you output an HTML table and set the content type in your
header to an Excel content type, it should ask the client PC to open
the page in Excel (assuming they have it installed). This works for a
real quick and dirty
On Wed, April 18, 2007 3:42 pm, Zoltán Németh wrote:
Or you can use COM as Jay recommended, but that requires Excel to be
installed on the PC that's running PHP and can get a little ugly.
really? I thought it requires only winsuxx to be installed...
COM only requires Windows (afaik there's no
Hello all,
Am pretty new to the world of PHP. And am now stuck.
Its like i am displayin the data from a database on to my webpage in
the form of tables.
but now i also want an option for the user to download the above data
into an excel format for the offline use. I dont want to create the
excel
[snip]
please advice.
[/snip]
Have you read the documentation?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
hetawal [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 16, 2006 2:26 PM
To: php-general@lists.php.net
Subject: [PHP] Excel problem
Hello all,
Am pretty new to the world of PHP. And am now stuck.
Its like i am displayin the data from a database on to my webpage in
the form of tables
hello,
Yes i have gone through the documentation. bu ti can find a way to
link the download excel thing with the link which says donwload in
excel. Is it that i have to fetch the data 2 times , one for displayin
it in table and the other time downloadin in excel
Any suggestions
Thanks
On
On Thursday 16 November 2006 21:25, amit hetawal wrote:
Hello all,
Am pretty new to the world of PHP. And am now stuck.
Its like i am displayin the data from a database on to my webpage in
the form of tables.
but now i also want an option for the user to download the above data
into an excel
To: Jef Sullivan; php-general@lists.php.net
Subject: re: [PHP] Excel Spreadsheet Writer
Jef,
Hello, Knowing nothing about Excel Writer at the start, I thought I would
tackle this...
I found all of the pieces on the net and copied to my webserver...
I got the same results you did
Greetings all,
I am having some problems with the Excel Spreadsheet Writer and I am hoping
that I can get some help from
this group. I am getting garbled text in my spreadsheet when I go to run the
php file. I created a general file to
see if I could narrow the problem down. No luck so
Hi to all!
Have to create a script to select excel file and store info from the
file in existing table (mysql).
After some research found the best way will be save excel (xls) file as
csv comma delimited file and then store info in table.
For first step I just used in Excel app File Save As..
Afan Pasalic wrote:
?php
#names of columns in products table
$column_names = array('ITEM NUMBER', 'ITEM NAME', 'DESCRIPTION',
'COLORS', 'INCLUDES', 'QTY', 'PRICE', 'IMAGE', 'THUMB', 'CATALOG',
'STATUS', 'SUPPLIER', 'EXP_DATE');
if(isset($_POST['SubmitExcelFile']))
{
#VALIDATING
I have been looking but have not found yet of a way to generate an excel
file with multiple pages using a PHP page. I was hoping someone here
might have hit on a multiple page document. I can do a single file, but
was looking for something a little more powerful before I try to create
my own.
[snip]
I have been looking but have not found yet of a way to generate an excel
file with multiple pages using a PHP page. I was hoping someone here
might have hit on a multiple page document. I can do a single file, but
was looking for something a little more powerful before I try to create
my
06, 2004 5:15 PM
To: jon roig
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] PHP, Excel, and tab delimited files question
jon roig wrote:
Nah... Try it in excel itself and you'll see what I'm talking about.
You have to do it in numeric fields.
Do this in an excel field:
- Type 10 and hit
[snip]
Right... But the principal is still the same. Excel handles those types
of fields in a uniform way, regardless of whether you do the entry
yourself or if you just import a csv file.
[/snip]
Actually that is not correct. We have prefaced the data with the single
quote in the output process
It may wind up being a user-learning issue.
I dump things to pipe delimited file (whether in *nix land or winDoze)
and that way the users can open it in Excel. The ones who have to open
the files I just go to their desks the first time and show them how to
open the file, delimit it on the | and
In many of our apps we save tab delimited text files to be later opened
from the browser using the following set of headers;
header(Content-Type: application/vnd.ms-excel);
header(Content-Disposition: inline; filename=\excel.xls\);
header(Expires: 0);
header(Cache-Control: must-revalidate
:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 2:40 PM
To: [EMAIL PROTECTED]
Subject: [PHP] PHP, Excel, and tab delimited files question
In many of our apps we save tab delimited text files to be later opened
from the browser using the following set of headers;
header(Content-Type
[snip]
Don't do it in the header, but in the field itself just put a ' before
the first character and excel will interpret it as a text field.
[/snip]
Tried that, the ' shows up. Don't want that to happen
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
Do double quotes around help?
Jay Blanchard wrote:
[snip]
Don't do it in the header, but in the field itself just put a ' before
the first character and excel will interpret it as a text field.
[/snip]
Tried that, the ' shows up. Don't want that to happen
--
PHP General Mailing List
: Friday, February 06, 2004 3:02 PM
To: Jay Blanchard
Cc: jon roig; [EMAIL PROTECTED]
Subject: Re: [PHP] PHP, Excel, and tab delimited files question
Do double quotes around help?
Jay Blanchard wrote:
[snip]
Don't do it in the header, but in the field itself just put a ' before
the first character
jon roig wrote:
Nah... Try it in excel itself and you'll see what I'm talking about. You
have to do it in numeric fields.
Do this in an excel field:
- Type 10 and hit return.
... It becomes 10, right?
Now try it like this: '000100
... Tada! It stays as 00100 and puts a little green tab in the
Hi everyone. I'm outputing payroll information to an excel csv file, and when anyone
get's paid over 1k, the amount is split into two fields because of the comma in the
amount. Is there anyway I can tell excel that this particular comma is not a
deliminator?
Thanks,
Jake
On Sat, 7 Feb 2004, Jake McHenry wrote:
Hi everyone. I'm outputing payroll information to an excel csv file, and when anyone
get's paid over 1k, the amount is split into two fields because of the comma in the
amount. Is there anyway I can tell excel that this particular comma is not a
hi~
I want generate an excel table download it as a file (not view in IE), what HTML
mimetype should i use?
leon
[EMAIL PROTECTED]
2003-11-24
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[snip]
I want generate an excel table download it as a file (not view in IE),
what HTML mimetype should i use?
[/snip]
header(Content-Type: application/vnd.ms-excel);
header(Content-Disposition: inline; filename=\excel.xls\);
header(Expires: 0);
header(Cache-Control: must-revalidate,
Jay Blanchard wrote:
[snip]
I want generate an excel table download it as a file (not view in
IE), what HTML mimetype should i use? [/snip]
header(Content-Type: application/vnd.ms-excel);
header(Content-Disposition: inline; filename=\excel.xls\);
header(Expires: 0);
Hi, is there a way to create excel files with php?
Thanks.
Paul
GnuPG Key http://sgi.rdscv.ro/~paulm/paulm.PGP
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi, is there a way to create excel files with php?
Thanks.
This was answered yesterday and I'm way too lazy to type out my reply again.
Here is an archive search on the word 'excel'
http://marc.theaimsgroup.com/?l=php-generalw=2r=1s=excelq=b
Here is yesterday's thread
:)...stupid me :), 10x
Paul
GnuPG Key http://sgi.rdscv.ro/~paulm/paulm.PGP
On Thu, 18 Sep 2003, Jennifer Goodie wrote:
Hi, is there a way to create excel files with php?
Thanks.
This was answered yesterday and I'm way too lazy to type out my reply again.
Here is an archive search on
Good morning!
I have several reports that are generated using PHP MySQL for which I
would like to include a graph using the excellent jpgraph
(http://www.aditus.nu/jpgraph/) class for PHP.
?php
ob_start();
// excel headers
header(Content-Type: application/vnd.ms-excel);
You need a class that can create xls files with images.
Or you can create a Web Archive:
http://officeupdate.microsoft.com/office/webarchive.htm
Jay Blanchard wrote:
Good morning!
I have several reports that are generated using PHP MySQL for which I
would like to include a graph using the
[snip]
You need a class that can create xls files with images.
Or you can create a Web Archive:
http://officeupdate.microsoft.com/office/webarchive.htm
[/snip]
Thanks! We have looked at this, but have arrived at the problem of
opening the file for the user. Here is the process in a nutshell...
Jay Blanchard wrote:
[snip]
You need a class that can create xls files with images.
Or you can create a Web Archive:
http://officeupdate.microsoft.com/office/webarchive.htm
[/snip]
Thanks! We have looked at this, but have arrived at the problem of
opening the file for the user.
This should
Hi all,
Does anyone know of any free Excel parsing non-COM code available on the
net? Just straight php driven?
I've found a couple commercial solutions but would like to try this myself
or save money. Thanks for any help.
Johnny
--
PHP General Mailing List (http://www.php.net/)
To
snip
Does anyone know of any free Excel parsing non-COM code available on
the
net? Just straight php driven?
/snip
I have not tried any of these but there might be something in here you
can use.
http://www.phpclasses.org/search.html?words=Excelgo_search=1
--
PHP General Mailing List
Hi,
Friday, July 11, 2003, 4:27:13 AM, you wrote:
JM Hi all,
JM Does anyone know of any free Excel parsing non-COM code available on the
JM net? Just straight php driven?
JM I've found a couple commercial solutions but would like to try this myself
JM or save money. Thanks for any help.
JM
PROTECTED]
Subject: RE: [PHP] excel 2 csv 2 mysql
Pretty cool, man... I actually didn't know about xls2csv.
Learn something new every day -- this'll certainly come in handy.
'Course, it's not exactly standard with most distributions. For anyone
looking for it, you can download it here:
http://www
PROTECTED]
Sent: Tuesday, April 01, 2003 1:26 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; daniel
Subject: RE: [PHP] excel 2 csv 2 mysql
ok i've built a class to acomplish this now
class Export_Excel {
var $command
function Export_Excel() {
$this-command = /www_tools
Justin,
For reading, you could try this:
http://www.zakkis.ca/products/abc_excelparser/index.php
Cost is 150 CAD - quite steep. Tried the online demo - seems to work. Will only work
with cells containing strings though - doesn't resolve formulae. If
you purchase it, perhaps you could let me
http://jonroig.com
-Original Message-
From: daniel [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 7:48 PM
To: [EMAIL PROTECTED]
Subject: [PHP] excel 2 csv 2 mysql
hi guys i am trying to work out how to dynamically be able to upload an
excel
file , export it to csv to be able to import
, 2003 1:47 PM
To: Gabi Moise; [EMAIL PROTECTED]
Subject: Re: [PHP] Excel
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Not exactly, but http://pear.php.net/package-info.php?pacid=156
On Thursday 27 March 2003 05:47 am, Gabi Moise wrote:
Hi,
Can someone point me to a php and Excel tutorial
hi guys i am trying to work out how to dynamically be able to upload an excel
file , export it to csv to be able to import into mysql , is there any
examples out there ? fopen gave me binary code :|
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
to upload csv files.
- jon
-
jon roig
senior manager, online production
epilepsy foundation
http://jonroig.com
-Original Message-
From: daniel [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 7:48 PM
To: [EMAIL PROTECTED]
Subject: [PHP] excel 2 csv 2 mysql
hi
on 01/04/03 11:48 AM, daniel ([EMAIL PROTECTED]) wrote:
hi guys i am trying to work out how to dynamically be able to upload an excel
file , export it to csv to be able to import into mysql , is there any
examples out there ? fopen gave me binary code :|
also see fgetscsv()
Justin
--
PHP
-Original Message-
From: daniel [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 7:48 PM
To: [EMAIL PROTECTED]
Subject: [PHP] excel 2 csv 2 mysql
hi guys i am trying to work out how to dynamically be able to upload an
excel
file , export it to csv to be able to import into mysql
PROTECTED]
Sent: Monday, March 31, 2003 7:48 PM
To: [EMAIL PROTECTED]
Subject: [PHP] excel 2 csv 2 mysql
hi guys i am trying to work out how to dynamically be able to upload an
excel
file , export it to csv to be able to import into mysql , is there any
examples out there ? fopen gave me binary
-
jon roig
senior manager, online production
epilepsy foundation
http://jonroig.com
-Original Message-
From: daniel [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 7:48 PM
To: [EMAIL PROTECTED]
Subject: [PHP] excel 2 csv 2 mysql
hi guys i am trying to work out how
http://jonroig.com
-Original Message-
From: daniel [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 7:48 PM
To: [EMAIL PROTECTED]
Subject: [PHP] excel 2 csv 2 mysql
hi guys i am trying to work out how to dynamically be able to upload an
excel
file , export it to csv to be able
Hi,
Can someone point me to a php and Excel tutorial?
tnx.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Not exactly, but http://pear.php.net/package-info.php?pacid=156
On Thursday 27 March 2003 05:47 am, Gabi Moise wrote:
Hi,
Can someone point me to a php and Excel tutorial?
tnx.
- --
First they came for the Communists, and I didn't speak up,
Does anyone know of a FREE utility that will export data from an MS
Excel file and import it to MySQL. I have found a bunch of nice
utilities, but none of them are FREE. I'm in a bind and have to get
over 2000 rows imported to my database by morning and don't have to
order one of the other
PROTECTED]
Subject: [PHP] Excel to MySQL
Does anyone know of a FREE utility that will export data from an MS
Excel file and import it to MySQL. I have found a bunch of nice
utilities, but none of them are FREE. I'm in a bind and have to get
over 2000 rows imported to my database by morning
I think BiffWriter might do it...
By why not simply output a comma delimited files from excel and import it in with a
small php script.
Mike
*** REPLY SEPARATOR ***
On 03/01/2003 at 2:20 PM Joe LoMoglio wrote:
Does anyone know of a FREE utility that will export data from
Thanks Michael and Richard
I took your advice and wrote a PHP script to import it. I was having a
hard time getting Excel on my Mac to export to CSV and Tab Delim, but
finally got it to give me a plain text file which worked fine with
fopen().
Joe
On Friday, January 3, 2003, at 02:32 PM,
Does anyone know of a FREE utility that will export data from an MS
Excel file and import it to MySQL. I have found a bunch of nice
utilities, but none of them are FREE. I'm in a bind and have to get
over 2000 rows imported to my database by morning and don't have to
order one of the other
1 - 100 of 127 matches
Mail list logo