On 30 Jun, 13:37, Leonardo Calado <leonardo.cal...@gmail.comwrote:
I use a on-line version of spreadsheet "program" using PHP arrays to
simulate cells and MySQL database to store retrieve data. But I look
for also in PHP similar to Lookup().
Thanks for you help!
Lookup is effectively the equivalent of using an SQL query to find a
record of information using a key field.
I really wouldn't try to mimic the spreadsheet in php/mysql. It will
be much more efficient to look at what the aim of the spreadsheet is
and to re-write that properly as a php/mysql application.
Either way, your equivalent of LOOKUP is a basic SQL SELECT statement.
Somewhere just recently I came across a php class that operated as a
total "in memory" spreadsheet, complete with formulas. I'll try to
find it for you later.