I need to write a details in excel sheet. The column range is not fixed. Example: KVA 1125 1125 VOLTS/PHASE 480 120.0889 CURRENT WDG/LINE 781.25 / 1353.165 3122.688 / 3122.688 Output: [Capture] Here I used Space to split the above string. I need to write a each split string in a separate colu…

You can use below method to easily manipulate data and write into Excel. [image] How to enter column values from text to data table Help Use the activity Generate Data Table and specify the column and row separators, this activity will generate the required datatable [2…

Write a details in the excel sheet

Help

Vinutha December 12, 2018, 5:06pm 2

You can use below method to easily manipulate data and write into Excel.

3 Likes

Topic		Replies	Views
How to do split data while writing a data to excel Help	5	1339	November 29, 2018
Im using get text to get data from few fields I want to write in one column accordingly Studio excel , uiautomation , activities , studio	5	242	July 17, 2023
Write datatable column in excel row Help	8	2654	January 28, 2020
How can i write string data in excel in new line Studio datatable , excel , uiautomation , robot , activities , question , loop , row	2	669	January 23, 2023
How do I write Data from text file to Excel? Help excel , activities	17	4375	August 23, 2019

Most Active Users - Yesterday
Anil_G
Ajay_Mishra
pravallikapaluri
postwick
AJ_Ask
Anonymouss
vignesh.maruthappan
mkankatala
mrohan.senapaty
ATHEEQ_UR-RAHMAN
More details...

Write a details in the excel sheet

Related Topics