How to read and write excel data through .net

Question

Hi,

Can anybody send me the code sample to read one excel file and write the content of the excel file to another excel file. It is very urgent. Please help me on the same.

Answer 1

Have a look at Microsoft.Office.Interop.Excel namespace. Here are some examples from Microsoft.

Answer 2

For exporting to Excel, you can try Aspose if you're OK with paid third party tools.

Answer 3

Check these links:

http://excelwrapperdotnet.codeplex.com/

and

http://exceldatareader.codeplex.com/

After reading, you need to modify accordingly.