C# Excel from textbox to excel cell

Question

I've a little problem about to copy and paste from textbox to excel cells. Basicly, When I get data from website to textbox, I can not put this values into excel cells regularly.

My data:

xxxxxxx-qqq-1111-13661 3********************* 01/02/2020 02/03/2016 0

xyzxyzx-qqq-2222-11067 3********************* 02/03/2016 12/09/2028 0

qazwsge-qqq-1234-01940 6********************* 03/04/2015 09/01/2002 0

qweqwfe-qqq-4567-01941 6********************* 04/05/2013 17/06/2025 0         

You can see 4 space between columns.

When I copy this data from textbox with manually or [Clipboard.SetText(textBox1.Text)] technique, Again I can paste any excel sheet manually. But, When I selected any cell, I did selected and just one clicked to cell, I can paste my data one by one regularly. (When I double clicked to cell, I can not paste data to cells one by one, just stay into one cell)

I tried this code but, it gave reaction like a double click.

        Clipboard.SetText(textBox1.Text);
        Excel.Range area = (Excel.Range)xlPage.Cells[2,1];
        area.Value2 = Clipboard.GetText();

My question is, How can I do the works like manual with C# codes? Is it possible for this manual technique?

Best regards,

Answer 1

Thanks for your answers,

I found the solution. You can try the PasteSpecial method.

Clipboard.SetText(textBox1.Text); Excel.Range area = (Excel.Range)xlPage.Cells[2,1]; area.PasteSpecial();