Author: Jonas Bilinkevicius

Copy one Excel worksheet to another

Answer:

Call the copy method of that worksheet:

1   { ... }
2   var
3     After: OleVariant;
4     Sh: _Worksheet;
5   begin
6     Sh := Excel.Worksheets['Sheet1'] as _Worksheet;
7     After := Excel.Workbooks[1].Sheets[3];
8     Sh.Copy(EmptyParam, After, lcid);
9     { ... }