Is it possible to work directly in excel with out converting to data table?

excel

#1

Is it possible to work directly in excel with out converting to data table? i have demo tmrw can you please help


#2

Hi Madhu,

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!

Praveen Kumar
Director - Nanite Solutions


#3

HI Prvnk,

Thanks for your valuable information :slight_smile:


#4

Is it possible to perform filtering in excel directly with out data table value