[thelist] CSV+PHP EXCEL and MORE

Andrew Maynes andrew at humanbehaviour.co.uk
Mon Aug 19 14:14:00 CDT 2002


not really just not put right!

Could an excel worksheet output a csv file like this

PRODUCT;KiT / KaT 34;
TYPE;1;KiT 44;
OPTION1;0;-;-;
OPTION2;0;-;-;
PRICE;700.00;
OFFER;-;
WEIGHT;-;
TEXT;-;
END;

so it could then be read by php and updated within a php environment?

Andrew

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Jay Blanchard
Sent: Monday, August 19, 2002 07:29
To: thelist at lists.evolt.org
Subject: RE: [thelist] CSV+PHP EXCEL and MORE


[snip]
if I have csv file layout


PRODUCT;KiT / KaT 34;
TYPE;1;KiT 44;
OPTION1;0;-;-;
OPTION2;0;-;-;
PRICE;700.00;
OFFER;-;
WEIGHT;-;
TEXT;-;
END;

PRODUCT;KiT / KaT 34;
TYPE;1;KiT 44;
OPTION1;0;-;-;
OPTION2;0;-;-;
PRICE;700.00;
OFFER;-;
WEIGHT;-;
TEXT;-;
END;


etc, etc

is it possible to convert this into an excel spread sheet and then back
again?
[/snip]

Excel can read CSV files, PHP can read CSV files, so there is no need for
conversion. You can just choose to display wherever. Unless I am completely
misunderstanding your question.

Jay

***********************************************************
* Texas PHP Developers Conf  Spring 2003                  *
* T Bar M Resort & Conference Center                      *
* New Braunfels, Texas                                    *
* San Antonio Area PHP Developers Group                   *
* Interested? Contact jay.blanchard at niicommunications.com *
***********************************************************


--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/02




More information about the thelist mailing list