How Can I write data into the specific cell of excel sheet or data table?

Pratik_Wavhal · August 10, 2020, 2:52pm

You should use Write Cell Instead of Assign Activity as below :-

I am attaching the workflow for the same :-
MainPratik.xaml (7.5 KB)

Note :- Within WriteCell Activity in the Range property instead of “A” use the Alphabet Letter of the column in which you want to write the Values

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

Topic		Replies	Views
How to write on a cell column name based Help datatable , excel , uiautomation , studio	15	6081	March 24, 2023
Write data in existing data row Learn datatable , activities , question	16	1277	July 20, 2020
How to Configure Write Cell Activity Inside a For Each Row Loop to Write A value In A Cell Help excel , studio , question	23	2893	November 5, 2019
How to loop and write Activities excel , activities , question	28	1796	July 6, 2022
Write cell in for each loop Studio studio , question , activities_panel	12	381	August 10, 2023