Search found 2 matches

by jjsverylong
Fri Aug 06, 2010 6:40 am
Forum: XLSReadWriteII 3/4/5
Topic: MIN formula Error
Replies: 0
Views: 2571

MIN formula Error

I coded as follows. procedure TForm1.Button1Click(Sender: TObject); var loSheet: TSheet; i: integer; begin xls.Filename := 'TestXls.xls'; loSheet := xls.Sheet[0]; loSheet.AsFloat[0,0] := 30; loSheet.AsFloat[1,0] := 10; loSheet.AsFloat[2,0] := 20; loSheet.AsFormula[0, 1] := 'MIN(A1, B1)'; // this cel...
by jjsverylong
Thu Feb 11, 2010 6:44 am
Forum: XLSReadWriteII 3/4/5
Topic: How Can I Copy Sheet From Another XLS file?
Replies: 1
Views: 2919

How Can I Copy Sheet From Another XLS file?

A.XLS file has three sheets

B.XLS file has three sheets.

If I want to copy second sheet of A.XLS To third sheet of B.XLS, How can I do it?