How to query excel file in php?
<p>I want to compare the 1st column of two excel files and if a match is found, I need to copy value of the 5th column to another excel sheet. I've tried <code>php_excel_reader</code> and <code>php_excel_writer</code> but with no success.</p>

<p>I want something like this:</p>

<pre><code>excelF1;
excelF2;
for ($i=1; $i&lt;=rowlength(excelF1); $i++)
{
    val1 = excelF1[i][1];
    for ($j=1; $j&lt;=rowlength(excelF2); $j++)
    {
        val2 = excelF2[j][1];
        if(val1 == val2)
        {
            val3 = excelF2[j][5];
            //insert val3 into last column of excelF1;
        }
    }
}
</code></pre>
