Error when applying formula to Excel help

[22222222asas (그게 뭐라고)]

I used this code to concatenate cells, but it resulted in an error. Is there a way to use this code correctly?
Thank you in advance for your response!

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @22222222asas ,
You want to merge string of value many cell
change & to +
eg:
row(“A”).toString + row(“B”).toString +…
regards,

[pravallikapaluri]

@22222222asas
Need to use ‘+’ for concatenation instead of ‘&’

[22222222asas (그게 뭐라고)]

@Nguyen_Van_Luong1

Thank you so much for your answer.
I’m adding a formula to Excel, but for text connection, “=A2+”+A3" is also a problem?

[22222222asas (그게 뭐라고)]

@pravallikapaluri
Thank you so much for your answer.
I’m adding a formula to Excel, but for text connection, “=A2+”+A3" is also a problem?

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Have you tried
“=A2+A3”
regards,

[22222222asas (그게 뭐라고)]

@Nguyen_Van_Luong1
I have to put a space between the letters. Is there any possible way?

[pravallikapaluri]

@22222222asas

Excel.Sheet("Sheet1").Cell("B2")+"  "+Excel.Sheet("Sheet1").Cell("C2")

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Could you share your file and expect output
or formula by handwork
regards,

[22222222asas (그게 뭐라고)]

@pravallikapaluri

An error occurs if I use the write cell, is there a way to write it down?

[22222222asas (그게 뭐라고)]

I would like to do it in this way. Could you help me?

[pravallikapaluri]

@22222222asas

Excel.Sheet("Sheet1").Cell("B3").ToString+" "+Excel.Sheet("Sheet1").Cell("B4").ToString

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @22222222asas
If you use classic activity

regards,

[22222222asas (그게 뭐라고)]

@Nguyen_Van_Luong1

May I know the reason for the error?

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Could you show your message error
Excel.zip (9.0 KB)
my source
regards,

[22222222asas (그게 뭐라고)]

For Each Row in Data Table: Object reference not set to an instance of an object
The error message is this. Thank you.

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @22222222asas ,
You can check
read range has header

then in assign activity use header

regards,

[22222222asas (그게 뭐라고)]

@Nguyen_Van_Luong1
Thank you very much. I have resolved it with your response! I have one more question remaining. Should I create a new question for that? Once again, I’m in awe of your assistance

[22222222asas (그게 뭐라고)]

@pravallikapaluri
Thank you very much for your help It was more helpful because you let me know simply. Thank you! Have a great day!

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Yes, if you have any questions, please ask me
Cheer