Write to active excel using epplus c#

Question

0.00/5 (No votes)

See more:

Hai all,
Is possible to write data to excel while excel is open? Using EPPLUS library

I can do it if use interop service, but the problem is can't close EXCEL.exe in task manager.
I have tried to close with many way, but still get failed.

So, now i move to EPPLUS library, because EPPLUS create or and add excel data and then close it automatically.
Now the problem is, i cant write data to excel while excel is open.
Is possible to do it?
Thank you

Posted 7-Jul-14 6:33am

bonjot

Add a Solution

Comments

[no name] 7-Jul-14 14:05pm

No you will get exception that the file is opened by another user.

ZurdoDev 7-Jul-14 14:54pm

Yes, in general you can. You can't reopen the file as sankarsan is alluding to but you can get a handle on the existing instance of Excel. However, I know nothing of EPPLUS so I would check their documentation.

bonjot 7-Jul-14 14:57pm

okay thank you.
i have slidden my mind, maybe use how to prevent user to open the primary file which accessed by program.
i found it.
sorry for my bad english, thank you.

1 solution

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)

Maciej Los · Answer 1 · 2014-07-07T10:32:00

Solution 1

You don't need to give up with Interop. All you need to do is to release Excel objects.
How? Please, see: Releasing Excel after using Interop[^]
More information about your issue you'll find using Google[^].

Posted 7-Jul-14 10:32am

Maciej Los

Comments

bonjot 8-Jul-14 12:46pm

i have did it, releasing excel object and workbook.
maybe sometime i'll try again with code in that link. :D
now i want to try using epplus, it write data to excel faster than excel interop, and so simple how to use.
I want to ask again about EPPLUS, how to add series value to existing chart? Using EPPLUS, i still can't find the way yet.
thank you