Re: PHP4 and MS Excel?
| From: | Jason Caldwell | Date: | Tue, 30 Jul 2002 18:46:21 +0000 |
| Subject: | Re: PHP4 and MS Excel? | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-110394@lists.php.net to get a copy of this message | ||
So -- it looks like I can connect to Excel via COM -- buuutt... anyone have
any examples or can anyone point me to any -- that show how to save-out an
excel file as a TEXT (.csv) TAB Delimited file?
I guess if there is a way to see each ROW in the Excel Spreadsheet -- then I
can grab that data and easily save it out as a \t delimited file (I know how
to do that) -- ***so, then*** I guess my real question is; how can I *see*
the data using COM ??? I'm not too familiar with COM.
Say I have an excel spreadsheet called "Test.xls" and it has three columns:
Name: Salary: Expense:
Jon Doe $63,000 $2,345
Jane Doe $65,234 $3,256
and so on...
Thanks
Jason
"Jome" <jome@emoj.net> wrote in message
news:20020730182546.28213.qmail@pb1.pair.com...
> > I would like to give my users the ability to send (to my website) a
> > Microsoft Excel file, and then have my server (PHP code) extract that
data
> > and turn it into a TAB Delimited Text file -- is this possible with PHP?
>
>
http://groups.google.com/groups?hl=sv&lr=&ie=ISO-8859-1&q=data+from+excel+ph
> p
>
> Google is your friend.
>
> -Jome
>
>