Copy one excel file's worksheet cell with data to other excelfile worksheet in same cell in C#

Question

0.00/5 (No votes)

See more:

I am exporting some data to excel files. so files came.with Other excel file is there with same cells. I want to copy the cell with data of one file to other excel file with the help of c#. how can I do this.

What I have tried:

I searched in google but no suitable result.

Posted 31-Aug-17 22:02pm

vijay_bale

Updated 1-Sep-17 2:36am

v4

Add a Solution

3 solutions

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)

theoldfool · Answer 1 · 2017-09-01T02:36:00

Solution 3

Another option is the ClosedXML library available via Nuget.
[^]
Some documentation and examples here:
Home · ClosedXML/ClosedXML Wiki · GitHub[^]

Posted 1-Sep-17 2:36am

theoldfool

Richard MacCutchan · Answer 2 · 2017-08-31T22:09:00

Solution 1

There are plenty of articles on using OLEDB and/or Excel Interop in C#. See Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^] and How to: Access Office Interop Objects by Using Visual C# Features (C# Programming Guide) | Microsoft Docs[^].

Posted 31-Aug-17 22:09pm

Richard MacCutchan

Graeme_Grant · Answer 3 · 2017-09-01T02:00:00

An addendum to Richard's solution, here is a simple trick that I use...

To learn the excel commands to perform the task from C#, open an excel spreadsheet, start the macro recorder, do the actions manually that you want your C# app to perform, stop the macro recorder, and view the macro generated by excel. Now you know the commands that your C# app must perform.