hii guys, can any one tell me how to get to get the particular cell value from the excel sheet,say i want some value from column1.
If you know the particular cell you can just use a Read Cell activity and pass it the relevant cell.
If cell is fixed then use Read Cell Activity and Specify the cell that you want to read and sheet name. It will give you output as String.