Appending data to existing excel file using C#

Question

1.40/5 (2 votes)

See more:

I'm fairly new with C# and I am trying to export some data from a DataGridView in C# into an Excel file. The inputs from the datagridview are filled in by the user.

Currently, my program can create an excel file along with the values from the datagridview with the given date as its file name.

My problem is I can't seem to find a way to append the data from the gridview IF the excel file already exists, it overwrites the current excel file instead.

Any help/tips/suggestion is highly appreciated.

Thanks :)

[solved]

What I have tried:

solved

Posted 24-Jan-17 15:04pm

Member 12966494

Updated 25-Jan-17 11:47am

v3

Add a Solution

Comments

Member 12966494 25-Jan-17 17:28pm

solved it

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)

Neha Ambasta · Accepted Answer · 2017-01-24T17:49:00

Solution 1

Check this out,this may help you as I am doing the same just in VB.
How to Use EPPlus in VB[^]

If you want this code to be converted to C#,let me know.

Posted 24-Jan-17 17:49pm

Neha Ambasta

Richard MacCutchan · Accepted Answer · 2017-01-24T23:04:00

Solution 2

You already posted this in the C# forum at Appending data to existing excel file using C# - C# Discussion Boards[^]. Please do not post the same question in multiple forums.

Posted 24-Jan-17 23:04pm

Richard MacCutchan

Patrice T · Accepted Answer · 2017-01-24T23:22:00

C#

int lastRow_ = 3;

I fear you forgot to skip existing data before writing new data.
You need to detect existing data and write new data after existing data. you probably also want to not write headers again.

When you don't understand what your code is doing or why it does what it does, the answer is debugger.
Use the debugger to see what your code is doing. It allow you to execute lines 1 by 1 and to inspect variables as it execute, it is an incredible learning tool.

Debugger - Wikipedia, the free encyclopedia[^]
Mastering Debugging in Visual Studio 2010 - A Beginner's Guide[^]

The debugger is here to show you what your code is doing and your task is to compare with what it should do.
There is no magic in the debugger, it don't find bugs, it just help you to. When the code don't do what is expected, you are close to a bug.