Re: [PHP] export data to a ms excel file using php

2008-10-23 Thread Ashley Sheridan
On Thu, 2008-10-23 at 13:05 +0530, gopi krishnan wrote: > Hi, > > Could any one explain better. I need just the grid lines for the excel > sheet. I already tried that but it shows the linings only > to the valued cells. But i need to show the grid as in MS Excel. I tried > TEXT/XML > but i get th

Re: [PHP] export data to a ms excel file using php

2008-10-23 Thread Jim Lucas
gopi krishnan wrote: > Dear all, > > I found the solution for my problem. > try this core... > > --- > > #Setting MIME Type in header > /*header("Content-Type: application/vnd.ms

RE: [PHP] export data to a ms excel file using php

2008-10-23 Thread Boyd, Todd M.
> -Original Message- > From: Yeti [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 23, 2008 9:36 AM > To: gopi krishnan; PHP - General > Subject: Re: [PHP] export data to a ms excel file using php > > I'm not into MS Office, but isn't there some weird O

Re: [PHP] export data to a ms excel file using php

2008-10-23 Thread Yeti
I'm not into MS Office, but isn't there some weird Office XML format since Office 2007? At MSDN I could find a nice description of the wannabe standard [1]. So if the new Excel can take XML it wouldn't be too difficult to export the data I guess. [1] http://msdn.microsoft.com/en-us/library/aa33820

Re: [PHP] export data to a ms excel file using php

2008-10-23 Thread gopi krishnan
Dear all, I found the solution for my problem. try this core... --- ';*/ # Then we fetch rows in a loop until we're done while ($result = oci_fetch_array($stmt)) { /*echo "gopi

RE: [PHP] export data to a ms excel file using php

2008-10-23 Thread Jay Blanchard
[snip] Could any one explain better. I need just the grid lines for the excel sheet. I already tried that but it shows the linings only to the valued cells. But i need to show the grid as in MS Excel. I tried TEXT/XML but i get the following error [/snip] http://evolt.org/node/26896 Part of the

Re: [PHP] export data to a ms excel file using php

2008-10-23 Thread gopi krishnan
Hi, Could any one explain better. I need just the grid lines for the excel sheet. I already tried that but it shows the linings only to the valued cells. But i need to show the grid as in MS Excel. I tried TEXT/XML but i get the following error --- The XML page cannot be

Re: [PHP] export data to a ms excel file using php

2008-10-22 Thread Ashley Sheridan
On Wed, 2008-10-22 at 22:04 +, [EMAIL PROTECTED] wrote: > The easiest solution is to output CSV, and use the Content-type to force it > to be eXcel. > > > > Excel will suck the CSV in just fine, with minimal hassle by the user. > > > > It also makes a file that is useful for many more ap

Re: [PHP] export data to a ms excel file using php

2008-10-22 Thread ceo
The easiest solution is to output CSV, and use the Content-type to force it to be eXcel. Excel will suck the CSV in just fine, with minimal hassle by the user. It also makes a file that is useful for many more applications, not just Excel. -- PHP General Mailing List (http://www.php.net/)

Re: [PHP] export data to a ms excel file using php

2008-10-22 Thread Nitsan Bin-Nun
And what about users who use office version < 2003 (which do NOT support .xml charts) You can google a bit, I'm pretty sure I have already encountered a class for this case at Manuel's site (phpclasses). Nitsan On Wed, Oct 22, 2008 at 9:00 PM, Ashley Sheridan <[EMAIL PROTECTED]>wrote: > On Wed,

Re: [PHP] export data to a ms excel file using php

2008-10-22 Thread Ashley Sheridan
On Wed, 2008-10-22 at 11:20 -0700, Jim Lucas wrote: > [EMAIL PROTECTED] wrote: > > Hi, > > > > I have tried your MS-Excel MIME type in PHP. But am facing a small problem. > > I can't get the grid lines as look like in normal Excel file. > > > > Am using windows XP, Internet explorer 6.0, MS Exc

Re: [PHP] export data to a ms excel file using php

2008-10-22 Thread Jim Lucas
[EMAIL PROTECTED] wrote: > Hi, > > I have tried your MS-Excel MIME type in PHP. But am facing a small problem. I > can't get the grid lines as look like in normal Excel file. > > Am using windows XP, Internet explorer 6.0, MS Excel 2003 > > Thanks in advance.-- Jim Lucas wrote : > abderrazzak

Re: [PHP] export data to a ms excel file using php

2007-12-19 Thread Richard Lynch
On Tue, December 18, 2007 3:05 am, abderrazzak nejeoui wrote: > can you help me to export data to a ms excel file using php. i tried > to > export them to an html format and change the extension to .xls that's > work > but i have lost the formatting > > excel and the navigator doesn't interpret my

Re: [PHP] export data to a ms excel file using php

2007-12-18 Thread Chris
abderrazzak nejeoui wrote: can you help me to export data to a ms excel file using php. i tried to export them to an html format and change the extension to .xls that's work but i have lost the formatting excel and the navigator doesn't interpret my code in the same why (celles are not in the sa

Re: [PHP] export data to a ms excel file using php

2007-12-18 Thread Jim Lucas
Jim Lucas wrote: > abderrazzak nejeoui wrote: >> can you help me to export data to a ms excel file using php. i tried to >> export them to an html format and change the extension to .xls that's work >> but i have lost the formatting >> >> excel and the navigator doesn't interpret my code in the sam

Re: [PHP] export data to a ms excel file using php

2007-12-18 Thread Jim Lucas
abderrazzak nejeoui wrote: > can you help me to export data to a ms excel file using php. i tried to > export them to an html format and change the extension to .xls that's work > but i have lost the formatting > > excel and the navigator doesn't interpret my code in the same why (celles > are not

RE: [PHP] export data to a ms excel file using php

2007-12-18 Thread Jay Blanchard
[snip] can you help me to export data to a ms excel file using php. i tried to export them to an html format and change the extension to .xls that's work but i have lost the formatting excel and the navigator doesn't interpret my code in the same why (celles are not in the same size) [/snip] Here

Re: [PHP] export data to a ms excel file using php

2007-12-18 Thread Jason Pruim
On Dec 18, 2007, at 4:05 AM, abderrazzak nejeoui wrote: can you help me to export data to a ms excel file using php. i tried to export them to an html format and change the extension to .xls that's work but i have lost the formatting excel and the navigator doesn't interpret my code in the

RE: [PHP] export data to a ms excel file using php

2007-12-18 Thread Edward Kay
> can you help me to export data to a ms excel file using php. i tried to > export them to an html format and change the extension to .xls that's work > but i have lost the formatting Save the data from PHP in comma separated value (CSV) format. Edward -- PHP General Mailing List (http://www.p