Re: PHP Working With Excel File ?
| From: | Erich Kolb | Date: | Mon, 01 Nov 2004 19:20:14 +0000 |
| Subject: | Re: PHP Working With Excel File ? | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-200860@lists.php.net to get a copy of this message | ||
I think the easiest way is to store your data in MySQL and then create a DSN
via MyODBC and connect to your spreadsheet.
"Matt M." <h.dudeness@gmail.com> wrote in message
news:7d4580200411010818435d1c5a@mail.gmail.com...
>> Can PHP work with Excel files as database ?
>> If not, how can I conver it to MySQL format and
>> reconvert it to Excel 'coz I need it to report it
>> in Excel format,
>
>
> if you are on windows you could use a com object.
>
> if you have access to perl, you could use
>
> http://search.cpan.org/~kwitknr/Spreadsheet-ParseExcel-0.2603/ParseExcel.pm
>