Write multiple xls files without closing the program?

[CJohnson]

Hi all. I've got a pretty simple question. If I write to an XLS component and call XLS.Write, it writes the file as I want it to. If I change data and write to it again, the original data is still there in the component.

If I want to start over with an empty XLS component to do a second file, or write over the original file, how do I do it without closing and reopening the application?

Using Delphi 5.

[larsa]

Hello

Use: XLS.Clear;

[CJohnson]

Hi Lars. On subsequent runs, I get a 'List index out of bounds' error when I assign values to a cell. It varies which cell it is I write to depending on the size of the data. Any ideas?

[CJohnson]

I sorted it out just by dynamically creating the XLS.