[nycphp-talk] Reading an excel file with PHP
Ben Sgro (ProjectSkyLine)
ben at projectskyline.com
Mon Aug 20 11:48:57 EDT 2007
Hello Aaron,
Yes, I'm doing the conversion in php, calling the CL utility xls2csv and
taking
its output and writing it to file.
Code included. I removed my processing on the data, since I don't know what
you want
to do with it. This partial script goes through each file in the target
director and converts from
.xls to /converted/.csv
You can do as you please after. Its got libs that aren't open source though.
If you need access to particular function calls or classes, let me know.
So, yeah, this script isn't of much use to you I guess. Sorry.
- Ben
Ben Sgro, Chief Engineer
ProjectSkyLine - Defining New Horizons
Our company: www.projectskyline.com
Our products: www.project-contact.com
This e-mail is confidential information intended only for the use of the
individual to whom it is addressed.
----- Original Message -----
From: "Aaron Fischer" <agfische at email.smith.edu>
To: "NYPHP Talk" <talk at lists.nyphp.org>
Sent: Monday, August 20, 2007 11:28 AM
Subject: Re: [nycphp-talk] Reading an excel file with PHP
> Hi Ben,
>
> I've been looking into working with csv. That seems like a nice way to
> go. Do you use PHP to convert the .xls files to .csv? Yes, I'd be
> interested in source. Thanks Ben.
>
> -Aaron
>
>
> On Aug 20, 2007, at 11:19 AM, Ben Sgro ((ProjectSkyLine)) wrote:
>
>> Hello Aaron,
>>
>> I convert .xls files to .csv files and then do parsing/manipulation.
>>
>> I can include source if you want it.
>>
>> - Ben
>>
>
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: sifter.txt
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20070820/455e4ae3/attachment.txt>
More information about the talk
mailing list