Is it possible to work directly in excel with out converting to data table? i have demo tmrw can you please help
yes it is possible to work directly in excel but it works at a cell level and not the whole set.
You can use “Write Cell” activity and give the properties for the worksheet and cell name (eg: “K1”) and directly write the value into the cell.
Another option is to use clipboard activities like copying the range in memory and then using send keys to a foreground excel sheet with ctrl +v or Paste, type of commands.
Hope this helps you out. Good luck!
Director - Nanite Solutions
Thanks for your valuable information
Is it possible to perform filtering in excel directly with out data table value