lookup funcion

[Leonardo Calado]

Hi,

I wonder if there is php in a similar function to "Excel: Lookup
Function, http://www.techonthene t.com/excel/formulas/lookup.php".

I do not know much about Excel and your formulas, but I am try
converting an Excel spreadsheet and found this function.

Any help will be very grateful.

Thanks!

[Paul Lautman]

Re: lookup funcion

Leonardo Calado wrote:

Hi,
>
I wonder if there is php in a similar function to "Excel: Lookup
Function, http://www.techonthene t.com/excel/formulas/lookup.php".
>
I do not know much about Excel and your formulas, but I am try
converting an Excel spreadsheet and found this function.

What are you converting the spreadsheet to and what do you want to lookup?

[Leonardo Calado]

Re: lookup funcion

Lookup is part of formula used on spreadsheet logic.

Spreadsheet is a small software piece and grown mothan 100MB of data
in one .xls file. Now data from this file need bem posted on web and
Lookup is used.

[Jerry Stuckle]

Re: lookup funcion

Leonardo Calado wrote:

Lookup is part of formula used on spreadsheet logic.
>
Spreadsheet is a small software piece and grown mothan 100MB of data
in one .xls file. Now data from this file need bem posted on web and
Lookup is used.

We know what a spreadsheet is, and what a lookup function is.

The question is - what are YOU converting the spreadsheet to? Web
servers don't recognize spreadsheet data. Neither does PHP.

And What do YOU want to look up in that data?

Also, if you have 100MB of data, chances are you want a database.\

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

[Leonardo Calado]

Re: lookup funcion

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!

[Captain Paralytic]

Re: lookup funcion

On 30 Jun, 13:37, Leonardo Calado <leonardo.cal.. .@gmail.comwrot e:

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.

[Leonardo Calado]

Re: lookup funcion

I appreciate it very much!

I'm glad with your help on this!

[optimistx]

Re: lookup funcion

Leonardo Calado wrote:

I appreciate it very much!
>
I'm glad with your help on this!

http://instacalc.com/ might be interesting for you to compare with your
requirements.

[Paul Lautman]

Re: lookup funcion

Leonardo Calado wrote:

>I appreciate it very much!
>
I'm glad with your help on this!

As promised:

http://www.codeplex.com/PHPExcel

http://blog.maartenballiauw.be/post/2008/03/Reuse-Excel-business-logic-with-PHPExcel.aspx

http://examples.maartenballiauw.be/phpexcel4business/phpexcel4business.zip