Add static data in Excel cell without using write cell activity

[karthikeyan.s1 (Karthikeyan S)]

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?

[NIVED_NAMBIAR (NIVED N)]

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?

[Manish540 (Manish Shettigar)]

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

Hope this may help you

[491114473 (William)]

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

[karthikeyan.s1 (Karthikeyan S)]

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

[NIVED_NAMBIAR (NIVED N)]

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”)

[karthikeyan.s1 (Karthikeyan S)]

i wil try

[491114473 (William)]

It’s just what I need.
Thanks~