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 report.
> I want some rows
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
> >>
> >> Hello, everyone.
> >>
> >> Just a quick question.
> >>
> >> What
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.
On 2/19/10, Hansen, Mike wrote:
>> -Original Message-
>> From: Ian Ro
> -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, t
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
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
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 ho
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/
You could also name the file *.csv and use a comma as a delimiter instead.
Don't forget to put quotes around any data that may have tab characters in
it. (Or commas if you're using csv)
Hope that helps
-B
> -Original Message-
> From: amit hetawal [mailto:[EMAIL PROTECTED]
> Sent: Th
[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
: 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
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
[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
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
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
:)...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,
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
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() {
The quotes are valid, use fgetcsv() function, it will strip them
daniel wrote:
ok guys are you ready ,
/www_tools/apache/catdoc/bin/xls2csv test.xls > test2.csv
gave me this
"column1`","column2","column3"
"faffafs","fsafsa","fsafs"
"fssfa","fasfs","fasfs"
"fasaf","fasfs","asffaf"
"fafs","sfafs
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
ok i've built a class to acomplish this now
class Export_Excel {
var $command
function Export_Excel() {
$this->command = "/www_tools/apache/catdoc/bin/xls2csv";
}
function xls2csv($path,$xls_file,$short_name) {
$cmd = escapeshellcmd(
ok it works now
/www_tools/apache/catdoc/bin/xls2csv -q 0 test.xls > test2.csv
column1`,column2,column3
faffafs,fsafsa,fsafs
fssfa,fasfs,fasfs
fasaf,fasfs,asffaf
fafs,sfafsa,fasfas
sfafs,fssfa,fassfa
sfasfa,asfafs,fasfas
asffas,sfaaf,sfafsa
fssaf,asffsa,asffas
sfasfa,sfasaf,fasasf
then i can lo
ok guys are you ready ,
/www_tools/apache/catdoc/bin/xls2csv test.xls > test2.csv
gave me this
"column1`","column2","column3"
"faffafs","fsafsa","fsafs"
"fssfa","fasfs","fasfs"
"fasaf","fasfs","asffaf"
"fafs","sfafsa","fasfas"
"sfafs","fssfa","fassfa"
"sfasfa","asfafs","fasfas"
"asffas","sfaaf"
http://www.ice.ru/~vitus/catdoc/ anyone seen this ? its pretty much wot i
needed, havent used it yet though
>= 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 op
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
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 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 t
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,
> 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
You could export, or save as a tab delimited text file, then go ahead and
use phpMyAdmin or a custom script to pull all that data into the database.
It really shouldn¹t be much of a problem coming from Excel.
Cheers!
Rick
"Finish each day and be done with it. You have done what you could; some
b
Have a look at my post of 17/05/2002, I got a lot of help from there.
Bye,
Evan
"Jean-Louis Letortorec" <[EMAIL PROTECTED]> ha scritto nel
messaggio 615315231286D21182E40008C7B1EED241EDF7@COMPAQ3000">news:615315231286D21182E40008C7B1EED241EDF7@COMPAQ3000...
> Hello every one:
>
> I'm trying to
hi,
i just wanted to put in a plug for my own code to generate dynamic Excel
or Word files here. it's ultra easy to use:
http://sourceforge.net/projects/php-doc-xls-gen/
thanks,
tom
Pavel Jartsev wrote:
>
> Iván Toda Caraballo wrote:
>
> > Hello,
> >
> > I am using the Unix version
Iván Toda Caraballo wrote:
> Hello,
>
> I am using the Unix version of PHP, and i would write some information from
> the HTML in a Excel file. I was made this using COM functions in a Windows
> version of PHP and it works. But COM functions are only available on the
> Windows version of P
I use to save my access data to a dbf file and then use the dbf2mysql (see
www.mysql.com site).
dbf2mysql will create proper tables and export data to the mysql really
faster than odbc.
Very easy.
I have exported someting like 5.000.000 records into 8 differents tables in
4 hours (3 cdroms of acce
Guys getting more serious here now, 3 500 000 records, foxPro
i'll try Jeff's method
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
On Saturday 27 October 2001 17:11, Daniel Harik wrote:
> You see i have huge(for me) 100 000 record access table, i wanted to
> convert it to mysql, i thought of making php convertor that uses odbc
> and mysql, but maybe there is faster way?
Your subject says "excel" but above, you say "access".
I used Jeff's method
http://adsl20066.estpak.ee/emt here is it working live
Thank You Jeff so much
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAI
Sent: Saturday, October 27, 2001 10:30 AM
>To: Daniel Harik; [EMAIL PROTECTED]
>Subject: Re: [PHP] Excel to MySQL
>
>
>At 04:11 PM 10/27/01 -0800, Daniel Harik wrote:
>
>>You see i have huge(for me) 100 000 record access table, i wanted to
>>convert it to mysql, i tho
: Saturday, October 27, 2001 10:30 AM
To: Daniel Harik; [EMAIL PROTECTED]
Subject: Re: [PHP] Excel to MySQL
At 04:11 PM 10/27/01 -0800, Daniel Harik wrote:
>You see i have huge(for me) 100 000 record access table, i wanted to
>convert it to mysql, i thought of making php convertor that uses odb
At 04:11 PM 10/27/01 -0800, Daniel Harik wrote:
>You see i have huge(for me) 100 000 record access table, i wanted to
>convert it to mysql, i thought of making php convertor that uses odbc
>and mysql, but maybe there is faster way?
Daniel,
You're making it too hard on yourself.
1. CREATE TABLES
Probably not exactly the answer that you're looking for, but you can do the
following. Output your data in PHP to a webpage that consists of purely a
table of your data. Open Excel, go to :
Data->Get External Data->New Web Query
Type in the URL for the page with your data.
Select which t
> I tried using the code below to send the output to an Excel sheet in my
> browser by changing the header to "Content-type:
application/vnd.ms-excel".
> However I only see normal text in a browser. Excel is not launched. What
is
> wrong??
>
> --
76 matches
Mail list logo
