How to insert new sheet in FarPoint Spread object?

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.