How to copy one sheet data to another sheet using openxml

See more:

C#

ASP.NET

OpenXML

Hi,

I want to copy sheet1 data to sheet2 with some particular range. like below

sheet1 data

1 John 123
2 Max 235
3 Steve 265

Sheet2 have 3 header

Sno Name ID

Expecting :

in Sheet2


Sno Name ID
1 John 123
2 Max 235
3 Steve 265

What I have tried:

Formula1 formula = new Formula1();

                   formula.Text = "'Sheet1'!$A$1:$C$1";
                   sdInput.Append(formula);

Not sure this is correct or not