SEO

#1 (**permalink**) 03-17-2008, 06:13 AM

When I export a MySQL table as CVS (with PHP) in order to create an
Excel-document, all data outout are comma separated. The excel-file
have all values separated with commas on one row each.
Is it possible to make all the data appear ordered in coloumns on an
Excel file, just as it is viwed in MySQL? Even better: With a styled
Excel-sheet?

#2 (**permalink**) 03-17-2008, 06:13 AM

On Tue, 11 Mar 2008 01:56:02 -0700 (PDT), Nosferatum wrote:
> When I export a MySQL table as CVS (with PHP) in order to create an

csv. CVS is a versioning system, or a pharmacy.

> Excel-document, all data outout are comma separated. The excel-file
> have all values separated with commas on one row each.
> Is it possible to make all the data appear ordered in coloumns on an
> Excel file, just as it is viwed in MySQL? Even better: With a styled
> Excel-sheet?

Write it in order, and it'll show up in the sheet in order.

Styled formatting of data in the rows will require a lot more work, and
you may want to look at perl's Spreadsheet::WriteExcel package. But
that's about as far as this should be taken here, as it's got 100%
nothing to do with MySQL.

--
I picked up a Magic 8-Ball the other day and it said 'Outlook not so good.'
I said 'Sure, but Microsoft still ships it.'
-- Anonymous

#3 (**permalink**) 03-17-2008, 06:13 AM

On 11 Mar, 13:41, "Peter H. Coffin" <hell...@ninehells.com> wrote:
> On Tue, 11 Mar 2008 01:56:02 -0700 (PDT), Nosferatum wrote:
> > When I export a MySQL table as CVS (with PHP) in order to create an
>
> csv. CVS is a versioning system, or a pharmacy.
>
> > Excel-document, all data outout are comma separated. The excel-file
> > have all values separated with commas on one row each.
> > Is it possible to make all the data appear ordered in coloumns on an
> > Excel file, just as it is viwed in MySQL? Even better: With a styled
> > Excel-sheet?
>
> Write it in order, and it'll show up in the sheet in order.
>
> Styled formatting of data in the rows will require a lot more work, and
> you may want to look at perl's Spreadsheet::WriteExcel package. But
> that's about as far as this should be taken here, as it's got 100%
> nothing to do with MySQL.
>
> --
> I picked up a Magic 8-Ball the other day and it said 'Outlook not so good.'
> I said 'Sure, but Microsoft still ships it.'
> * * * * * * * -- Anonymous

Thanks, I'll give it a try. I'm not the one that must have excel,
believe me.

#4 (**permalink**) 03-17-2008, 06:13 AM

"Nosferatum" <John.Olav.O@gmail.com> wrote in message
news:364ba34f-0713-4385-b442-6ac12cb8157d@q78g2000hsh.googlegroups.com...
> When I export a MySQL table as CVS (with PHP) in order to create an
> Excel-document, all data outout are comma separated. The excel-file
> have all values separated with commas on one row each.
> Is it possible to make all the data appear ordered in coloumns on an
> Excel file, just as it is viwed in MySQL? Even better: With a styled
> Excel-sheet?

CSV means comma separated values.
It is exactly what you asked for.

You should create an import specification in Excell for your files.

Richard.

#5 (**permalink**) 03-17-2008, 06:13 AM

On Tue, 11 Mar 2008 05:59:45 -0700 (PDT), Nosferatum wrote:
> On 11 Mar, 13:41, "Peter H. Coffin" <hell...@ninehells.com> wrote:
>> On Tue, 11 Mar 2008 01:56:02 -0700 (PDT), Nosferatum wrote:
>> > When I export a MySQL table as CVS (with PHP) in order to create an
>>
>> csv. CVS is a versioning system, or a pharmacy.
>>
>> > Excel-document, all data outout are comma separated. The excel-file
>> > have all values separated with commas on one row each.
>> > Is it possible to make all the data appear ordered in coloumns on an
>> > Excel file, just as it is viwed in MySQL? Even better: With a styled
>> > Excel-sheet?
>>
>> Write it in order, and it'll show up in the sheet in order.
>>
>> Styled formatting of data in the rows will require a lot more work, and
>> you may want to look at perl's Spreadsheet::WriteExcel package. But
>> that's about as far as this should be taken here, as it's got 100%
>> nothing to do with MySQL.
>
> Thanks, I'll give it a try. I'm not the one that must have excel,
> believe me.

FWIW, the perl thing is probably worth a long, hard look. It IS
complicated, but the module does work better than (at least I) expected,
and more than one person has parlayed that kind of skill into really
good job security.

--
The consquences of any action will never be fully understood until after
it's too late to do anything about it.
-- Schwartz's Second Law

#6 (**permalink**) 03-17-2008, 06:13 AM

On 11 Mar, 15:28, "Peter H. Coffin" <hell...@ninehells.com> wrote:
> On Tue, 11 Mar 2008 05:59:45 -0700 (PDT), Nosferatum wrote:
> > On 11 Mar, 13:41, "Peter H. Coffin" <hell...@ninehells.com> wrote:
> >> On Tue, 11 Mar 2008 01:56:02 -0700 (PDT), Nosferatum wrote:
> >> > When I export a MySQL table as CVS (with PHP) in order to create an
>
> >> csv. CVS is a versioning system, or a pharmacy.
>
> >> > Excel-document, all data outout are comma separated. The excel-file
> >> > have all values separated with commas on one row each.
> >> > Is it possible to make all the data appear ordered in coloumns on an
> >> > Excel file, just as it is viwed in MySQL? Even better: With a styled
> >> > Excel-sheet?
>
> >> Write it in order, and it'll show up in the sheet in order.
>
> >> Styled formatting of data in the rows will require a lot more work, and
> >> you may want to look at perl's Spreadsheet::WriteExcel package. But
> >> that's about as far as this should be taken here, as it's got 100%
> >> nothing to do with MySQL.
>
> > Thanks, I'll give it a try. I'm not the one that must have excel,
> > believe me.
>
> FWIW, the perl thing is probably worth a long, hard look. It IS
> complicated, but the module does work better than (at least I) expected,
> and more than one person has parlayed that kind of skill into really
> good job security.
>
> --
> The consquences of any action will never be fully understood until after
> it's too late to do anything about it.
> -- Schwartz's Second Law- Skjul sitert tekst -
>
> - Vis sitert tekst -

I did it all in PHP and it works just as I wanted! Perfect export to
Excel!

#7 (**permalink**) 03-17-2008, 06:13 AM

On Mar 12, 2:23 pm, Nosferatum <John.Ola...@gmail.com> wrote:
> On 11 Mar, 15:28, "Peter H. Coffin" <hell...@ninehells.com> wrote:
>
>
>
> > On Tue, 11 Mar 2008 05:59:45 -0700 (PDT), Nosferatum wrote:
> > > On 11 Mar, 13:41, "Peter H. Coffin" <hell...@ninehells.com> wrote:
> > >> On Tue, 11 Mar 2008 01:56:02 -0700 (PDT), Nosferatum wrote:
> > >> > When I export a MySQL table as CVS (with PHP) in order to create an
>
> > >> csv. CVS is a versioning system, or a pharmacy.
>
> > >> > Excel-document, all data outout are comma separated. The excel-file
> > >> > have all values separated with commas on one row each.
> > >> > Is it possible to make all the data appear ordered in coloumns on an
> > >> > Excel file, just as it is viwed in MySQL? Even better: With a styled
> > >> > Excel-sheet?
>
> > >> Write it in order, and it'll show up in the sheet in order.
>
> > >> Styled formatting of data in the rows will require a lot more work, and
> > >> you may want to look at perl's Spreadsheet::WriteExcel package. But
> > >> that's about as far as this should be taken here, as it's got 100%
> > >> nothing to do with MySQL.
>
> > > Thanks, I'll give it a try. I'm not the one that must have excel,
> > > believe me.
>
> > FWIW, the perl thing is probably worth a long, hard look. It IS
> > complicated, but the module does work better than (at least I) expected,
> > and more than one person has parlayed that kind of skill into really
> > good job security.
>
> > --
> > The consquences of any action will never be fully understood until after
> > it's too late to do anything about it.
> > -- Schwartz's Second Law- Skjul sitert tekst -
>
> > - Vis sitert tekst -
>
> I did it all in PHP and it works just as I wanted! Perfect export to
> Excel!

Care to share how do you it with PHP ?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Formatting MySQL-output to XLS