Add static data in Excel cell without using write cell activity

I want to add a static data which is of same text but without using a write cell activity and iterating a counter, instead just a for loop, Can anyone help on this?

Hi @karthikeyan.s1

Welcome to forum

U can do by this simply assign datatable

dt1.Rows(0)(1) = “some text”

Where dt1 is the datatable

Do u want to add same text in all rows of Column?

1 Like

Check this below workflow @karthikeyan.s1
ExcelOps_UpdateCellWithoutWriteCell.xaml (6.0 KB)

Hope this may help you :slight_smile:

dt1.Rows(0)(1) = “some text”
You can only add one cell, but what if want to add a column?

Yes, but will this add to all the entire columns I wish to add

Yes u can even extend this to add data to all cells

But u can try this way in invoke code too

dt1.AsEnumerable().ToList().ForEach(Sub(row) row(1)= “some text”)

1 Like

i wil try

It’s just what I need.

1 Like