Reading or writing to particular cell in excel

activities
studio

#1

Hi, I have a filtered data table from excel. I need to input data to the particular cell of rows in excel sheet using the filtered data table. Can I get an idea for this!!?

Ex: Datable is [Name,EmpID,Email,Period,Salary,Status
Bharath,QI017,bharath.s@gmail.com,Feb 2018,1000000
Jason,QI999,bharath@gmail.com,Mar 2018,600000
Khasim,QI014,Kashim.p@gmail.com,Feb 2018,10000
]

I need to write on a cell of only these 3 rows of all the rows available in excel sheet. Please help me.


#2

Hi ppl, are there any logic or activities to read or write cells in excel using Column name and row number, !? It would be really great if i get solution for this


#3

@BharathOliver In the read range activity give staring and ending cell range which you want to read


#4

I appreciate your reply, my requirement is to find the only cell, based on known column name and input under some other column name in same row.Requirement