RE: [PHP-DB] Excel Formulas
| From: | DPC) | Date: | Mon, 09 Aug 2004 21:14:21 +0000 |
| Subject: | RE: [PHP-DB] Excel Formulas | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-35634@lists.php.net to get a copy of this message | ||
> -----Original Message-----
> From: Norma Ramirez [mailto:norma.ramirez@tecnosoft.com.co]
> Sent: Monday, August 09, 2004 4:54 PM
> To: php-db@lists.php.net
> Subject: [PHP-DB] Excel Formulas
>
> Hi all, I need to integrate an aplication runing under Linux
> and postgresql with Excel formulas, I mean while I insert
> records in a table, for some of that records I need to
> calculate values using a Formula from excel, does any one
> know if that's posible, call any kind of function in excel
> for those calculations?
> Thank's in advance.
>
If you save the spreadsheet as CSV or tab delimited, all values will be
calculated, eliminating the need for parsing the formulas from the .xls
file.
So:
..1 2 3 4
A 10 15 =A1+B1
B 5 10 2
Will save as:
..1 2 3 4
A 10 15 25
B 5 10 2