Copy data from one excel workbook column to another

Question

0.00/5 (No votes)

See more:

Hi all

I did the below code which is coping the data from one excel to other for a given range

but i have to copy the data to another worksheet's specific place. like it should copy after 5th row of the sheet and the range should be B1 to D1

Please tell me how to do that.

What I have tried:

C#

Excel.Application excelApplication = new Excel.Application();

            srcPath = "C:\\Users\\sn314708\\Desktop\\Excel\\1.xlsx";
            Excel.Workbook srcworkBook = excelApplication.Workbooks.Open(srcPath);
            Excel.Worksheet srcworkSheet = (Microsoft.Office.Interop.Excel.Worksheet)srcworkBook.Sheets.get_Item(1);

            destPath = "C:\\Users\\sn314708\\Desktop\\Excel\\2.xlsx";
            Excel.Workbook destworkBook = excelApplication.Workbooks.Open(destPath, 0, false);
            Excel.Worksheet destworkSheet = (Microsoft.Office.Interop.Excel.Worksheet)destworkBook.Sheets.get_Item(1);

            Excel.Range from = srcworkSheet.Range["A1:C100"];
            Excel.Range to = destworkSheet.Range["A1:C100"];

           
            from.Copy(to);

            destworkBook.SaveAs("C:\\Users\\sn314708\\Desktop\\Excel\\2 " + DateTime.Now.ToString("MM_dd_yyyy") + ".xlsx");

Posted 17-Feb-16 2:26am

Black_Rose

Updated 17-Feb-16 2:28am

v2

Add a Solution

Comments

Maciej Los 17-Feb-16 11:39am

Black_Rose, please see my comment to the Richard's answer. I'd suggest to change "from" and "to" variable names to "fromrange" and "torange" respectively.

2 solutions

Solution 2

Please, read my comment to the question. A from variable name is wrong. This is a reserved word. Please, see: C# Keywords[^]

I'd suggest to change the name of variable to fromrange - for example.

A "to" range doesn't need to be defined the same way as "fromrange" (doesn't have to be same size). It is sufficient to define it as a sigle cell:

C#

Excel.Range torange = destworkSheet.Range["B1"];

Posted 17-Feb-16 5:42am

Maciej Los

Updated 17-Feb-16 5:56am

v3

Comments

Richard Deeming 17-Feb-16 11:52am

Not quite: "from" is a contextual keyword. It's only a reserved word in particular contexts, such as a LINQ query. There's nothing wrong with using it as a variable name outside of LINQ.

Maciej Los 17-Feb-16 12:02pm

If contextual keyword is used outside of Linq, agree.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Accepted Answer · 2016-02-17T02:50:00

Solution 1

That should be as simple as changing the "to" range:

C#

Excel.Range to = destworkSheet.Range["B6:D105"];

Posted 17-Feb-16 2:50am

Richard Deeming

Comments

Maciej Los 17-Feb-16 11:35am

Richard, if you wanted to say that "to" is reserved word, i have to admit that i do not see it on the list of reserved words ;(
But "from" is one of the reserved words ;)
https://msdn.microsoft.com/en-us/library/x53a06bb.aspx

Richard Deeming 17-Feb-16 11:37am

No. Not sure where you've got that idea from?

All I'm saying is that to change the location where the data is pasted, you need to change the destination range stored in the to variable.

Maciej Los 17-Feb-16 11:45am

Richard, i'm not an inquirer ;)
You're wrong. "from" & "to" refers to different ranges, because they are in the different worksheets in the different workbooks.

Richard Deeming 17-Feb-16 11:48am

I'm well aware of that!

The OP's question is: how do I paste the values from one worksheet into another worksheet at a different address.
My answer is: change the destination address for the paste operation.

Not sure where this confusion is coming from?

Maciej Los 17-Feb-16 11:50am

Mea culpa, i missed that!
A 5!
BTW: Have you seen my answer?

Richard Deeming 17-Feb-16 11:51am

No problem. :)