Page 1 of 1

AsFormula

Posted: Sat Feb 02, 2019 10:16 am
by Joney_Hell
Hi!
How to write such a formula in a cell?
Dir:= 'C:/dir';
File:= 'File.xlsx';

xlSGrid.xls.Sheets[4].AsFormula[0,0]:=Dir+'\['+File+']sheet''!D7';



thank

Re: AsFormula

Posted: Sat Feb 02, 2019 2:31 pm
by larsa
Hello

Write the formula in Excel, save the file and open it then with XLSReadWriteII and check what is written in the cell.