Hi Vinaydhi,
As far as I understand, you want to add a sheet programmatically. You will need to use native methods and properties of the control for this. TestComplete allows doing this.
First of all, I suggest that you explore the vendor documentation to identify methods you can call from TestComplete. I've found this article. I think it may help you.
Also, I recommend that you review this example - it contains an example demonstrating how to read data from the FarPoint Spread control in TestComplete. You can use it to create your own function.
