how to read and write into excel files with wpf

Question

1.00/5 (3 votes)

See more:

Hi,
I Know this sounds easy but I've tried and I've tried but i'm just stuck in the middle of no where so , I want to be able to read a large multiple excel files in a windows presentation foundation application and i can edit this files.

I can't make mind of which path to choose or what should i do i'm really stuck because solutions for windows forms doesn't work, most of the times , for wpf and it doesn't bring the best out the windows presentation foundation technology which i want to take advantage from it.

Thanks

Posted 13-Aug-14 9:20am

Member 10743229

Add a Solution

Comments

[no name] 13-Aug-14 15:29pm

And we are suppposed to be able to figure out what your actual problem is from this?

PIEBALDconsult 13-Aug-14 15:46pm

Does it need to support only Excel 2007 and newer?
There are many articles here on CP that deal with reading and writing Excel files. Seek and you shall find.

Member 10743229 13-Aug-14 16:01pm

@PiEBALDconsult
No it has to support not only excel 2007 and the excel files are large and multiple files.
@Wes Aday
You can be much nicer to people, you were once a student and a beginner !!!

Sergey Alexandrovich Kryukov 13-Aug-14 16:12pm

No. Wes Aday does not have to be nicer; how about yourself?
He is asking you quite a legitimate question, not trying to hurt you at all, but with the purpose of helping you, which is also possible if you properly clarify your question. Instead of trying to improve your question, you are trying to distract discussion into imaginary offense. If you want to play offense card, how can you learn anything from people?

As to the "beginners": the beginner is the one who begins, not the one who looks for excuses. Don't get me wrong: I am not saying that you are doing something wrong, I just say that being a beginner is a very usual thing and does not give people any special status. Not only we all remember well how to be a beginner, we really help many beginner and most of us are still beginner, maybe in some different fields: when my horse riding trainer tells me that I'm treating the horse incorrectly, I don't say "be nicer", I try my best to treat the horse correctly. Can you see the difference?

—SA

Member 10743229 13-Aug-14 16:23pm

Don't get me wrong, but i've looked around and around and i don't wantto play the offense card, and i don't want any special treatment but just try to not hurt people's feelings.
You shouldn't get mad,try to be in my shoes.I've learned so many thing about and from people.It's about problem that i'm seeking your help andi'm sorry if anyone get hurted by me.

Sergey Alexandrovich Kryukov 13-Aug-14 16:34pm

Nobody went, mad, hope neither you. I just explained what I do when I am "in your shoes" and advised what to do. I think it was a useful advice. And I don't think anyone was hurt by you; all I wanted was to give you advice which could help you. And I'll give you some information on the topic as well.
—SA

[no name] 13-Aug-14 16:16pm

If you want to be offended by some imaginary slight, that is your business. "A student and a beginner" makes no difference. You have not made any indication at all what your actual problem is except some nonsense about "solutions for windows forms doesn't work, most of the times".

Member 10743229 13-Aug-14 16:25pm

I'm sorry.

[no name] 13-Aug-14 16:36pm

Please don't be sorry salma YEDDES. Try to see things from were we sit. We cannot possibly know what it it that you are doing, what you have tried to do or what your problem is. We can't see your code, your project or read your mind. All we know about your question is what you tell us. And as everyone here and over on SO have told you, you are being so vague that it is virutally impossible to tell what it is that you find so difficult.

Member 10743229 13-Aug-14 16:41pm

I have a wpf application and multiple large excel files: At runtime ,i want to be able to read this excel files just like in MS-Excel(whatever the version of the MS-Excel is)and i'll be able to edit the files by another window(that pop'sup like settings thing).Sorry i have no code i've lost because every time that i try some lines i delete what comes before.

[no name] 13-Aug-14 17:11pm

Okay.... and? Nothing you have said here is an actual problem. This is just some research you need to do. Find a library to read excel files and learn how to use it. Or do the excel interop thing. Plenty of examples all over everywhere for you to look at.

Sergey Alexandrovich Kryukov 13-Aug-14 16:03pm

It is absolutely irrelevant of it's WPF or not. WPF is just UI.
—SA

Member 10743229 13-Aug-14 16:16pm

but i'have been wondering if there's binding thing that make's it easier or best practice related to the wpf ??
And if there isn't please jut give me a link to a good article or tutorial i'have tried the excel library but there's issues that i can't fix and so many other .dll etc...
https://code.google.com/p/excellibrary/

Member 10743229 13-Aug-14 16:27pm

http://www.codeproject.com/Articles/16210/Excel-Reader
what the dgvcells are

Maciej Los 13-Aug-14 16:46pm

What you mean 'large Excel files'? Is there any special structure? Please, be more specific and provide more details about those Excel files.

4 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)

Sergey Alexandrovich Kryukov · Accepted Answer · 2014-08-13T10:40:00

It is not related to WPF, as I already noted in my comment to the question. Three most usual approaches are: 1) using Office interop assembly, 2) using Open XML SDK, 3) using 3rd-party products, mostly based on Open XML standard and directly forming the file of .xslx data structure.

I would recommend using Open XML SDK. Please see my past answers referenced in this on: How to add microsoft excel 15.0 object library from Add Reference in MS Visual Studio 2010[^].

See also this answer by Mika Wendelius, CodeProject member: Creating basic Excel workbook with Open XML[^].

Please see Microsoft warnings against using interop assemblies in certain settings:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2[^],
http://support.microsoft.com/kb/257757/en-us[^].

Good luck,

—SA

Maciej Los · Accepted Answer · 2014-08-13T10:54:00

If by saying 'large Excel files', you mean files containing structured data, i suggest you to use ADO.NET[^].

More:
How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET[^]
Accessing Microsoft Office Data from .NET Applications[^]
Using ADO.NET to work with Excel files[^]

And... the best collection of links:
USING ADO AND ADO.NET WITH EXCEL: Resources and Known Issues[^]

WPF related links:
Build Office-Based Solutions Using WPF, WCF, And LINQ[^]
Using WPF Controls in Office Solutions[^]

Andreas Gieriet · Accepted Answer · 2014-08-13T10:26:00

Solution 1

Fire up Excel and let Excel do the work?
Why emulating all the filtering, sorting, formula editing, etc. in a wpf application?

Or use a commertially available component for reading and writing the *files*, like http://www.tmssoftware.com/site/flexcelnet.asp[^] and only provide a simple grid editor.

We have no clue what your *real* requirements are - depending on your requirements, you open up the box of Pandora or it's a simple solution (or somethin in between).

E.g. do you want the full feature set from Excel, like all editing and error handling, all graphics capabilities, all relations and multi sheets, etc. etc.? Or do you just want to enter some data in a data grid, no sorting, no graphics, no filtering, no fancy stuff?

Cheers
Andi

PS: And please stop "whining". You do not show us any of your effort. This is not the place for "gimme solution". No obvious effort from your side usually does result in no answer.

Posted 13-Aug-14 10:26am

Andreas Gieriet

Updated 13-Aug-14 10:36am

v2

Comments

Member 10743229 13-Aug-14 16:36pm

I have a wpf application and multiple large excel files: At runtime ,i want to be able to read this excel files just like in MS-Excel(whatever the version of the MS-Excel is)and i'll be able to edit the files by another window(that pop'sup like settings thing).

Andreas Gieriet 13-Aug-14 16:40pm

Editing may mean many things: only cell text, or formulas and let them evaluate directly or create/modify graphics, or re-arrange columns and cells, have print ranges defined, etc.? What do you really need?

Sergey Alexandrovich Kryukov 13-Aug-14 16:43pm

Good points, a 5. I agree with you. Nevertheless, I posted some recommendation on writing Excel documents in Solution 2, please see. I also put a comment to the question, arguing on the OP's accusations against Wes Aday.
I agree with your advice on stopping whining, but you can expect some more unhappy response.. :-)
—SA

Andreas Gieriet 13-Aug-14 16:49pm

Thanks for your 5, Sergey!

Member 10743229 13-Aug-14 16:47pm

By editing i mean adding new rows that contains the settings data and deleting rows.

Andreas Gieriet 13-Aug-14 16:55pm

Ok, something concrete finally. In that case: simple data grid and an Excel file access library behind the scenes may do the work. The tricky part would be to not screw up unrelated data while editing elements that are referenced. If you have the file fully under control (e.g. no graphics and no references and no formulas), then it would be rather easy with any of the links as provided by Sergey (Solution 2). Otherwise, your task is probably too ambitious.
Cheers
Andi

Andreas Gieriet 13-Aug-14 16:58pm

Com'on down voters: let's talk and not hide in anonymity! Ready for a discussion or maybe have an alternative answer?
Have fun! ;-)
Andi

[no name] 13-Aug-14 17:07pm

Sorry I didn't inform you, I am the upvoter :-)

Andreas Gieriet 15-Aug-14 2:20am

Thanks for your 5 and for notifying ;-)
I know it's a fight against windmills... But you learn most from those who criticize/vote down - if they would speak up...
Cheers
Andi

[no name] 15-Aug-14 21:46pm

Sometimes. There are a few around that whine when they are downvoted and then if you tell them why, they whine about that too. Especially when it's obvious that they didn't even bother reading the question to begin with. Can't tell you how many times I was revenge downvoted by someone because I dared to tell them that we won't do their homework for them.

Maciej Los 14-Aug-14 6:47am

+5

Andreas Gieriet 15-Aug-14 2:15am

Thanks for your 5!
Cheers
Andi

Member 10743229 · Accepted Answer · 2014-08-21T06:57:00

Well i have used the ado.net solution and i've tried to make it work for the wpf:

C#

string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;
               Data Source=D:\TestData.xls;Extended Properties=""Excel 12.0;HDR=YES;""";


            string strSQL = "SELECT * FROM [Launch ClickPad$]";

            OleDbConnection excelConnection = new OleDbConnection(connectionString);
            excelConnection.Open(); 

            OleDbCommand dbCommand = new OleDbCommand(strSQL, excelConnection);
            OleDbDataAdapter dataAdapter = new OleDbDataAdapter(dbCommand);

           
            DataTable dTable = new DataTable();
            dataAdapter.Fill(dTable);
            
            
            dataGrid1.DataContext = dTable;
           
           
            dTable.Dispose();
            dataAdapter.Dispose();
            dbCommand.Dispose();

            excelConnection.Close();
            excelConnection.Dispose();*/

So this displays empty rows i don't know what the problem is ?? or what am i doing wrong

how to read and write into excel files with wpf

4 solutions

Solution 2

Solution 3

Solution 1

Solution 4

Add your solution here

Preview 0