SilkTest cannot interact with Excel and hence you cannot automate this part - "create same grid with same column name in excel and enter some value for each cell copy this"
Well, Using ST u might wanna try inputting the data into an excel file which already has a macro written to copy the data from the excel sheet and paste it onto the clipboard. Then you can read that data from the clipboard using ST and paste it onto your application grid.
Have to disagree with 2lz. IME Silktest can interact reasonably well with Excel although I'll admit that the more clever you try and get with either form controls or cell/ranges, you do hit a brick wall eventually.
As you're working with datagrids, I suggest you look at using Excel named ranges, and use the DB_ExecuteSQL functions to move data between the AUT and Excel. I use named ranges frequently, but this technique depends on the shape and format of the data, so YMMV.
I think the user scenario which Rakesh is trying to automate is to actually copy the content from the excel file and then jus paste it onto the datagrid in the AUT. Coz that is something that he can do manually and would want the same to be simulated thru automation.
The reason I said that ST cannot interact with Excel was on the application UI level, which I m sure u will agree. Definately what u recommended is absolutely right but it will only work for him if he jus wants to read that data from Excel file and write it onto the AUT datagrid, but I think that is not what he wants to achieve here.
Rakesh plz correct me if I have misunderstood your requirement.