http://qs321.pair.com?node_id=663676


in reply to Re: How to use a formula in perl
in thread How to use a formula in perl

Hi sorry if it is a bot confusing, I have a script made in perl that generates a bunch of XLS files, but now I need to add some data on them but these data is store in another xls file call customs.xls, so I in excel create a formula using vlookup to get the data (just a customer number and the name of the customer) so I need to put the formula in the script and I just dont know how to do that add to a cell the formula and make the formula work. this is the formula that I need to put in my script but I have no Idea on how to do it
=VLOOKUP(A9,PATENTES.xls!$A$2:$C$82,2,FALSO)