How to write on a cell column name based

datatable
excel
uiautomation
studio

#1


hi to the whole community
could someone give me a hand?
I would like to write some data inside the bascelomi excel sheet on the column name, but I do not know how to do it. I would be very grateful if you gave me a mane.

Thanks in advance


#2

@momi_fede what u want to write in this excel sheet exactly. can u be more specific?


#3

on the first column I would like to insert some codes, for example: 1234, 5678, 9012 etc …
in the other two my name and surname


#4

@momi_fede u can use add data Row activity


#5

Hey @momi_fede
If you want to write only one row the easiest way would be to use write cell activity

Please refer to the workflow attached :slight_smile:

Excel_Operations (1).xaml (8.0 KB)

Regards


#6

how can i implementing this?


#7

thank for your replace, but i want to write a row column name based


#8

From what source are you getting the values from which you want to write in the excel file?


#9

from a string[] values


#10

What you can do is that you can create a datatable and then add those string values in the data table…then pass that data table in write range for the particular excel file…


#11

I have to write my data on an existing excel file


#12

Try this

Excel_Operations (1).xaml (9.2 KB)

You’ll have to use either of the two methods
It’s always a good option to fetch the data with column names but while adding something you’ll have to use something like this


#13

if you have some data already saved in the excel just use Append Range activity instead of read range…
If it does not have any values, then just use read range as I told you


#14

I sent the above message before i read this, in place of read range use append range if you want to add to an existing file