On Monday 29 November 2010,
"464450826" <464450...@qq.com> wrote:
> Hello,
Hello...
>
> I want to convert excel files and word files to HTML.
> Which php class could I use for this task?
> tks
Try the PEAR libraries:
Excel:
http://pear.php.net/search.php?q=excel&in=packages&x=0&y=0
Pro
i want it to open in a new window. is that possible?
>
>
>
> - Original Message
> From: Tommy Pham
> To: Php Developer ; php-general@lists.php.net
> Sent: Tue, April 20, 2010 1:47:40 PM
> Subject: RE: [PHP] Excel Report Formatting
>
> > -Original M
[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. Is this too obvious?
My apologies, I
> - Original Message
> From: Tommy Pham
> To: Php Developer ; 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...@rocketmai
@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
> Subject: Re: [PHP] Excel Re
[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 tha
> -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 traightforwa
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 partic
bject: 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
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
[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 (http://www.php.net/
> -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 fo
[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 (http://www.php.
> -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
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
http://c
On Fri, Feb 26, 2010 at 3:47 PM, Ian Robertson
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 -
> http://www.bettina-attack.de/jonny/view.php/projects/
his 3 Bettinas,
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,
[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
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 ca
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 ne
> >> -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
> >>
> >> H
t; 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.
>>
>> Wha
> -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.
>
>
On Fri, Feb 19, 2010 at 3:36 PM, 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, 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.
>
> Unfortu
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
Hello, everyone.
Just a quick question.
What are you using, if anything, to create Excel spreadsheets with PHP?
Thank you in advance.
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.
Thank
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 enke
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
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
>
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 goo
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
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:
> >
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 currenc
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
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 appre
e commas or you
properly compensate 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
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
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 expor
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 s
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
>
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, ital
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
(assuming
s
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 alignments can be
done.
If the answer is no, then can a template that has all of these be
[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
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
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
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 11/16/
ROTECTED]
> 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 tab
[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
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 f
: 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 far
Anyone know of any PHP based Excel Reader code that handles the
proprietary Microsoft 'hyperlink' field?
I found and tried two options already but neither handle the 'hyperlink' field:
http://www.zakkis.ca/products/index.php?s=1&p=32
http://sourceforge.net/projects/phpexcelreader/
TIA
--
Gre
Afan Pasalic wrote:
> #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
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..
[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 o
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. No
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 t
[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 a
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:
&
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
> d
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
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 t
jer [mailto:[EMAIL PROTECTED]
Sent: 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
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 (http://www.p
[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: http://www.php.net/
rd [mailto:[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(&qu
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-revalidat
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");
> hea
[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, p
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
:)...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 se
> 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-general&w=2&r=1&s=excel&q=b
Here is yesterday's thread
http://marc.theai
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
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 be
[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...
U
the excellent jpgraph
(http://www.aditus.nu/jpgraph/) class for PHP.
// excel headers
header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: inline; filename=\"excel.xls\"");
header("Expires: 0");
header("Cache-Control: must-reva
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.
The file output for Excel is in the tab delimited format and the IMG tag
is what calls the graph. I ha
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>
Does anyone know of any free Excel parsing non-COM code available on
the
net? Just straight php driven?
I have not tried any of these but there might be something in here you
can use.
http://www.phpclasses.org/search.html?words=Excel&go_search=1
--
PHP General Mailing List (http://www.php.ne
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 unsubscribe,
EMAIL 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 dow
om: daniel [mailto:[EMAIL 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() {
7;re going to have to use COM or something similar on a windows
server to get effective access to the server.
Another option is dynamically adding at as an odbc datasource and querying
it. Again, this will only work on a windows server...
It's all much easier if you can convince users to upload csv files.
-
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 know
>>
>>>= Original Message From <[EMAIL PROTECTED]> =
>>>Yeah... you're going to have to use COM or something similar on a windows
>>>server to get effective access to the server.
>>>
>>>Another option is dynamically adding at as a
>Another option is dynamically adding at as an odbc datasource and querying
>>it. Again, this will only work on a windows server...
>>
>>It's all much easier if you can convince users to upload csv files.
>>
>> - jon
>>
>>-
>>jon
effective access to the server.
>
>Another option is dynamically adding at as an odbc datasource and querying
>it. Again, this will only work on a windows server...
>
>It's all much easier if you can convince users to upload csv files.
>
> - jon
>
>-
>jon
nior 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
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
--
PH
ince users 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
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: http://www.php.net/un
Sent: Thursday, March 27, 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
-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,
Hi,
Can someone point me to a php and Excel tutorial?
tnx.
> 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 othe
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, Mi
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 a
1 - 100 of 130 matches
Mail list logo
