How to import (export) from Excel to C#?

Question

excel

Tell me how to import (export) from (to) Excel from C # rummaged through the Internet, did not find a working method :(

Answer 1

And what do you want to get in the end? Not very clear, to be honest. If the data is read into the structure, then here: wladm.narod.ru/C_Sharp/comexcel.html

Answer 2

Have a look at ComponentOne Excel .Net

Answer 3

Google is very easy and fast.
If you just need to use the import / export of xls files: csharp.net-informations.com/excel/csharp-create-ex...
If you need integration with Excel, then msdn to help: msdn.microsoft.com/ru-ru/ library/ee342218.aspx

Answer 4

I suggest looking in the next direction. Suppose we need to write data to an Excel file. Moreover, the file must contain filters by columns and is designed in advance by the user (customer). For the solution, you need to change the file extension filename. xlsx to filename. zip . Unpack the archive.
In the directory into which the archive was unpacked, we are interested in:
Supplement files with your data (Linq To Xml). Pack everything into an archive, for example using SharpZipLib.
This approach will allow you to generate reports without requiring MS Excel to be installed on the user's computer (many people use Open Office). This approach is suitable for server solutions.